Hi. Im having two issues with automations. Thanks in advance for any help - Michael
1. My automations only run when a new or matching record is submitted through a form. If I do so on the table itself which the trigger is set up to monitor for either matching or new records, the automation doesn't run. Am unclear why?
2. My automations for matching records will only run on new matching records (submitted through a form) and not on all the matching records on the table. What do I need to adjust?
What exactly are you trying to look for with the trigger? Or in other words, what exactly do you want to trigger the automation? For example, every time there is a new record, or when a record is updated etc. If you can provide a screenshot of the automation trigger and explain what your trying to achieve in more detail I could help give a better insight into why its not working!
Thank you Valentino. The trigger I have is when record on my Input table matches two criteria (Capital call or distribution), a new record will be created in a table called Capital calls. (See image) This only runs when I make a new record with one of these labels through a form even though there are a number on the input table that matches these criteria.
Option 1: You could make the trigger 'when a record is updated' and select those two fields (Capital call & Distribution). So this will trigger when one of those fields are updated.
Option 2: You could have the trigger 'when a record is created' and then run those conditional actions. So if a new record is created, it will search the criteria and if the conditions are met it will run.
Option 3: You can create a view that has the conditions (Capital call or distribution). Then lock the view to ensure the automation doesn't by mistake. Then the trigger could be 'when a record enters a view' and then select the view you created. Then you can have a conditional automation afterwards (or just a simple create record action).
It really depends on what suits your work flow and when you want the trigger to happen. Hope this helps. Let me know if any of the options work 👍