Hello everyone, is there any way I can know if the user interacts with the form. Because I only want to change the value of one input according to another field on the same form when the user interacts with the later field.
Solved! Go to Solution.
Well thereโs two ways to go about this:
For the first one, I would think a formula like this might work for the initial value formula:
ifs(isnotblank([Column1]),
if([Column1] = "One",
"None",
"One")
)
I already know this, But i need specific solution for my problem. Please someone help me
You havenโt described a specific problem, so we canโt offer a specific solution.
Hey @Countryboy_OmEr.
One of my SOP is to include the following column group:
This includes an โEditUserโ column that grabs the email of anyone making edits to the row; this provides a โwho did it lastโ history, but not a complete edit history. You CAN find this if you use Gsheets by looking at the version history.
The way the โEditUserโ column works is to use an App Formula:
This grabs the email of whoever is using the app each time it changes;
The CreationUser column uses an Initial Value of USEREMAIL() to grab the email of whoever made it, but since itโs in the initial value itโs only recorded once; putting the value in the App Formula makes it recalculate with each edit.
If you really wanted to get crazy, you could create an edit tracking table, using the background record creation action to auto-create a record of whoโs editing what record, when, etc.
For example, I have two columns ,โColumn 1โ and โColumn 2โ. What I wanna do is, if โColumn 1โ value is โOneโ then โColumn 2โ value is โNoneโ, if โColumn 1โ has any other value than โOneโ , then โColumn 2โ should have value โOneโ and I only want to change the value of โColumn 2โ if user interacts with โColumn 1โ otherwise leave the โColumn 1โ blank. If I put the if expression in initial value of โColumn 2โ then โColumn 2โ value changes at the start because โColumn 1โ is blank. Can someone please guide me now what should I do.
Does this only have to work during the first time the record is created, or do you need this to be functional for edits as well?
I donโt mind if itโs works everytime I edit. But it should also allow me to change it manually.
Well thereโs two ways to go about this:
For the first one, I would think a formula like this might work for the initial value formula:
ifs(isnotblank([Column1]),
if([Column1] = "One",
"None",
"One")
)
Thanks brother, it works great.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |