Can I add a new row programmatically? For exa...

[John_Henry_Jose]

Can I add a new row programmatically? For example… If the opening balance amounts not tallied… I want to add a manual entry “Opening Balance Difference” and “the difference amount” in the table?

Is it possible?

[Gil_Littman_App]

@John_Henry_Joseph you can use action to add a row to the table. You may want to use a condition with your action to check the balance is ok.

[John_Henry_Jose]

Yes. I can use action button. But how to update the predefined values in the row?

[Aleksi_Alkio]

When you copy the row, it will copy all normal values (no appformulas) as an initial value and you can manually change them.

[John_Henry_Jose]

Thanks…but I don’t want user to add a manual entry… it should be system generated entry…Any possible way to achieve this?

[Aleksi_Alkio]

I’m afraid it’s not possible at this moment. You can do that with scripting.

[John_Henry_Jose]

Thanks lot…where can I find scripts examples for appsheet?

[Aleksi_Alkio]

https://developers.google.com/apps-script/

[John_Henry_Jose]

Thanks again