How do i fill in gaps the database using show form screen via a button

Ask for Help
1

Hey everyone, I have a data directory where I’ve already populated some initial information in each row. However, there are key details that can only be provided by the user.

I’ve created a button that opens a form screen with text fields for users to fill in the missing data. The issue is that when the form is submitted, it creates a new row in the database instead of updating the existing row with the missing information.

I’m not sure if I need to set up any relations or integrations to get the form to update the correct existing row rather than creating a new one.

Any help or guidance would be greatly appreciated!

2

Use an Edit Screen instead of a Form Screen.

1 Like
3

Top man. SOLVED

4

Hey Darren is it possible to have 2 buttons or more asking for different things on the edit screen? I created more than one button for these and they all show the same fields and text entries. The reason is the form is long and sometimes crashes so would hate for users to input the form more than once.

Thanks

5

Use a set column action to set a value to a user-specific column in that same table.

E.g: button 1 sets “Section 1” to that column, then in the edit form you only show Section 1 fields based on conditional visibility.

2 Likes
6

Thank i will give this a try

1 Like