Filter in Confiform table based on another Confiform table

Dhiraj Kr_ Gupta May 2, 2024

There are two Confiform table T1 and T2. And each contains field suppose "Created".

I want to keep only those records by filtering in table T1 when value in the field in "Created" in Table T1 and Table T2 is not same.

1 answer

0 votes
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 4, 2024

Hi @Dhiraj Kr_ Gupta 

Created is a reserved field name and should not be used for user defined fields, let's assume the field name is Date

So, assuming the forms configurations are as below (Date fields in both forms)

Screenshot 2024-05-04 at 23.17.16.png

Where the filtering then can be something like this

Screenshot 2024-05-04 at 23.17.28.png

_func.queryCount(T2:@self;Date:[entry._func.asEntryRef(entry.Date)]):0

Alex

Dhiraj Kr_ Gupta May 6, 2024

It seems confusing, Table T2 is in different page. Also finally i wanted to remove records which are same ( or common) in T1 and T2

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 6, 2024

This filter removes records that have a matching in the other form.

Exactly what you have asked in the question

 

Dhiraj Kr_ Gupta May 6, 2024

Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events