So I'm trying to use a bot to help me find errors in my data. Since its fairly easy to know when looking at various conditions of the inputted data what may be wrong it shouldn't be too hard to create a bot that scans the data set and return errors in the form of filling out another table, but this is proving to be hard.
basically I started by trying to make the trigger condition cover the whole check and then just run the data action.
AND(
[Status] = "Voicemail",
[Voicemail Left] = "N"
)
Obviously this doesn't work, what its looking for is checking the status of the main record being set to "voicemail" then checking a call log which is a Ref table has 'voicemail left' set to N (yes this is a yes/no)
Lastly I tried to do a branch condition, the trigger would check for the status to be 'voicemail' then a branch would check the second table for 'voicemail left' to be set to N, then the data action beyond that.
Been trying to get this to work for a while now and really haven't had any luck at all. Any help would be appreciated.
LinkedIn
Twitter
