Page 1 of 2

Cannot run a form

Posted: Thu May 17, 2018 3:15 am
by christofng
When I try to set up a run object for a form, and go to the "Run" tab, and look up the form using the "Run" lookup table, it always come up with an empty table. So, I cannot run any form.

The same thing goes with existing run form objects. They do run fine, but when I try to edit any of them, the "Run" lookup field is always empty and as a result, it wouldn't let me save any changes.

Any idea what is going on? Thanks much.

Re: Cannot run a form

Posted: Thu May 17, 2018 5:40 am
by christofng
I changed the run lookup table from "nurunlist" to "nuform" and now the form shows up. But it only shows the Edit form, not the browse form. A bit frustrating.

Re: Cannot run a form

Posted: Thu May 17, 2018 6:35 am
by toms
Hi,

The first step would be to create your own form e.g. using the Form Builder (Button "Fast Form")

Then you can pick that newly created Form from the Run lookup:
pickform.png
If you type a -1 in the Record ID field, an Edit Form is opened.
To open a Browse Form, leave the Record ID field empty.
run.PNG
Note that Fast Form already creates a Run button for Edit/Browse Forms so you don't need to do it manually.

Hope that helps!

Re: Cannot run a form

Posted: Thu May 17, 2018 8:56 am
by christofng
I created a bunch of forms, but none of them showed up, until I changed the "Run" lookup table to look up nuform instead of nurunlist. Then the forms all show up. The nurunlist is always empty for some reason. I'm probably not supposed to do that though.

Re: Cannot run a form

Posted: Thu May 17, 2018 9:20 am
by toms
nuform, nurunlist are "system" Forms. I see no reason why they should be executed and they shouldn^t probably be shown in the lookup table (Unless I miss something....)

Re: Cannot run a form

Posted: Thu May 17, 2018 9:40 am
by admin
christofng,

Can you post some screenshots of the "Before and After" of what you are talking about.

Steven

Re: Cannot run a form

Posted: Thu May 17, 2018 7:18 pm
by christofng
See attached. I suppose the nurunlist is supposed to populate the forms I created (via Fast Forms), but for some reason it didn't.

EDIT: Note that the images are sorted alphabetically, so the AFTER images come first.

Re: Cannot run a form

Posted: Fri May 18, 2018 3:18 am
by admin
christofng,

You said...
I changed the "Run" lookup table to look up nuform instead of nurunlist.
If you go changing stuff in the system tables, you're on your own.

If it's not working for you try a new install - it works properly for everyone else.


Steven

Re: Cannot run a form

Posted: Fri May 18, 2018 7:47 am
by christofng
Well, with this kind of support, I'm on my own anyway. No help at all.

Re: Cannot run a form

Posted: Fri May 18, 2018 8:03 am
by toms
Could you run this sql query on your database?

Code: Select all

UPDATE `zzzzsys_setup` SET `set_denied` = '0';
Then check if the browse table is still empty.