How to get the total records in a form

Question

I am trying to calculate a field 'remaining seats' which is set by having the amount of records in the database from those who signed up using the form subtracted from the max capacity. I currently am using a ConfiForms Rules for Field Definition to edit a read-only field reamingSeats

Action to execute
set expression

Values to set

RemainingSeats=(50 - [entry._total] )

if there are 50 records currently in the dataset it should should 0 but it is only showing 49. How to access total record count and also max capacity that's set in ConfiForms Form Definition (so I wont have to hardcode 50 in the expression)

Alex Medved _ConfiForms_ · Answer

Hi @Lanae Jenkins

Try using the queryCount to get the total number of records stored in a form

https://wiki.vertuna.com/spaces/CONFIFORMS/pages/2359385/Virtual+functions

Answered you in more details in the private ticket you have opened in our support channel

Alex

Tomislav Tobijas · Answer

Hi @Lanae Jenkins ,

I haven't used ConfiForms myself, and I believe there are a couple of their representatives here in the forum, but you can also reach out directly to the vendor. Each app on Marketplace should have 'Support' tab on its listing; specifically, for ConfiForms, this is the link.
Here, you can find contact links and numbers (I'd say the recommended way is to use their official service desk) to reach their support team.

Vendors are usually quite responsive and willing to help if you have troubleshooting or use case questions related to their app.

Cheers,
Tobi