Solved: How to know if user interacts with form - Page 2

Countryboy_OmEr · 04-18-2020 07:15 AM

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.

MultiTech

Well there’s two ways to go about this:

you can stick with using the initial value formula;
- this means it only works curing the record creation, after that it would stop the “automatic” setting of the value;
- but it is much simpler to integrate. Or,
you can create an “input” field and use that for the input, using your original column as the actual “output”
- this gives you the ability to have things automatically set for you
- it’s much more involved to create.

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")
)

View solution in original post