I’m trying to get these string of actions to work:
I’m using form post variables to populate the email, and afterward are inserted in a calendar table.
Action Steps:
Send email to one person.
Query staff table.
Use a repeat to send email to each the staff member found in the queried table.
Last step is to insert the ‘date, other data, and date email was sent’ into database table.
Everything works except the last action that inserts the new ‘email was sent’ data. I’ve tried to put the insert step first and last in the order.
Any suggestions would be very appreciated…
baub
March 25, 2021, 3:35pm
2
is the insert_calendar_event insert in the repeat? Or outside the repeat?
No sir, it’s outside. There would be no need to have an insert per staff member. The insert data will be used in a calendar. The calendar will display the date and time of a meeting, and a timestamp the email was sent.
baub
March 25, 2021, 4:16pm
4
do you get any errors in the browser developer tools?
That’s the weird thing… no errors listed.
baub
March 25, 2021, 4:29pm
6
do you have the insert step set to ‘output’, it wouldn’t show in browser unless that was checked I don’t think?
Before I added the extra email to the staff, it was not set to output. Before it was just:
Send email (was set to output)
Insert data (was not set to output)
This order of action steps worked. Now the email works, and the insert action doesn’t. Ha!
