I’m trying to add a Set Column Values on This Item, as an On Submit action after a Form. The idea is to set a bunch of default values for columns the user doesn’t need to modify.
I can’t make this work as my changes don’t seem to apply. Any ideas why ?
a) Do Set Column Values on This Item. In fact adding another Action behind that one never completes, so it looks like somehow the Set Column Values crashes silently…
b) I have a Relation to another Sheet, and I tried to do a Set Column Value on that relation (something I’ve done in the past without a problem in Glide Apps). This one too doesn’t set anything, but it doesn’t crash as the Action after it completes…
c) I’ve done Copy to Clipboard action to see if the relation column works, and lo and behold it does, I have correct values in the Clipboard…
So I’m confused and wondering if something is wrong with Set Column Values in Glide Pages…
I’m not sure about the reliability of that since the row might not be created in time, I did have problems with this same thing in the past, so I would always suggest using screen values, whether it be Apps or Pages @Killko
Yes I gave up on that, and just created a one line Table with User Specific Values for each column in the Original Table, then built my own New Screen. Works like a charm…
That also solved my problem with setting item visibility in a Form since I just didn’t use one.
However, I still think there is a bug there in Show Form…
Having run some tests, and always using a table with a Row ID, I cannot repeat this and indeed I use the technique in several projects, both “apps” and “pages”, successfully. However, echoing @Robert_Petitto comment, there certainly was a time when it was a little unstable on Pages. I know it’s a pain, but have you tried creating a new action from scratch, just in case?
Hi @V88 Yes I tried that to no avail.
But I also had problems managing visibility of items based on original screen values or changes in the Form, and last but not least, I couldn’t set the default value of choice components in a Form.
So I decided to manage my own Custom Form with a Show New Screen Action, which solves all the above.