How can I create a new row in table and updat...

(Michael Voigt-Hansen) #1

How can I create a new row in table and update columns values. can be another table, like a log file?

(Reza Raoofi) #2

That was a really short question! Off the top of my head, perhaps an action button could help you achieve what you have in mind.

You may want to read this: http://help.appsheet.com/behavior/actions/actions-the-essentials

(Michael Voigt-Hansen) #3

Sorry for short questions :slight_smile: I get to update fields in the table in the “For a record of this table” parameter. but not in another (log) table.

(Reza Raoofi) #4

There is also another action type that says: Data: execute an action on a set of rows; that one allows you to update in another table.

(Michael Voigt-Hansen) #5

I dont get ut! I try to use add new row in action but it dont seem to add.

Can you walk me true it step for step. Or is there a exempel app you know og?

(Aleksi Alkio) #6

Instead of “Add new row” you could try to use deep link action called LINKTOFORM. Read more about from this article… help.appsheet.com - App Column Type (Deep Link) App Column Type (Deep Link) help.appsheet.com

(Reza Raoofi) #7

@Michael Voigt-Hansen in your previous comment you mentioned: …I get to update fields in the table in the “For a record of this table” parameter. but not in another (log) table.

So, I was under impression that you wanted to only update existing row(s) in another table; well you could do that using an action as I suggested, however that action will not allow to automatically add a new row in another table and save it at once. If you want to only add a new row, the LINKTOFORM() function that Aleksi suggested would help, but again you will have to manually press save button once after you enter values in fields, or via LINKTOFORM() function you have prefilled them with values. Still you will need to press Save button.