I have been working on an app for the past 3 weeks at least. I’m so close to finishing up and have learned a lot in this process. however I have reached a point where I am asking this awesome community for help.
I have a simple 3 Action Workflow for a “New Audit” button. Action 1: Adds a Row and sets values (CreatedBy, Created At, Etc), Action 2: is supposed to reference the Row that is created in step 1. Action 3: Shows the detail page to actually perform the audit. The guidance via ChatGPT is to have Action 2 set Data.Users.USLastAuditID with the Row ID created in Action 1.
I cannot find the option for Result of Add Row option or anything similar.
The add row action has a Result section where you could write the new RowID to a column in the user profile for example, and then create a relation in the user profile table that you can then use to show the detail screen. Seems that you could just eliminate Action 2 because the Add Row action will take care of that.
I’m previewing as admin, but I check the column for USLlastAuditID after I click my “New Audit” button. I creates a new row but doesn’t move the new RowID into the Users.USLlastAuditID column.
Is there any chance that your set column action is clearing it out after being set? You could probably get rid of that action altogether. Other than that nothing obvious is jumping out to me.
I wouldn’t even know how to see if it clearing it out. I’ve clicked the New Audit Button and tried to watch the Data at the bottom of the screen to see it it populated for a quick second and it just bumped me over to the AuditSessions table where the Audit actually occurs, eventually.
Ill delete Action 2 and keep tinkering. if you need to see anything else or have any more insight im all ears. This one thing has had me stuck for quite a while.
Thank you for the input. Would you happen to have an example I could see? (I’m a simple hillbilly for NorthWest Florida and retired Air Force guy. I need pictures lol)
Pretty sure Theo is using AI to respond to questions, as their responses often don’t make sense or add any value to the conversation. You do not need the second action as we’ve already discussed, and it’s obvious from your screenshots that everything is in the same workflow.
I’m still trying to think about what may be going wrong in your case. You say that you are previewing as a specific user as opposed to Anyone, so I’m taking your word on that for now. I suspect that I’m missing some context somewhere but I’m not sure what. I guess just for something to try, you could hop into the builder using a different computer or browser, or clear the browser cache in case something is stuck. Your setup seems correct to me.
I cleared my cache and did a restart. Once I got logged back in I created a new user with Admin Roels in my Users Data and it worked like a champ. Thanks for your help. I have been hung up on this for weeks.
