I am attempting to add the ability to add a row directly from the table. I already have editable cells and created a query to do a bulk update. I have read that you can use the same query to add the row as well.
@adigunawan, thanks for the reply, however, what I was wanting to know is, if editing cells is enabled, how do you go about adding the data for the new row. I keep getting the error that there is no ID # even though the database is set to auto-incrementing for the id.
You need to use the newRows object that is available in your table. However, most likely you will need to use a separate query than the one you are using for the bulk update.
Here's an example from another user. Or this one that actually uses the same Upsert query for both edit changes and new rows.
I hope this helps!
P.S. Sorry for not getting back to your DM yet, have been extremely busy lately
Hey @MiguelOrtiz. I can understand using a separate query from the one for bulk updates, but I don't understand how to make edit use one query and insert use another.