How to create auto-INCREMENT field??

I tried to create a calculation field but it is not possible to get from sql and add 1 ... SQL select also does not work ... I tried to get data according to the documentation and it showed error every time ... even though the same select worked in different moules ...
mention that I wanted to download from the table created in the visform

I know there is an id field, but in my case the field should be 2022-xx
xx- will be the id of the application for a given year and must be generated by itself, but it must also be visible on the application form
 
 

Hello skidowitz,

1) Referring to 'it is not possible to get from sql and add 1'
There are so called aggregate functions and specific operators in MySQL SQL to do mathematics.
Please refer to MySQL or general Standard SQL manuals, as this is not the place to teach you SQL.

The SQL feature also comes with parameter replacement.
Using the parameter replacement, you can use current values of current user selections in your SQL statements.
More on this in the documentation here:
docs.joomla-4.visforms.vi-solutions.de/e...aceholder-in-the-sql

Fields of type 'Calculation' are intended to handle with values from other fields in the form, to do calculations on them.
They are not intended to work like fields from the SQL-types.
But you may use SQL-type fields to retrieve your values from the database and then use them with parameter replacement it in your calculation field.

2) Referring to 'SQL select also does not work'
Visforms is used by tens of thousands of users.
All known bugs will be fixed immediately and no problems are currently known.
The SQL feature works very fine.

As long as you do not state your SQL select statement, there is no way to tell you what is wrong with them.
Please state your actual statements in order to get help on them.

Have you consulted the documentation?
As you deal with Visforms own tables and fields and parameter replacement, there are some specifics to watch out for:
docs.joomla-4.visforms.vi-solutions.de/e...ds-with-option-list/

3) Referring to ' I wanted to download from the table created in the visform'
I have no clue what you are talking about.
Please describe your problem in more detail

4) You can have an individual additional ID field in a format that you like.
Format means numbers and text mixed together.
Please have a look at this forum thread, which exactly answers your question:
www.vi-solutions.de/de/support/forum/19-...ellung-eindeutige-id

5) The forum thread from above is in German.
Please use one of the commonly used translation tool to translate into your mother tongue.
I very much prefer the translation tools from Google.

6) You may consider to use a translation tool even when posting here.
- write in your mother tongue in Google Translate
- copy the English translation into your post

Hope this helps, Ingmar