If the column is user-specific, then no.
@biha - you should be able to use the âparentIDâ method for this. Have you tried it?
1 Like
Tried but cannot fits.
@Jeff_Hager 's is like when ParentId is equal current ID is true. Basically is true or false. If false can clear the current Id. I got it.
Mine scenario need more than 2 answers. Minimum 3 answers. so need another one more column in between.
I really stuck at this point
You can have multiple states using multiple ParentIDâs, but it starts getting complicated.
Can you show me a screen shot of your data?
Report List is the main table.
Pre-Operational is the list of questions. The answer will be stored in Pre-operational column in Report List table.
At the end, the answer able to edit.
Okay, so which part are you stuck with?
My if then column for Answer is if SV Unique Id is equal Selected Unique ID, then show Answer column. Answer column is User Specific column. after joining all rows for the answers. Then, how to clear all answer column.
because my answer form user will be from Choice component. Might be true false not applicable or might be choices answer
To clear it, you would clear the value of the Unique ID in the first row.
No but the value in the column Answer (user specific column itself) still there.
because when choice to write to is the Answer (user specific column).
Its fine when you can click for each question before answer. Then you can set column to clear . But thats not very efficient for a form
Okay, I see what you mean.
Unfortunately, I donât think there is anyway around this other than to make answering each question a two step process.
hmmm⌠
No Uzo, i have to pay youuuuuu. noooo
1 Like
Ok⌠I let you learn the hard way 
Maybe some expert here will have 2 hours of free time to walk you through this⌠Iâm not going to do it⌠plus, they are going to ban me again for showing my techniques. LOL
1 Like
@biha - there is one option. Normally I wouldnât recommend this, because itâs horrible and ugly, and I really donât like it. But, given that you have a finite number of rows in your PreOp table, I guess itâs okay in your case. And most importantly, it should work.
- In your User Profiles table, create a series of Single Value->Whole row columns. You will need one for each row in your PreOp table, and each should target a separate row.
â 0 from start
â 1 from start
â 2 from start
â etc - Then when you want to reset the form, create a Custom Action with a series of Set Column Values actions. One for each of the Single Value columns, to clear the value in each row.
Give that a try.
@Darren_Murphy !!!
I think i made it.
Wait iâm not trying yet your option. But let me show you my work.
Since i have like 3 options. So i have to have 3 additional columns for Selected ID.
1 Like
oh? What did you do?