A weekly report should go to the right person with today’s details, even if the client changed their contact last Tuesday. Here each client is one saved entry. Every week GravityOps Recurring Form Submissions submits it again; Gravity Perks Populate Anything fills the report email and plan from your client records at that moment, and the notification sends the report.
Two forms
Clients: Client name, Report email, Plan. This is where you keep each client’s current details.
Weekly client report: Client (Drop Down), Send report to (Email), Plan (Single Line Text) and Week of (Date). Send report to and Plan use Populate Anything: source Gravity Forms entries from the Clients form, filtered where Client name is this form’s Client field, value set to Report email and Plan.
The Recurring feed
- Repeat every 1, Calendar unit weeks, Run time Specified local time 09:00. Untick days under the Allow weekday settings if reports should only go out on certain days.
- Input mode: Dynamic (Snapshot unticked). This is what makes Populate Anything run again on each submission.
- Update Date Field(s): Week of.
Change a client’s report email in the Clients form and the next weekly report goes to the new address. Nothing in the report form needs editing.
The notification
Send to the Send report to field. The message can be as plain as a greeting and {all_fields}, or pull figures from other forms with more Populate Anything fields, such as open requests or hours used this week.
More examples: recurring work in Gravity Forms. Plugin used: Recurring Form Submissions, with Populate Anything from Gravity Wiz.