Hi,
I’m a beginner using an airtable since a week ago.
I run a pet hotel.
When a pet is booked, our staff will record the check-in and check-out dates on the booking table.
Based on this record, I want to automatically create records for all days of the stay in the meal record table.
//////////////////////////////////////////
for example
[Reserved table]
dog name: Charlie
Check-in date: 10/1
Check-out date: 10/3
[Meal record table] automatically create 3records
record1
name: Charlie
Date: 10/1
Meal content: blank (filled in manually by staff after feeding)
record2
name: Charlie
Date: 10/2
Meal content: blank (filled in manually by staff after feeding)
record3
name: Charlie
Date: 10/3
Meal content: blank (filled in manually by staff after feeding)
//////////////////////////////////////////
I set a trigger in airtable’s automation, but I don’t know how to set the action.
Is it possible to achieve the above wishes with automation functions?
Are there other more efficient ways?
Best Regards
