Filter by formula

I have a particular existing module.

Now I want to create a new module which will only have the filter records.

Please assist.

 

Sravan_Kumar_0-1592029559098.pngSravan_Kumar_1-1592029579777.png

 

Answers

  • Hello @Sravan_Kumar 

     

    could you please clarify what is the filter exactly? 
    Will the user select a value to filter or there will be a different logic that will result in one “fruit” value?

  • Yes @einas.ibrahim, I want a new module which will contain data of Orange only and not any other fruits.

  • Hi @Sravan_Kumar 

     

    Why do you want to create a separate module, you can achieve this by just creating one filter and apply in this module itself and save the view.

     

    Screenshot_352.png

     

    Screenshot_353.png

     

    Hope this helps!

    Thanks

    Akhtar

     

  • Hi  Akhtar.shahbaz,

     

    I have a limitation, I can import from the module or can create reference formula.

    But I am not allowed to create a saved view.

     

    Please can you help suggesting any other alternative. 

  • Hi @Sravan_Kumar 

     

    One option is to create one extra line filter for orange  and then create a separate module to pull the information from your source module. other option is import action.

     

    Screenshot_357.png

     

    Screenshot_354.png

     

    Screenshot_355.png

    Screenshot_356.png

     

    Hope this helps!

    Thanks

    Akhtar

     

  • Hi @Akhtar.shahbaz,

     

    I am sharing my doubt.

    I want to delete the highlighted records.

    Is it possible, without creating a filter?

    Sravan_Kumar_0-1592046578350.png

     

     

     

  • Hi @Sravan_Kumar 

    Is "orange" going to change based on a user input for example? I'm sorry I can't get a clear understanding of the issue.

  • hi @Sravan_Kumar 

    you can set a subset in the list which will be true for all orange products, you can achieve it by running an import to mark the items true based on orange boolean 

    Kanishq17_0-1592230645963.pngKanishq17_1-1592230678048.png

    this can be setup as an action ,

    then use another module with the subset as a dimension and set another import to bring data from module to the other module

    Kanishq17_2-1592230761258.png

    this module has the subset of the main list as its dimension

     

  • @Sravan_Kumar 

     

    Requirement seems to be little confusing,

    1. Would you like to import the Orange records to another module..?

    2. Would you like to delete orange records..?

    3. Would you like to import orange records to another module and delete orange records from the primary module.

     

    Solution/Trick:-

    Adding on to the Solution of @Akhtar.shahbaz  

    abhi1017_0-1592235566257.png

    Create one more text line item in the above table  and write an if condition in it.

    IF Orange filter? then Blank else Fruit.

    abhi1017_0-1592238407280.png

    Then hide the first column. Similarly can be done for fruit type and count lineitems.

    Just a work around not a perfect solution though.

    "OR"

    If you want just delete the orange records:-

    Create an action "Clear list using Selection"  based on the Orange filter? lineitem as in above table.

    This will clear the Orange records rows completely.

     

    Hope this helps

    ~ Abhi