Changing the value of a cell

[provisrudd]

I have 2 tables [Tracker] (Columns "Scope ID" and "Date Sent for repair" and "Date Received " ) and [Scope Inventory] (Columns "Serial ID" and "Status").

I want to create an app formula that will update the "Status" to {Sent for Repair} if the " Date sent for repair" is filled out and the "status" changing back to {In Stock} if "Date received" is filled out. Both tables have the same text values for "Scope ID" and Serial ID".

If anyone is able to help, it will be much appreciated 🙂

[John_McCredie]

You'll need to create an automation bot that changes the data in your table. You'll do this using a bot that is triggered when there is a add or update to the Tracker table.

Have a look at this article:

https://help.appsheet.com/en/articles/1363923-changing-data-from-a-workflow-rule-or-scheduled-report

This uses the old workflow approach, but the same is achieved with an automation bot.

Hope this helps.