-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
auto increment with prefix
- Thread starter leon14
- Start date
cheesegrits
Support Gopher
Yup, I added it a few months ago. There's no download ZIP for it yet (that'll happen in the next release), but if you do a full github update, you can then "Discover" and install it in J!'s extension manager.
It does exactly what you want. It has three different modes, which the tooltips on the element settings explain. In short ...
Form load mode ... this creates the sequence number when the form is loaded, so the number is visible (read only) on the form. However, you can end up with gaps in your sequence numbering, if someone loads the form but never submits it.
Form submit mode -... this creates the sequence number during form submission. This avoids gaps in the sequence, but means the sequence number is not available on the form before saving.
PK mode - in both of the above modes, the sequence number is unrelated to the primary key (PK, rowid) of the form, rather it is maintained in a special Fabrik metadata table. In PK mode, we use the rowid of the form as the numeric part of the sequence.
In all modes you can define whether the affix comes before (prefix) or after (suffix) the number. And you can use either static strings or element placeholders for the affix. So for instance if you wanted to include (say) the year as part of the sequence (XYZ-2017-0001), and you have an element on the form for the year, {yourtable___year}, your affix would be "XYZ-{yourtable___year}". And you can optionally have your sequence numbers roll back to the start value if the affix changes (so XYZ-2018 would start over).
-- hugh
It does exactly what you want. It has three different modes, which the tooltips on the element settings explain. In short ...
Form load mode ... this creates the sequence number when the form is loaded, so the number is visible (read only) on the form. However, you can end up with gaps in your sequence numbering, if someone loads the form but never submits it.
Form submit mode -... this creates the sequence number during form submission. This avoids gaps in the sequence, but means the sequence number is not available on the form before saving.
PK mode - in both of the above modes, the sequence number is unrelated to the primary key (PK, rowid) of the form, rather it is maintained in a special Fabrik metadata table. In PK mode, we use the rowid of the form as the numeric part of the sequence.
In all modes you can define whether the affix comes before (prefix) or after (suffix) the number. And you can use either static strings or element placeholders for the affix. So for instance if you wanted to include (say) the year as part of the sequence (XYZ-2017-0001), and you have an element on the form for the year, {yourtable___year}, your affix would be "XYZ-{yourtable___year}". And you can optionally have your sequence numbers roll back to the start value if the affix changes (so XYZ-2018 would start over).
-- hugh
I loaded up the element 3.8.1 , but I am getting an error "Table 'bitnami_joomla.#__fabrik_sequences' doesn't exist"
Did I miss a step?
I have tried the options 'on load' and 'on submit' and both give the same result. I tried 'use PK' and all values are 00 (eg INV00 irrespective of the PK)
Did I miss a step?
I have tried the options 'on load' and 'on submit' and both give the same result. I tried 'use PK' and all values are 00 (eg INV00 irrespective of the PK)
Last edited:
cheesegrits
Support Gopher
It should have been created when you installed the plugin (either from the ZIP, or through 'discover' after a github update).
But I've added a check to create it if it doesn't exist when you use it.
https://github.com/Fabrik/fabrik/commit/0f94f45a39b1a855f68ee59d19baf03770325368
So do a github update (usual advice ... back your site up first, test all mission critical functionality after update) ...
-- hugh
But I've added a check to create it if it doesn't exist when you use it.
https://github.com/Fabrik/fabrik/commit/0f94f45a39b1a855f68ee59d19baf03770325368
So do a github update (usual advice ... back your site up first, test all mission critical functionality after update) ...
-- hugh