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 |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |