Action: App: Go to another view within this app

Mike_T
Participant V

Attempting to bring along a value from the row I’m tapping the action button from to the form view.

For example, I’ve got a Deck view of a bunch of colors. An action button in the row is set to App: Go to another view within this app. The other view is a Form view of a different table. I want to be able to click on the action button in the “Red” row and Red will default appear in the “Color” column of my Form. Apologize in advance for such a simple question.

btw…the “Color” column in both tables is set to Text. if that matters. Also, I would like the Color field in the Form to be uneditable. The user will have to go back to the Deck view to select their color in the form.

Solved Solved
0 13 5,512
1 ACCEPTED SOLUTION

Set Editable? to the expression, FALSE.

3X_b_a_bad02d95224606130975be0e441f4019107752de.png

View solution in original post

13 REPLIES 13

Steve
Participant V

Just so I’m clear on the syntax here… in the Action > App: Go to another view in this app > Target field…

LINKTOFORM(“ColorFormView”,[_THISROW].[COLOR],[COLOR])

Note: my action is in the Action bar of the row - Deck View.
So this should take the color from this row, jump the user to the Form view and the Color column value will be prefilled? Do either of the columns have to be of a special type? Right now I have them both as Text and it’s not working.

@Mike_T
Your syntax is not correct

LINKTOFORM(
    "ColorFormView",
    "Color",
    [COLOR]
)

Thank You! I was just testing every other combination and then came back to this thread and found your reply! I got it to work with [_THISROW].[Color] as the second value. Now I see that this is the value that the linktoform is “bringing along”. This forum is awesome btw! Glad to see others are working on a Saturday!

OK. I got cocky and now trying to bring another value over. Both are showing up in the form but when I save the form these two columns are empty. Some setting I need to check?

OK. Through trial and error I finally figured it out but would love to hear an explanation for why this has to be this way.
I used the LINKTOFORM in my action. It brought over the 2 values from the row just like I wanted it to. But in order for the Form to capture these two values they both have to be editable. I’m trying to make it easy for the user by bringing the values over and also stop them from screwing it up by limiting the editability of the form to just the crucial elements.

Set Editable? to the expression, FALSE.

3X_b_a_bad02d95224606130975be0e441f4019107752de.png

Mike_T
Participant V

Steve, thanks. I get how the editable setting works. I wasn’t clear in my explanation. When I set editable to False, the value the form doesn’t get submitted. Almost like it is a VC. When I switch the columns to be editable (True) they show up in my table when the form is submitted. I’ll try to toggle them on and off again and see if it still works this way.

The following two are NOT equivalent:

  1. 3X_9_d_9dd265379a5ed26cc4809cbb316c6b4c82def9d3.png

  2. 3X_d_3_d354116a31777cc63045040dee47025f19f834b2.png

These two ARE equivalent:

  1. 3X_6_8_68d42172122deb8cc0d851a438388c29106fe215.png

  2. 3X_f_b_fb0c7437c65d019a3aa19c5b158195c7540a3f01.png

(1) is equivalent to “read-only”: absolutely NO changes to the value may be made.

(2) prevents the app user and the API from editing the column value, but allows other automated changes, such as by Initial value and App formula expressions, and by actions.

(3) and (4) allow changes by any means.

@Steve
Just wanted to make a sweet reminder here (though I’m not aware provided @Phil had fixed that lately😞
Provided you are using AppSheet API for editing records, when any column’s Editable_If property is explicitly set to FALSE, then AppSheet API cannot edit that column’s value at all, will return an error and stop the execution.

Ugh! Good point! Post above updated accordingly.

Mike_T
Participant V

Ah Ha! Once again your Appsheet wizardry is unparalleled! Will give this a go and report back!

Works perfect! Thanks again!

Top Labels in this Space