Re: COVID-19 frequent testing tracking app

Justin_Gattuso · 11-07-2021 09:19 AM

Hello. Would like to develop a simple app for tracking COVID-19 frequent testing to assist with OSHA ETS compliance. Applicable employees would be required to report test results weekly (no more than every 7 days). I have some experience with basic Appsheet use. I’m not sure how to make an app create a new task (row) for each week for each applicable employee. Thanks for any advice.

Aurelien

Hi @Justin_Gattuso

Welcome to the community !

You may want to use a bot.

From Behavior panel:

create an action : “add a new row to another table using values of this row”, source table: employee, destination table: your task table.

From Automation panel:

Scheduled every week, based on employee table. Please tick the “for each row in this table” option.
Step: pick the “run a data action”, then the action you just created above.

Here are some basics reference:

Justin_Gattuso

Thank you for the info. I’ll check it out and see if I can get it to work. Justin