Can I auto-create a subsequent record when adding a new record, given certain data driven circumstances?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I'm using a calendar report to allow customers to reserve equipment. Each equipment has it's own calendar report, and customers can see what time slots are booked (or available) during the day/week and then use the "ADD" link in the calendar report to book time for themselves. One particular piece of equipment needs an hour downtime following a reservation when it is used for specific purpose, for cleaning/preparation. So, I was wonder if a new record could be automatically created to block off an hour following the reservation for that specific equipment when that specific purpose is selected on the Add form.
Photo of Byron Deane

Byron Deane

  • 170 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
No problem, ACTIONS to the rescue.

ACTIONS are what I like to call Webhooks for Dummies, and that is a good thing because the previous method for simple automated functions like yours was to set up a Webhook, which is much more complicated.
http://help.quickbase.com/user-assistance/#about_quickbase_actions.html

Post back if you get stuck.  You will need to have a formula field(s) to calculate, for example, the start date and time of the next meeting so you can auto populate those fields on the reservation.
Photo of Byron Deane

Byron Deane

  • 170 Points 100 badge 2x thumb
Thank you!  I'll give it a whirl and let you know if I get stuck!