Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

AutoNumber field type in subform

Questions related to using nuBuilder Forte.
Post Reply
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

AutoNumber field type in subform

Unread post 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(!)
You do not have the required permissions to view the files attached to this post.
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post 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 :(
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post by Uzlander »

-here it is
You do not have the required permissions to view the files attached to this post.
kev1n
nuBuilder Team
Posts: 4416
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 472 times
Contact:

Re: AutoNumber field type in subform

Unread post 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.
You do not have the required permissions to view the files attached to this post.
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post 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)
You do not have the required permissions to view the files attached to this post.
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post by Uzlander »

Oh i'm sorry never mind the second column (just playing around/experiment), the first one is autonumber (replaced nudata.php file)
kev1n
nuBuilder Team
Posts: 4416
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 472 times
Contact:

Re: AutoNumber field type in subform

Unread post by kev1n »

So, is your issue sorted or do you still need something?
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post by Uzlander »

'PN' (autonumber) column - doesn't want to output anything visible (screenshot above)
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post 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)
You do not have the required permissions to view the files attached to this post.
Uzlander
Posts: 51
Joined: Sat Jul 08, 2023 10:21 am
Has thanked: 7 times
Been thanked: 2 times

Re: AutoNumber field type in subform

Unread post by Uzlander »

My appologies fellows! I've tried constructing a brand new table and there it worked, thank you!:))
You do not have the required permissions to view the files attached to this post.
Post Reply