Filter by formula

Highlighted
Super Contributor

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

 

9 REPLIES 9
Highlighted
Valued Contributor

Re: Filter by formula

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?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Super Contributor

Re: Filter by formula

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

Highlighted
Super Contributor

Re: Filter by formula

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

 

Highlighted
Super Contributor

Re: Filter by formula

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. 

Highlighted
Super Contributor

Re: Filter by formula

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

 

Highlighted
Super Contributor

Re: Filter by formula

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

 

 

 

Highlighted
Frequent Contributor

Re: Filter by formula

@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

Highlighted
Valued Contributor

Re: Filter by formula

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.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Super Contributor

Re: Filter by formula

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