Howto: buttons and dropboxes

March 18, 2020, 12:36:49 PM

Due to missing documentation, we need to ask simple questions

How can I create custom buttons?
We need to create a list of database records. user defined buttons shall be used to perform database specific tasks. for example:
button 1 fills field 'number' with value '1'. button 2 opens a specific edit page and button 3 does something else with the database.

Ho to insert values into a database field using custom controls?
For example: On an edit page, we need to fill a status-code field of a database table with a value. e.g. 0=sunshine 1=rain 2=fog. The user of course dont know the key codes an should select the waeather comforable from a dropdown-list. depending on the dropdown-item, the field of the table is updated with the correspondig value.

Every day tasks, I think

Re: Howto: buttons and dropboxes

Reply #1 – March 19, 2020, 08:56:03 AM

I add an admin area for a table named whateverreport_dd_status.
Fields are:
statusid : Integer Auto-increment
label : The human readable status
list : the value to go in the DB.
(optional username and timestamp so I know who changed the list)

This generates forms for me to enter the status too.

Then I open the Add / Edit screen for data table / form where the status of records needs to go.
For the Weather_status field, I set it to "Select" and then set the OptionListDataSource to the table whateverreport_dd_status.