Can I notify the user if they save a form with a specific value in a column?
I’m thinking I would use the event actions on the UX form but I’m not sure how
Can you be more specific about what you mean by “Notify the user”? You can send emails (or SMS with third party help).
See here for help setting this up:
Example: Sending Email When a Row is Updated to Have a Specific Column Value
You can create a workflow rule that sends an email when a row is updated to have a specific column value. For example, you might send an email when the “Status” column in the ServiceRequests record is updated to contain the value “Active”.
AND( [Status]=“Active”, [_THISROW_BEFORE].[Status] <> [_THISROW_AFTER].[Status] )
BUT … if you just want the user to know right then that the value entered is matching a specific value, you could try the Data Validity settings in the Column definitions.
2 Likes
Thanks mate!
Yeah I’ll use the notification I think. I just want to remind them if they use a specific value.
I might also use the invalid value error just to be sure. I had thought using it required that the entered data was invalid, but I’d like to allow the user to save the data.
Thanks for your help!
You could add a virtual column of type Show of category Text that displays the helpful notification only if the other column has the questionable value. You can also attach format rules to either column to draw the user’s attention.
1 Like