Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

ConfiForms: How to count records of connected form?

Markus Hintzsche September 26, 2024

Hi there,

 

I've got two forms, They are linked with smart classifier

Form Main with some fields 

Form Sub with some other fields and a smart classifier linked to form Main (storing id of record of Main)

 

In Form Main I want to display the count of Sub-Records, belonging to the corresponding record. Is there a way to achieve this?

 

What I tried so far:

implement IFTTT on Form Sub (on Create/on Delete) and action = Create/Modify Entry. That way I tried to increment / decrement a value of a numeric field of Sub Main. That worked but seems to be over engineered to me. Is there a simpler approach?

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
Alex Medved _ConfiForms_
Community Champion
September 26, 2024

Hi @Markus Hintzsche 

I dont think you need an IFTTT or anything like that

Could just use the queryCount function from https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

To get always up-to-date number of records matching the criteria

As always, you can use it in the ConfiForms Field macro's field name parameter or via [entry.field_name] notation, if you need it as a "raw" value

Alex

TAGS
AUG Leaders

Atlassian Community Events