Field Automation

[james38]

Hey All,

I am very new to appsheet and I am looking to add some automation to my app.

I have managed to create a bot that emails a user when a record is updated. But really would like it to send an email when a particular field is changed

Can somebody help?

[Dan_Bahir]

Sure,

So your Bot has an event that triggers it. The event has a change type which you would want to set to updates_only and a condition. In the condition you can check for changes in the column using before/after images, Before and After Values | AppSheet Help Center.

[james38]

Thanks @Dan_Bahir

think its starting to sync in.

Table > | item | make | model | ASSETNO |
Condition > =TRUE
Data Change Type > Updates Only

Can I change the condition to only trigger is the ASSETNO is updated?

THEN >

On the email that is sent I would like

Dear user ASSETNO changed from ASSETNO_BEFORE to ASSETTNO_AFTER

Sorry if I am confusing the issue

[james38]

Hey @Dan_Bahir

I have achieved the result I wanted thanks to you.

in the email body I displayed:
Asset <<[ASSET]>> location has been updated

Item has moved

From:<<[_THISROW_BEFORE].[LOCATION]>>
To: <<[_THISROW_AFTER].[LOCATION]>>

Thanks Buddy

[Dan_Bahir]

Awesome