nuBuilder Forum

Posted: **Fri May 17, 2024 3:21 pm**

There is something driving me crazy.

I'm building a Launch Form to use it as a GUEST contact form to embed on a website. I added 3 fields and now I want to add a Run button to call a procedure and create the record in database.

My issue is the procedure don't appears in the list. I compared to other procedure I created yesterday, and is configured the same way, but one appears, and other not.

The 2 procs.

2024-05-17_15-17.png

2024-05-17_15-17_1.png

Now I go to my form. Add a Run object, and when try to choose my procedure.

2024-05-17_15-19.png

I tried seting the form where should be launched in the procedure, permissiosn, set it as global access...nothing, don't appears. Probably is something silly, but I don't see it.

Posted: **Fri May 17, 2024 4:06 pm**

The procedure picker form uses the view zzzzsys_run_list. Make sure there is a view called "zzzzsys_run_list" and not a table.

Run this SQL on your DB:

Code: Select all

DROP TABLE IF EXISTS `zzzzsys_run_list`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_run_list`  AS SELECT `zzzzsys_form`.`zzzzsys_form_id` AS `id`, 'Form' AS `run`, `zzzzsys_form`.`sfo_code` AS `code`, `zzzzsys_form`.`sfo_description` AS `description` FROM `zzzzsys_form` union select `zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`zzzzsys_report`.`sre_code` AS `code`,`zzzzsys_report`.`sre_description` AS `description` from `zzzzsys_report` union select `zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where (`zzzzsys_php`.`sph_system` <> 1) order by `code`  ;

Posted: **Fri May 17, 2024 4:21 pm**

Oh, if it's a view im sure doesn't exists. Import gave me problems with views. Where is hosted seems doesn't support it, but I readed nubuilder detects and create a table instead.

Posted: **Fri May 17, 2024 4:29 pm**

If you log out and log in again, this table should be updated.

Posted: **Fri May 17, 2024 4:40 pm**

Uhmm, I think I did it, but will try when come back to computer, thanks.

Posted: **Fri May 17, 2024 4:42 pm**

Or delete that table first.

Posted: **Fri May 17, 2024 6:11 pm**

I think it worked but once I deleted the table. Will investigate if table is not repopulated or what. Thanks

nuBuilder Forum

Conditions to procedure be choosed

Conditions to procedure be choosed

Re: Conditions to procedure be choosed

Re: Conditions to procedure be choosed

Re: Conditions to procedure be choosed

Re: Conditions to procedure be choosed

Re: Conditions to procedure be choosed

Re: Conditions to procedure be choosed