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
Forgive me if I misunderstand you.
If the data change is being triggered by a change made to the Admission table, then you must select one of the actions defined against the Admission table.
If you want to trigger an action on the Daily Census table when an Admission table record is changed, then you need to define an action on the Admissions table of type โExecute an action on a set of rowsโ. In that actionโs, target table specify โDaily Censusโ. In that actionโs โreferenced actionโ specify the name of one of the actions defined against the โDaily Censusโ table.
In other words, the โExecute an action on a set of rowsโ action is the way you can get an action on one table to trigger an action on another table.
If you want to perform two or more actions on the โDaily Censusโ table then define a โCompositeโ action against the โDaily Censusโ table that invokes you two child actions.
The following article describes this in more detail. See help.appsheet.com - Changing Data from a Workflow Rule or Scheduled Report Changing Data from a Workflow Rule or Scheduled Report help.appsheet.com
Still not working
Can you provide: 1. Your account id 2. The app name 3. The workflow rule name 4. Describe the problem more fully 5. Describe the exact steps to reproduce the problem
There are two tables [A] and [B]. I want the application to update [B] if there are any changes made on [A] but to a selected row only which is the row with the date Today(). [A] contains numerous data on column [2] with corresponding dates on [A].[3]. So I want a workflow to be triggered if there are any changes on [A], to look for the row [1] in [B] with the date today and then update the specific colum of that row [B].[2] with a value of count ([A].[2]).
The workflow should be triggered if there is any change from [Admission] with a reaction to Change Data that triggers an action under [Admission] named โDaily In-Patientโ. The action โDaily In-Patientโ would execute an action on a set of rows under [Daily Census] which is selected by Select() and is the date Today() with an effect to trigger another action under [Daily Census] which is โUpdate In-Patientโ. Action โUpdate In-Patientโ should check if the row on the [Date] is Today(), if so it will trigger an action to set the value of a column to the count().
Thank you, i hope I make sense.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |