Duplicate row and change certain fields

AppSheet AppSheet Q&A
1

Hi All,

Any help would be appreicated, I am duplicating a record using “copy this row and edit the record”, I am then using “set the value of some of the data in this form” to delete certain fields that need to be changed so it forces the user to input new data into these fields as they are required fields.

There are quite a few fields so i need to be able to duplicate an existing record.

Thanks

2

I think I understand what you’re doing, but I don’t understand what you need help with?

3

I have created a button that excutes two other actions, the first it duplicates the existing row using the action “copy this row and edit the record” the next action is “set the value of some of the data in this form” however when i select the fields I want to change it does not change them when I press the button it simply duplicates the entire record and all the fields pre filled out.

The row has around 20 feilds and i only need to change two of them to blank feilds after it duplicates the row

4

QQ - When you set up your bot (I’m assuming you’re using automation) did you check the option to allow it to trigger other bots?

Select your Bot, scroll down to Options and it’s the first option.

Or are you just using actions?

5

I am just using actions, i am not sure this owuld be achievable using bots as I need a button to create the duplicate.

6

Instead of using App: copy this row and edit the copy, use an action of type App: go to another view within this app, with a Target expression that uses LINKTOFORM() to prepopulate columns of the new row, leaving blank the columns for the user to provide.

2 Likes
7

Hi Steve,

Thank you as always for expertise, the problem i have when I use this action is that I have quite a few fields so it means I will have to put all the fields in this action to prepopulate leaving out the ones I dont want to prepopulate. I dont suppose there is anyway of prepopulating all the fields without referencing them in the linktoform() and then clearing the odd couple I dont want?

Thanks

Brad

8

There is not, I’m afraid.

1 Like
9

I thought not but thanks anyway Steve, the help was much appriecated

1 Like