Add row to table (not resource) via query?

DylanSeq · February 18, 2025, 4:59pm

Hi,

I have a table called orderTable. I’d like to add a new row to the table if analysisCheckbox.value is TRUE. Is it possible to add a new row to a table via a query? Thanks

Julien_COLOMBEAU · February 20, 2025, 8:05am

Hi,

I think it depends on where you get the data for your table.

If it's an API query you can't add a new row I think. But if you get it from SQL you can add a row by triggering a query Insert and refreshing your table (either refresh or get data again by sql)

hope that can help
Julien

bobthebear · February 20, 2025, 3:21pm

as @Julien_COLOMBEAU pointed out this will depend on the tables data source. are you able to share this?

DylanSeq · February 20, 2025, 4:09pm

Thanks! The source is a parsed excel file (.xlsx)

Julien_COLOMBEAU · February 25, 2025, 1:51pm

Hi,

As it's a simple "open file" and you can't write in it, I think you can't add a row in this case.
Maybe if you try with a Gsheet instead as Sheets authorize read/write operations. You can, with two queries, add a new row to the online file and get again the whole document.