This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Automatically change a form field value immediately after user changes another field

Posted on 02-10-2024 12:53 AM
dave_hodgman
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi all,

I have an appsheet form on which I need a field to be reset to the initial value immediately when the user changes the value of another field.  This must happen immediately, not when the row is saved, so I can't rely on the _THISROW_BEFORE <> _THISROW_AFTER test.  

Any suggestions much appreciated.

Dave

Solved Solved
0 8 995
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
scott192
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

Put an Editable_If formula on your field A.  ISBLANK([_THIS])

What this will do is LOCK in the value set in A on the form.  If the user wants to change the value of A, they will need to cancel the form and open it again.

It forces the user to take time on choosing the initial selector field and then you can present a list of choices for field B or something like that.

It's just a suggestion 😊

View solution in original post

Jump to Solution
8 REPLIES 8