Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Enter data from a table instead of a form

Does anyone know if it's possible to enter records directly from a table, instead of a form? Sometimes it's easier to do it that way.

Solved Solved
0 5 319
  • UX
1 ACCEPTED SOLUTION

If you think about it, in sheets, adding the row and inserting data is two distinct operations. 

For example, In Google Sheets, rows can be physically deleted and limited. While editing, if new rows are needed,  you have to first add the rows through a sheet function and then you can insert/edit on those rows.

You CAN simulate this in AppSheet - which I have done before. 

As an idea, you could simply insert a bunch of empty rows, up front, that have ONLY the row key,  Then when you access the Table View in edit mode, it seems like there are pre-existing blank rows ready to be edited - just like in a sheet.  

What I built before, was a custom button to launch the EDITABLE Table view.  The actions made sure that there were always 10 blanks rows when the view was first opened.  If the user edited all 10, they would save and then re-launch with the button to add another 10 new rows.  This made sure they saved portions of their entries periodically to prevent losing ALL edits if something went wrong towards the end.

I hope this helps!

View solution in original post

5 REPLIES 5
Top Labels in this Space