@profechef @Drearystate would either of you have a small demo app that I could copy where you have this situation set up, but it’s not working? I just want to make sure I’m testing the exact problem.
Like I said, I haven’t tested or used this feature much, but testing through this myself, here is what I observed (all this was done in the staging environment):
While working in the editor, I was able to have a button with a set column action to write through a single relation to another sheet. It worked correctly. While working with the published app, I was not able to get the button to work at all.
While working in the editor, as well as the published app, I was not able to get the set column action on a form submit to work in either situation. I could maybe see that the underlying issue here is that the action runs before the form completes writing to the sheet, so at that exact moment, the relation on the new row had not been established for the set column action to do anything. So in my test @profechef, I was not able to exactly duplicate your issue where it is updating the glide database, but not the google sheet.
From what I observed with the action directly on a button, I can see that there is definitely a bug with the action not working at all. With the action on form submit, I’d say it’s also a bug, but most likely due to a timing issue where the action is run before the relation is established.