Confiform dynamic filter/Filter control macro - Multiple Confiforms field logic settings and calc

[Alice Liu]

Hi there,

I created a form that stored data as below structure. Each entry has a unique ID.

Basically my purpose with the Filter control macro is like:

1. User input 2 different ID in the filter setting

2. click filter button

3. CardView macro will show the 2 column of data with user specified IDs

Macro setting is:

Filter control macro:

- Confiforms Field: field name = ID

- Confiforms Field: field name = ID

Q1: Final input to Filter control macro here should be "Or," but I found it seems to take the two lines as "And" relationship. So after clicking filter button, it shows nothing.

Could you help on this?

CardView macro with transpose enable:

- Confiforms Field: field name = ID

- Confiforms Field: field name = category

- Confiforms Field: field name = Qty

- Confiforms Field: field name = amount

Q2: Is it possible to generate a third column based on the filter ID result for calculating Qty subtraction?

Q2 is extending from Q1. The dynamic filter should always generate 2 column View result. Let's say column ID_1 and column ID_2.

Is there any way that I can generate automatically the 3rd column for calculate "column ID_1 - column ID_2," especially for Qty and amount?

Thank you.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

1. ConfiForms Filter Control macro creates an AND condition. It cannot create an OR condition for you

2. ConfiForms Filter Control does not generate anything - it applies the filter on the view macro which is configured to use by this Filter Control.  So, if you have such fields in the view then it will refresh those as well

Alex

[Alice Liu]

Hi Alex,

Thank you for the feedback. Then I think Filter Control macro would not be a suitable tool for my condition.

Wonder if you have any recommendation for create an OR condition filter on the view macro?

[Alex Medved _ConfiForms_]

Sorry, at the moment there is no built-in macro (or functionality) in ConfiForms app that could help you with that

Alex

[Alice Liu]

Got it. Thank you for the prompt reply.