Enter data from a table instead of a form

[Gustavo_Eduardo]

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.

[WillowMobileSys]

Adding a list of NEW rows?  No.

If you are referring to EDITING a list of existing rows?  Then yes!   In AppSheet Table Views have the property "Enable QuickEdit".  This will show a button in the upper right-hand corner of the Table View.  Tapping the button places the view into an EDITABLE mode, allowing updated to be made to any of throws shown in that view.  Then a single tap of the Save button at the bottom will save all changes made.

I hope this helps!

[Gustavo_Eduardo]

Hi @WillowMobileSys  , yes, I meant that it is possible to add directly from a table, as if it were a Google Sheet or Excel file. Regarding editing, I know that it is possible from where you mentioned, but I assumed that it could also be added from a table.

[WillowMobileSys · 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!

[Gustavo_Eduardo]

No, my friend! Actually, what I'm looking for is to be able to create a table view in which the data can be added directly from there, as if it were in Google Sheet but from the Appsheet interface. I see that it's not possible. Maybe what you're suggesting is a viable option. Thank you in advance.

[Dhruv_Magar]

You can maybe try looking into the import action? This allows you to bulk import rows from a CSV into a specific table in your app, but it has some considerations: https://support.google.com/appsheet/answer/11510988?hl=en&sjid=2488706237895069001-NC