![]() The primary field for this new table could be anything, really, and I probably would have a formula field that showed the data of pet name, service name, and perhaps date. Doesn't really matter unless you need it to be in a specific format for linking to another table or you have users filling out forms and such This would allow me to create a formula field that would give me the rate for that service based on the linked Pet record With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Airtable, Google Calendar, and Zoom. I'm assuming in the "Pets" table you have a field that denotes the size / weight of the dog or something? If so, I would put the different rates in "Services" as well, and then pull that data over into "Services Pets" via lookup fields, as well as the size/weight from the "Pets" table. Do even more with Airtable + Google Calendar + Zoom. Each record in this table would represent a single service for a single pet Connect Airtable with Google Calendar and Zapier Chrome extension Zapier Airtable + Google Calendar + Zapier Chrome extension Integrations Integrations How to connect Airtable + Google Calendar + Zapier Chrome extension Zapier lets you send info between Airtable and Google Calendar and Zapier Chrome extension automaticallyno code required. If I were you I'd have a standalone "Services" table that just listed all of the available services, and a fourth table called "Services Pets" or something, which would have a linked field to both "Services" and "Pets". When it comes to services however, since the services are occurring at the pet level.what's the primary field for the "services" table? Any other overarching guidance on what these tables could look like? I have "humans" and "pets" tables, which makes sense. I'm struggling to figure out what my tables should look like. Although Service A is always "Service A" for every pet, the price for Service A changes depending on the pet (for example, Service A will cost more for a heavier dog). A big part of my work is thinking about how I complete tasks by what services I need to do in any given day in other words, Spot might need Service A, Service B, and Service C done, and I care about knowing what services I've already done and what I still need to do for Spot. ![]() A pet will not come back for more services again in the future, so it makes sense that we could consider "pet" to be the main unit of analysis (sorry, I'm a social scientist by training, forgive my lingo). ![]() The projects themselves occur at the pet level, since one human might come back multiple times with different pets, and all the services for a pet occur at once. Each human can have multiple pets, and each pet can have multiple services. I have (a) the human client, (b) their pet, and (c) the services that they want for their pet. It seems, if I use google, I can update from google to airtable, and if I use apple, I can update from airtable to apple, but there is no way to update in BOTH directions, both into and out of airtable.For my small business, I have three levels of information I'm trying to manage. updating an airtable record will update the associated calendar event.creating a new airtable record will create a new apple calendar event. ![]() With airtable/apple calendar integrations, you can do these actions (using an ical subscription link): updating a google calendar event will update an airtable calendar event.creating a new google calendar event will create a new airtable record.creating a new airtable record will create a new google calendar event.With airtable/google calendar integrations, you can do these actions (using Zapier to link the two): But, I seem to have come up agains some limitations. I am willing to use either apple calendar or google calendar, either would be fine. I would like to link my airtable calendar to a third party calendar app.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |