Hi, i have an virtual column calculating the disponibility from my service.
now i have a dashboard with this disponibility and another program pinting screen each one hour.
and everyday i have to get this pictures and put the disponibility in a table to do a chart with this info.
so i need that appsheet do it for me.
but how could i do it?
i made a new table to save this infos
and i think that i need to create 24 reports, one to each hour.
but how i put the report to get the value from column [disponibility] and put in this new column?
with webhook?
I’m guessing that it may indeed be necessary to use a webhook:
[Generate Warning Type Alarm or reminder](https://community.appsheet.com/t/generate-warning-type-alarm-or-reminder/10131/3) Questions
I think you might be able to do this using Zapier. Here is the general idea: The add or update would trigger a workflow webhook that is sent to Zapier. In Zapier you would create a “Catch Hook” that is invoked by the webhook from step 1. Zapier provides a “delay for a period of time” action. Once the delay expires, you could perform an Zapier action that sends the notification.
I thought about the possibility of a workflow rule too:
If people are using your app all the time, then I think you can trigger something to happen when an action is taken after a certain amount of time has elapsed. But, unless I’m mistaken, a workflow rule won’t do anything unless a user does something. Could you live with reports that have timestamps and that occur when an action is taken?
Separate from the issue of how to trigger the reports is how to record them. In that respect, I think this might be of interest:
[New Action: Add a Row to a table](https://community.appsheet.com/t/new-action-add-a-row-to-a-table/13232) Announcements
We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…
One more thought: On an app of mine, I record when things happen. Then, in Google sheets, I arrange the data by what happened each day. Perhaps something like that might work for you.