I have table ‘Submissions’ that records each item submitted by users. Each entry has the Username of the user who submitted, and a Points value according to the Type of item submitted. I need to aggregate the Points for each user in a separate table....
I want to use the cells in a single-line table as ‘constants’ that can be used by another table. For example:
The Products table has product details and one column is Colour. Associated with each Colour is a ColourValue (in an adjacent column).
The C...
I have a vacation rental database. In the Bookings table each booking has a unique BookingRef and a RentalAmount (e.g. $2000).
Payments against the total amount are made in stages, tracked in a Payments table that ties each transaction to the unique ...
I have a field where many of the entries are repeated multiple times (e.g. Management; Maintenance; Utilities) but there are also a lot of one-off values (e.g. Emergency Repair), so it’s not suitable for a Single Select field type. What would be hand...
Hi Bob
Thanks for your question but I’m not sure I’ll be much help! I don’t use formulae to derive availability, I just manually enter arrive/depart dates and use those in the ‘Data Range’ in the calendar view to show what has been booked.
I consider...
You may (or not!) be interested in the attached screenshot, which shows a database I use to manage two vacation rental properties. I was previously using Excel; switching to AirTable has been life-changing!
There are separate (but obviously linked) t...
I’ve worked in IT for 45 years (yes - 45 years! www.roysheridan.com) and Airtable is one of the most elegant and well-thought-through applications I have ever come across. It’s a joy to use, which makes the lack of offline capability only more frustr...
