Retainer clients get the same statement every month: hours, rate, amount due. Here each client is one saved entry, and GravityOps Recurring Form Submissions submits it again on the 1st of every month. The new entry is that month’s statement, and the form’s notification emails it to the client.
The form
- Client name (Single Line Text)
- Client email (Email)
- Hours this month (Number)
- Statement date (Date)
The Recurring feed
- Repeat every 1, Calendar unit months.
- Run time: Specified local time, 09:00.
- Update Date Field(s): Statement date, so each statement carries the date it was made.
- Input mode: leave Snapshot unticked (Dynamic), so a change you make to the parent entry, such as new retainer hours, shows up in the next statement.
The rate lives in one place
With Global Variables for Gravity Math, save the hourly rate once as a variable, for example {retainer_hourly_rate} = 95. The notification uses it twice:
Hours this month: {Hours this month:3}
Rate: ${retainer_hourly_rate} an hour
Amount due: $[gravitymath]{Hours this month:3} * {retainer_hourly_rate}[/gravitymath]
For a client with 10 hours, the email reads “Rate: $95 an hour” and “Amount due: $950”. When the rate changes, edit the variable once and every client’s next statement uses the new rate. Gravity Math does the multiplication; Global Variables keeps the number in one place.
Start a client’s series
Submit the form once for the client on your site. That entry is the parent; the series appears under Recurring Submissions → Queue with its next run date. To see a statement straight away, use Run Next Submission Now on that row.
This creates statements and emails them. It doesn’t take payment; if you bill by card, keep using your payment add-on’s own subscriptions for that part.
More examples: recurring work in Gravity Forms. Plugins used: Recurring Form Submissions and Global Variables for Gravity Math.