So I created a device tracker tool where users can checkout devices and return devices. Whenever a user checkouts a device, one of the values that get passed is the user’s name (Table column name: Username - which is a person field) and I need that value to pass and display whenever I trigger an auto-post to Slack and in Gmail indicating that the user just borrowed or returned a device.
I am trying to set up an automation rule that after the username value gets passed successfully, the username column clears to blank/empty when that device/row filters back to the “Available Devices” table.
In the automation (as the last step in the rule), I tried using a Modify Row rule like this:
Modify([thisRow],[Tablename].[Username], " ")
… and all that did was return an empty value, which caused an error where the username value does not pass at all. So it appears I can’t just use " " (double quotes) as a value…
Any suggestions on how I can get that value to pass, then just clear that specific row and column/cell where the username returns to a blank state (so that another user doesn’t see the previous username there for that device?)
Thanks in advance for your help! If you need me to explain the issue better, I can post screenshots.