How do I clear a specific row and column/cell after a value is passed?

Hello!

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.

Hi @Nickesha_Lindsay,

I saw your other post and it looks like you’re all set up, but please reply if you still have a question.

I also wanted to add some info about the “People” columns and the data that they contain. You mentioned that you have a column for people that is called “Username”. When you use a people column format, there is other data stored along with the name, it’s like a hidden table that you can use. So just referencing [Username] actually pulls in a row of data for that person. That row in includes several values and you can specify those individually if you want something like just the text of their name. These are the most common ones.

[Username].Name
[Username].Email
[Username].Photo

Thanks for the info Ben!

I should have updated earlier but this turned out to be an entirely stupid issue: I put a space between the double quotes " " instead of “” … which was causing the automation to fail.

Anyway, it’s weird one little thing like this can break your entire app, lol.

1 Like