Why wouldn’t a workflow for changes in different tables work?
I have two tables [Daily Census] and [Admission]
I made two actions for daily census 1. Update [Daily Census] with count() function with referrence to [Admission]. 2. Get the Date to Update in [Daily Census] to select the column with corresponding date today() then followed by the action on #1 Update the selected date
Now when making the workflow that would trigger if there are any changes made on [Admission] and set it to data change, I can’t
find the action Get the Date to Update.
Hope someone can help