If statement in forms and auto increment field

Issues related to forms.
Post Reply
Macoland
 
 
Posts: 7
Joined: Mon Oct 09, 2023 9:13 pm

If statement in forms and auto increment field

Post by Macoland »

Hey there, been a user of this software for years and sometimes I stumble across ways of doing things that I had been doing manually for a while. With that in mind I have two questions that hopefully aren't too complex.

First, is is possible to have an "IF" statement for form data. For example if I have a form for registering cars, I want to collect the user data, but the user might want to register one car, or two, or even three. In that case I would want to check the form data and basically have an If statement that says (if the first car has fields populated put that in the SQL database, and if a second car has been added, add that to SQL also). Not sure if there is an easy way to do something like that built into the software or if I just need to code it manually.

Second, is it possible to have an ID number that is associated with a user and cars 1 and 2 but auto-increments for the next user? IE Bill fills out the form and submits two cars, so he is given the ID of (some number) and that number is also added to cars 1 and 2. Then when the next user submits, it auto increments and uses that same number for those cars.

Like I said I can do these manually if needed, but wanted to double check before going through the effort. Thanks!
User avatar
Pablo
 
Posts: 23234
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: If statement in forms and auto increment field

Post by Pablo »

You can use conditions to implement 'IF' statement.
However, if you want to work in combination with a database, then you will need to implement a script. There is no way to do that visually.

More information about conditions:
https://wysiwygwebbuilder.com/conditions.html
Post Reply