Page 1 of 1

Fast Form / view

Posted: Wed May 23, 2018 12:35 pm
by Timo
With Fast Form I was trying to create a Browse Form. In Table Name I selected a database view. After clicking "Build Fast Form" a message popped up with the text "A Form has been created".
The form is nowhere to be found, also not in the table zzzzsys_form.

Re: Fast Form / view

Posted: Wed May 23, 2018 6:00 pm
by admin
Timo,

You can't use a VIEW to create a Fast Form - because it doesn't have a Primary Key.

But you can manually create a Form and Run Button that will use a VIEW.

Steven

Re: Fast Form / view

Posted: Thu May 24, 2018 8:12 am
by toms
Generally speaking,

1) Fast Form fails to create a form if there's no primary key. This applies to both views and tables.

2) And it also fails to create a form if you enter the primary key as field name. This only applies if the table does not yet exist and should be created by Fast Form.

In both cases, there's a success message after clicking "Build Fast Form".
This makes the user believe that the form was successfully created but in reality it is nowhere to be found.

Re: Fast Form / view

Posted: Fri Jul 19, 2024 6:37 pm
by fattila62
Hi,
I am a newbie.
I have the same problem to use a "View" and browse it in a form or fast form of nubuilder 4.5.

I have just understood the question that there isn't Primary Key, but I don't undestand how I resolve.
I created a new form with Fast Form, but how do I populated it with the data of sql view table?
Thank you
Roberto

Re: Fast Form / view

Posted: Tue Jul 23, 2024 5:25 pm
by fattila62
Hi,
I resolved by myself with a trick: I created from my View a new Table and add it a Primary Key. After, the Fast Forms ... as usual