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

(John Henry Joseph) #1

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 [AppSheet]) #2

@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 Joseph) #3

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

(Aleksi Alkio) #4

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 Joseph) #5

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) #6

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

(John Henry Joseph) #7

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

(Aleksi Alkio) #8

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

(John Henry Joseph) #9

Thanks again