Hi All - I'm trying to get a better understanding of the Google Calendar Table Synch. Goal: Add attendees one by one to a Google calendar event as they RSVP through a front-end system that uses Airtable as the backend. Current setup: Events Table th...
Hey All - hoping someone might be able to help me out here. Using the list view in Interfaces and three dropdown options, I give my users the ability to generate and view custom reports. I'm trying to find a way to allow them to download/save/export...
Background: I'm currently building a surfboard reservation system and have been running into roadblocks trying to stick to the free plan because I can't utilize the advanced calendar features. I have two tables currently, 'Surfboards' and 'Reservatio...
I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...
Hi there & welcome to the Airtable Community!There are lots of different ways of going about this problem - the solution you choose depends on your office workflow and personal preference. Here are two solutions that come to mind: 1. One table w/ che...
Hey Shannon - Seems like you're already making good progress. The DateTime_Format Formula is how you'll want to format your dates and if you want more information on all the possible combinations take a look at this article.This date glitch is odd. I...
Hi there- The answer to this question depends on how you plan to use the base.If you are using it internally, you are going to want to utilize the 'View' feature. 1. You should create one view for Patients w/ Operations and another view for Patients ...
Of course! Happy to help. I looked into the possibility of using the URL to customize the view, but as of now, I don't think that is possible (yet). Depending on the number of clients you're working with, your workflow, and your Subscription Plan, yo...
Hi there! Seems like you're already halfway there. I'll walk you through some final things you'll need to do to get the desired solutions. 1. Setting up the Base- In your 'Properties' table, make sure you have all the fields that you'll want to be fi...
