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

Alice Liu May 22, 2023

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.

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 22, 2023

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 May 24, 2023

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 25, 2023

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

Alex

Alice Liu May 25, 2023

Got it. Thank you for the prompt reply.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events