Ok, asking about a functionality that I hope exists and I just haven’t figured out just yet. Here’s my situation:
I am scheduling vaccine clinics for first dose and second dose. I have a formula set up already so if Vaccine Clinic A for the Moderna Vaccine is scheduled for March 1st, I have a field that tells me the second dose needs to be scheduled for 4 weeks later (i.e. March 29). That field is labeled Second Dose Target Date
Now what I would like to do is this: When that Second Dose Target Date field is populated, I would love for it to automatically create a new record with a Clinic Date indicating March 29th (using the example above), and carrying over additional information. For example, If Vaccine Clinic A administered 505 First Dose Moderna vaccines on March 1st, is there a way to use automations to auto-create a record for 505 Second Dose Moderna Vaccines on March 29th? (In my situation, the number of vaccines administered and type of vaccine are both fields on my table).
Any help that this community can provide would be soooo appreciated! My background is public health, but I’ve been tasked with building this platform to support our efforts. So I’m a little out of my element here