nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Alice Liu_gjljc8

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

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.

Accepted answers

Alex Medved _ConfiForms_

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

All comments

Alex Medved _ConfiForms_

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

Alex

Alice Liu_gjljc8

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_gjljc8

Got it. Thank you for the prompt reply.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

confiforms