Hi. I have a daily activity table, which I populate via a form (health tracker). I have several views against this table which show certain types of activity filtered for the last week - which I then use an email automation to send back targeted messages. All works great.
However, I don’t know how to respond to inactivity. So if I don’t populate the form for a week (and therefore the table doesn’t have any entries for the last X days, how can I detect this (so that I can automate an email to remind the user to populate it again).
Is there something with a max created timestamp, and then a logic check against this? Email automation is focused on a record being created or updated - I can’t think how to automate based on the absence of rows.
Hope this makes sense - trying to prove this on my basic plan (for my MVP) before committing to a paid plan.
Many thanks for any assistance.