Fast Form Can't create a browse/edit form for existing table

[DougF]

I am trying to use Fast Form to add Browse/Edit Forms for existing database tables. I seem to have hit a wall and I can't find a solution. After I load in all the fields to the builder and check off the Browse boxes. I have at the very bottom a blank field the builder generated and by checking the Box to the right of that blank field I am led to believe that means to exclude that blank field from the process. When I click the build button I get:

Invalid Field Name
Invalid Field Name
Invalid Field Name
Invalid Field Name
Invalid Field Name
Invalid Field Name
Invalid Field Name
Invalid Field Name

( and by the way the number of iterations also seems to be the number of fields in the form, hmmm?) field names are like: exp_vendor, which from what I have read is the convention.

if I don't check that box and click on build I get;

"The Field Names must be both unique and not blank"
I don't know what I am missing I have gone thru 2 different Manuals, the wiki and all the videos and I am not seeing anything that I am doing wrong.

I'd really appreciate some help. I have this feeling that it is something so simple and I am just not seeing it, or interpreting it correctly to give me results.

Thanks In advance!

[kev1n]

Hi,

You seem to be doing everything right. Would it be possible to see a screenshot with your entries? Without it, it is difficult to tell what is going wrong.

[DougF]

I am sending PDF's of what's happening. PDF1 shows Fast Form Builder ready to go. PDF2 shows what happens when I click Build with the last box checked. PDF3 Show what happens when I click build without the last box being checked. PDF 4 shows table used from PHP My Admin view.

Additional Info: this is all built on Xampp for Linux 8.2.12, Maria db 10.4.32, Apache 2.4.58, PHP 8.2.12. All running on Debian Linux 12.

nuBuilder - Form Builder1.pdf

nuBuilder - Form Builder2.pdf

nuBuilder - Form Builder3.pdf

table_used_for_form4 .pdf

If there's anything else you need to look at let me know.

Thanks much for the help
DougF
Indianapolis, IN USA

[kev1n]

I see what the issue is. Somehow there is no Label column in your subform. It should look like this:

ff_subform.png

You could try running this SQL to restore that missing column:

Code: Select all

REPLACE INTO `zzzzsys_object` (`zzzzsys_object_id`, `sob_all_zzzzsys_form_id`, `sob_all_table`, `sob_all_type`, `sob_all_id`, `sob_all_label`, `sob_all_zzzzsys_tab_id`, `sob_all_order`, `sob_all_top`, `sob_all_left`, `sob_all_width`, `sob_all_height`, `sob_all_cloneable`, `sob_all_align`, `sob_all_validate`, `sob_all_access`, `sob_all_access_condition`, `sob_all_event`, `sob_all_style_type`, `sob_all_style`, `sob_calc_formula`, `sob_calc_format`, `sob_run_zzzzsys_form_id`, `sob_run_filter`, `sob_run_method`, `sob_run_target`, `sob_run_type`, `sob_run_id`, `sob_display_sql`, `sob_display_procedure`, `sob_select_multiple`, `sob_select_2`, `sob_select_sql`, `sob_lookup_code`, `sob_lookup_description`, `sob_lookup_description_width`, `sob_lookup_autocomplete`, `sob_lookup_zzzzsys_form_id`, `sob_lookup_javascript`, `sob_lookup_php`, `sob_lookup_table`, `sob_subform_zzzzsys_form_id`, `sob_subform_foreign_key`, `sob_subform_add`, `sob_subform_delete`, `sob_subform_type`, `sob_subform_table`, `sob_input_count`, `sob_input_format`, `sob_input_type`, `sob_input_icon`, `sob_input_javascript`, `sob_input_datalist`, `sob_input_attribute`, `sob_input_file_target`, `sob_html_code`, `sob_html_chart_type`, `sob_html_javascript`, `sob_html_title`, `sob_html_vertical_label`, `sob_html_horizontal_label`, `sob_image_zzzzsys_file_id`, `sob_all_json`, `sob_json`) VALUES ('nu5bad6cb34ee220e', 'nufastformobjects', 'zzzzsys_object', 'input', 'ff_label', 'Label', 'nu5bad6cb36f72f8e', '10', '46', '23', '220', '20', '1', 'left', '1', '0', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'zzzzsys_tab', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'text', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

[DougF]

This is what I got when I ran the SQL:

MySQL said: Documentation

#1054 - Unknown column 'sob_display_procedure' in 'field list'

[DougF]

I did some looking, and it looks zzzzsys_object table is missing a field sob_display_procedure.

[kev1n]

Just remove that column from my sql.

[DougF]

removing the column reference results in:

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

[kev1n]

The error "#1136 - Column count doesn't match value count at row 1" in MySQL indicates that the number of columns specified in the INSERT statement does not match the number of values being inserted. This can happen if you omit the column names but provide a number of values that don't match the table's column count, or if you provide a mismatched number of columns and values explicitly.

AI can effortlessly perform tasks like these using AI:

https://chatgpt.com/share/54a2ef0c-493f ... a36192fe9d

[kev1n]

If this still doesn't restore your Fast Form, try restoring the entire form by running the SQL in the attached file.