Hi Guys
Anyone knows how to make this ti automatic update?
Would you please explain what the action should do and what do you mean by “automatic”. Automatic when?
1 Like
Hi
Automatic here means I do not need to click the update line button. Can this be periodically pull.
This is the action
This is the automation
You either need to trigger with the data change or with the scheduled Bot.. if it could be happen once in an our.
You could just use actions,
It depends on how your app works but you could make your action run after filling a form, and you could set it like this for all the forms in your app, so every time you edit or add using a form the corresponding record is updated
In this way the disadvantage is that you have to be interacting with the app for it to update
And also depending on what you want to achieve you could create a workflow using Reset on edit to update a specific field
1 Like
Hey how come I never think of a form trigger. The changes in Name Database is submssion from a TIMETABLE form in another table. Is is possible to create trigger data change in the table NAME DATABASE when a form is submitted in TIMETABLE ? If yes mind to show me some example beacuse I am not very good in automation. Thanks buddy
I don’t quite understand the relationship between your tables, if you could share some screenshots of your tables with a brief explanation of what you want to achieve I could give you a detailed answer.
1 Like
So sorry to make you confuse. This is the process. When the assign form is submitted a row is added at the SHIFT ASSIGN table and the expression ANY(SELECT(Dept[LOCATION NAME],[_Thisrow].[EMPLOYEE ID]=[EMPLOYEE ID])) at the NAME DATABASE virtual column will pull the LOCATION NAME value from the SHIFT ASSIGN Table.
Using the automation with the action [LOCATION NAME]=[ASSIGN LOCATION] to populate the column LOCATION NAME at the NAME DATABASE . But this cannot only be happened when you manually click the Update Line button. Is there a way to do this autmatically to pulate the LOCATION NAME column at the NAME DATABASE table?
Is there a relationship (Ref columns) between Time Table and Name Database?
Hi Kabulino
I think I did not supply enough information here. THe LOCATION NAME data is from the ASSIGN LOCATION table. Using this expression ANY(SELECT(Dept[LOCATION NAME],[_Thisrow].[EMPLOYEE ID]=[EMPLOYEE ID])) to pull data from the slice table Dept (actual table Shift Assign) with the ref column LOCATION NAME.
The relation between the TIme Table and Name Database is EEMPLOYEE ID. But the lOCATION NAME is ref column to another table call Assign Location which is a dropdown in TIme Table and filled in the Name Database Table
Hi Kabuliño
Sorry my mistake. I did not slect the correct action. It resolved. And I and remove the SELECT formula at the virtual column ASSIGN LOCATION and put this directly at the LOCATION NAME action.
1 Like
I’m glad you got it and it was nice to back off that Select formula
Its my first automation hahaha