Add additional field to table and form
Posted: Wed Apr 07, 2021 11:04 pm
After having created a fastform (with a subform) I need to add an additional field to the form.
I have tried the following method:
1. Navigate to the form in the application
2. Open the form object list
3. Add a new object
4. Select the Form Tab, Specify the type (Input), and give it a label and ID.
5. After the new ID is entered, the "Add Database Column" button becomes visible, so I click it, complete/modify the statement and then "Run it".
6. This does result in a new field in the table.
7. But then things start to wrong:
8. The "Datatype" of the new object does not get populated.
9. And after completing and saving the new Object, and running the form again, the field is shown on the form but does not get stored in the database.
10. Also when opening this object again, the assigned ID does not show when scrolling through the possible values of the ID field.
It looks like something is missing when registering the new field.
Is there a solution for this problem? Or an alternate method for adding a new field to an existing form?
I have tried the following method:
1. Navigate to the form in the application
2. Open the form object list
3. Add a new object
4. Select the Form Tab, Specify the type (Input), and give it a label and ID.
5. After the new ID is entered, the "Add Database Column" button becomes visible, so I click it, complete/modify the statement and then "Run it".
6. This does result in a new field in the table.
7. But then things start to wrong:
8. The "Datatype" of the new object does not get populated.
9. And after completing and saving the new Object, and running the form again, the field is shown on the form but does not get stored in the database.
10. Also when opening this object again, the assigned ID does not show when scrolling through the possible values of the ID field.
It looks like something is missing when registering the new field.
Is there a solution for this problem? Or an alternate method for adding a new field to an existing form?