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! Go to Solution.
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
.
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:
These two ARE equivalent:
(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.
Ah Ha! Once again your Appsheet wizardry is unparalleled! Will give this a go and report back!
Works perfect! Thanks again!
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |