Cannot run a form

[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.

[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.

[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!

[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.

[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....)

[admin]

christofng,

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

Steven

[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.

[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

[christofng]

Well, with this kind of support, I'm on my own anyway. No help at all.

[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.