Hi to all,
Iโm trying to create an app to organise swab tests, in order to verify swab results and give people access to a certain zone.
I wold create a first record in which I set the arrival date and the departure date, maybe an action could create as many record as I need from 2 days before the arrival and until the departure date. The frequency depends on the activity of this person.
Example:
Activity type 1: 1 swab 4 days before arrival and one swab 3 times a week until departure (not Saturday and not Sunday)
Activity type 2: 1 swab 4 days before arrival and one swab 2 times a week until departure (not Saturday and not Sunday)
Activity type 3: 1 swab 4 days before arrival and one swab 1 times a week until departure (not Saturday and not Sunday)
Iโve tried with an action but I was able only to create an action that create a copy of the record two days after but only onceโฆ
Anyone can help me?
This post might provide some ideas:
Many thanks Steve, this is very helpful butโฆ What is the best way if I want to create a new record only in certain days, for example: I want to create some records from start date to end date but only in Monday, Wednesday, Friday and absolutely not in Saturday and Sunday?
Iโve tried with โworkdayโ but my formula donโt works fineโฆ
Hereโs another sample app:
https://www.appsheet.com/samples/Examples-of-loops-using-actions?appGuidString=7b9ae746-1f51-4ecb-8c...
Thereโs a lot of logic involved hereโI canโt give you a simple answer. Youโll probably need more help than Iโm prepared to provide. Perhaps consider engaging an AppSheet partner for help?
Thanks Steve, I have another question:
Iโve tried to recreate the same action of this app, but the actions donโt start automatically when I create the recordโฆ If I copy your app it works fineโฆ but not in mineโฆ maybe Iโve lost some steps or settings?
You need to setup some way to prompt the action to fire. In that sample app, the action is attached to the form as the Form Saved event action:
MANY THANKS STEVE.
Iโve solved with some formulas and trickโฆ
but I have another problem nowโฆ
I want to update the data in the first table and update all the related records in the second table
example:
in the first table I update the โarrival dateโ column with the form, in the second table I want to copy the โarrival dateโ column value for all the related records.
Note that Iโve already create a ref through the first and the second table with the value of โrow idโ of the first table with โis a part ofโ, so every related record in the second table has the same โrow idโ value, when I delete the parental record in the first table all the related records will be delete (this works fine)โฆ
next step is to find a way to update all the related recordsโฆ
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |