Page 1 of 1
AutoNumber field type in subform
Posted: Sun Apr 20, 2025 12:16 pm
by Uzlander
Hi wise people! Sorry i got dummy question, just couldn't figure by myself.
While in a subform, i want records shown numbered, but nuAutoNumber field somehow doesn't do it, i cheched in phpmyadmin too.
What else there is to tweak or pay attention to, please help(!)
Re: AutoNumber field type in subform
Posted: Sun Apr 20, 2025 12:39 pm
by Uzlander
although, i have an identical field with one of regular (fast)forms and it works as expected. Now the only difference i've found is here in nuAutoNumber with subform it has an attribute Datatype varchar(15) whereas in working example (regular form) it is empty (and i didn't assign it, at least explicitly). Sorry can't attach a screenshot

Re: AutoNumber field type in subform
Posted: Sun Apr 20, 2025 12:41 pm
by Uzlander
-here it is
Re: AutoNumber field type in subform
Posted: Sun Apr 20, 2025 6:51 pm
by kev1n
I have also come to the conclusion that nuAutoNumber does not work with subforms.
Here's an updated file—please give it a try.
Replace
/core/nudata.php
with this file:
nudata.php
and test it again and let me know if it works.
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 1:19 pm
by Uzlander
still, after replacing the php file it doesn't seem to behave as expected. So i just prepended another similar column to quicktest..
Basically i want to have a nice numeration of records in a subform within the parent form which resets with new parent form. Or Maybe it is more proper to make a simple input element with a default value assigned in javascript (i believe it is doable in nubuilder)?
I have some raw product of similar type done in another platform/tool(dataexpress), but i want to recreate it with nubuilder (due to some of its advantages in my case)
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 1:22 pm
by Uzlander
Oh i'm sorry never mind the second column (just playing around/experiment), the first one is autonumber (replaced nudata.php file)
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 1:41 pm
by kev1n
So, is your issue sorted or do you still need something?
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 1:59 pm
by Uzlander
'PN' (autonumber) column - doesn't want to output anything visible (screenshot above)
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 2:25 pm
by Uzlander
kind of want to give you the bigger picture why the autonumeration needed in subform (Parent form is about a single date and few aggregate results within it)
Re: AutoNumber field type in subform
Posted: Tue Apr 22, 2025 4:01 pm
by Uzlander
My appologies fellows! I've tried constructing a brand new table and there it worked, thank you!:))