add sequence number

Firstly thanks for such an excellent component, very well built and extremely useful. I'm trying to use visforms for a return material authorization form. Part of the requirement is to assign a sequential number to each submission. I need some flexibility in the makeup of the number (e.g. prefix letters, starting sequence number, suffix letters). I tried using the hidden field with a unique id but it really does not meet the need. Then I thought about customizing the lib/field/hidden.php to get the required functionality but not sure that's a file I can change/override and preserve upgrades etc. Lastly I wondered if the calculate plugin would allow for this kind of functionality, I suspect not, since I need to store the sequence number somewhere and increment on each submission. Any ideas or suggestions much appreciated.

Vince.

Hi Vince,

you had certainly read, that we were closed till today. So I read your post just today.
What you want is not possible with Visforms out of the box.

Basically you can create overrides in your template for each file that is located in the components/com_visforms/layouts folder. ( www.vi-solutions.de/en/documentations/vi...layout-with-override , sorry the documentation is not totally up to date but the basics are correct.). But not the lib/field.... file.

These overrides of files located in components/com_visforms/layouts will not be touched by Visforms updates and I try to avoid changes to these files in the components/com_visforms/layouts folder. But when I develop new features it is sometimes necessary to make changes to the layout files, too. This would mean, that you have to adapt your overrides, then.

Field type calculation will not work for this, it is really for calculating.

Regards,
Aicha

No problem. Thanks for the reply. I managed to create a workaround using database create trigger on the visform_1 table to manipulate the default value on the hidden field. It's a bit klugy but it works and avoids custom code in the component. Thanks again for an excellent form component.