Base Design

I have a column to which records can be added or deleted (Players). In another table I am trying to build a single select type field from which the user can select one option from the Players column. The options for this single select will need to be dynamic, read from the Players column at the time of selection. Is there a way to achieve this?

Hello, my organization collects donated items to sell at market. I have a base with two tabs: A calendar view of events (Collections, Donation Sorting, Selling) and a second tab with a list of donors and volunteers (who are often one and the same). Under the second tab, I have a view form for donors to complete. I would like them to be able to schedule (i.e.select) only future collection dates (we collect every Sunday every week). I need some help… how can I best do this?

Hi First-time Airtable user, I am working to create database for a yearly event. I have the current table of past year attendees and plan to use Zapier during this year’s registration period to send the record when someone registers from the ticketing platform. My question is if the attendee has attended in past years, how to associate that new record with an existing record vs. create a new line? Before the record is added, looking up to see if an attendee with that email is already in the database. If yes, associate that new record with an existing record, if no, create a new line? Thanks! Josh

Hi, what’s an equivalent of each feature of Airtable in Google Sheet?

I have a field set up as a URL. However, the URL does not actually allow click-through in the mobile app, although I am able to use it that way on my desktop. Seems like there is little point in having a URL in the table if it can’t actually function as a hyperlink. Having to copy and paste the link from the mobile app into a browser creates a number of additional steps. What am I missing?

Hello, I am very new to airtable so I don’t know if my question makes any kind of sense. I hope that you will bear with me. I make bath & Body products. So far I have 3 tables with their related fields Ingredients: Name, #Amount/PU (PU= Packaging Unit, e.g. 128 oz), $ Price/PU (e.g. $38), Fx Unit cost (per oz of material: Price/PU :heavy_division_sign: Amount/PU). I entered all the raw materials I use in my products in the Ingredients table, with their Amount/PU Price/PU. Products: Here is where I am having a problem. Below are the fields: Name ( e.g. Body lotion), Ingredient 1 (Jojoba Oil - Linked to records from ingredients, I don’t know how to type the symbol), #Amount/PU, $ Price/PU, #AMT (Amount used in batch), Fx Cost of AMT {AMT 1}*{Price/PU 1}/{Amount/PU 1}. I have these fields for all the ingredients used in the body lotion.

Hi there! i am using airtable to collect and manage various data and as a rudimentary CRM. however, i wonder: is airtable really up to the task to serve as a CRM? i really like it for the quick data entry and possibility to quickly expand and adapt. yet, i have the feeling airtable is not good enough to serve as a real CRM. for example: i want to use it on my android phone to call contacts. i don’t think it’s very user-friendly so i was thinking to link it with google contacts (as i’m working extensively in the google ecosystem with GSuite for Business). however, linking airtable to external tools is very limited it seems, at least without coding custom api integration. notably i am using Zapier but i find there is a huge lack of triggers (as compared to google sheets): i can only push data from airtable to google contacts, and this only ONE TIME (either when a record is created, or when it shows up in a specific view) and i cannot UPDATE datasets, i.e. contacts in Goo

Hey all, I have a big base. 44,740 records. This thing is slow! Searching / scanning a barcode via mobile phone almost halts the app. Desktop experience isn’t much better. Smaller bases works alright. Is it just me? anything I can do or is it a server issue?

My local grocer store is being overwhelmed with email orders due to Corona-19 created demand. Is there a template already that would allow customers to order online for products that would come under a range of Meat, Veg, Fruit, etc

Hi Everyone! I am trying to figure out how to autopopulate a linked table. I currenly have table 1 linked to table 2, but every time I add a new record into table 1 I have to go to table 2, create a new record, and link the record from table 1. There must be a way to organise this so that anything created in table 1 automatically populates linked tables, but I can’t figure out how to do this! Any guidance would be great.

Hello, I have a table to track “back up” task that need to be recorded everyday. So basically, after each back up the staff need to open air table and filled in some data. I use created time to track the time the task is created and the proper workflow is to do this task daily. Now I like to have an automated flow: At 7:00 pm, run a check on “back up” table, If there is a new record for that day, do nothing If there is no new record for that day, send and email to some body I can use Zapier to send email for each new record in AirTable, but in this case it’s another way around. I haven’t find an Zapier command that could check current date and find a matching date on AirrTable, that is the basic to config such an Zap. Any help is much appreciated. Viet Anh

Hi everyone, I’m in charge of finances at a company that has 50+ bank accounts across structures & countries. I do a daily check of balances on a very simple spreadsheet. I basically have 30 columns with previous day data and enter the new daily balance. I’ve always thought AirTable would be a much nicer way to deal with this (as I can group by currency, country, bank, structure for instance). However, updating a record - imo, these should be individual bank accounts - on a daily basis seems to be a struggle. I can think of workarounds such as duplicating records & filtering in a different view ; or creating a separate table with all the raw data and using lookups … but this seems an overkill for something so basic. Any thoughts? Thanks!

Hi! I’m relatively new to Airtable. I’ve set up a form that can be shared with non-Airtable users, enabling them to submit program ideas for our organization. They submit ideas for programs using the form, populating our database. After the submission deadline, I would love to make the gallery view available to another group of non-Airtable users, and have them rate each of the submitted ideas (1-5 star rating) OR link records from the database of submitted idea to a form that enables users to rate each record. Any advice out there?

Hi. I’m writing a novel with TONS of ideas, notes, characters, themes, etc. Any recommendations about how to use Airtable to organize all of this? Any examples of this that I can take a look at? Thanks! LAWRENCE

I’m routinely linking a record from another table to match text in another field. Is there a way to do this fast/automatically? For example, we have an Invoices table, with data that we import from our invoicing software, Harvest. From the imported data, we have a text field with client names. We then link the client names in a linked record field to client records, which live in another table. One of us has to do this manually, each month. Is there a way to use a formula or some other function to return a record from another table if it matches the text in another field or return something like '[NO MATCH]" if there’s no matching record in the other table.

Hello, I will try to make it as simple as possible: We are in the Property management industry, where rent amount is calculated based on the latest value of an index of a given quarter. A rent has a base quarter (Q1 or Q2 or Q3 or Q4) at year N which is used for the calculation of this new rent. When the new “base” quarter index is published (at N+1) then the rent value is updated. Indexes, in general, are updated on a quarterly basis (and are roughly 2 quarters behind based on today’s date). There are 4 indexes, each rent uses only one of them. The index value usually goes up but can go down (in a economy slow-down situation). My challenge is to automatically calculate the new value of a rent when it’s base quarter index is updated at N+1. Current setup: I have a table with all rents, their related index, their base quarter index, the initial rent value (base quarter year N), and this table should host the updated yearly rent I have a

Hi everyone, I’m new to Airtable and before I get too far populating my Airtable base, I was hoping to solicit advice on how to set it up as well as possible. I am watching raw footage for my documentary film and logging it. Basically the data I have is: time code, logging notes, thematic tags. Here are some examples pulled from the Google Doc: 31:09 | Clint, Joyva History, Radutzky Family Clint: Mickey, Harry, Milton, Alex. Those were all my bosses. I love them all. There was nothing in the world that they wouldn’t do for me. That’s why I never let them down. I never leave them. Now I work for Milton’s son Richie, your father Anybody that’s not happy with their job I don’t understand why, I love my job 27:37 | Angel, Factory, Outdated The process hasn’t changed at all. “It’s like your grandmother’s pancakes” 31:09 and 27:37 is the Time Code. Angel, Factory, Outdated, etc are the tags

When I create a link from one base to another, I rename the Field to something appropriate. In this case, I have the base Building and the base Character. When I create a Linked field named Owner of Building in Building, I just get a field in Character named Building. Is there a way to maintain the unique naming I have between the two bases, WITHOUT manually having to change it on both bases?

Can someone help me write a simple formula for the following problem? I have a 3 column table. First column is the date, second column is the # of cases. 3rd column is the increase % of cases. I simply want to take today’s case value and find the increase from yesterday’s. How do I reference yesterday’s cases? How can I write a formula like this? ((todayCases - yesterdayCases) / yesterdayCases) * 100

Hey Airtable Community! I’m hoping someone can help me consolidate a database. After tracking weeks of feedback in outreach, my team and I are consolidating a new Sales Leads table. We want to automatically import all the entries and corresponding fields for leads that have either “Check” toggled in one field, or “Probably” entered in another field. Is this possible? Thanks in advance for your help!

I want to use Air table to to track questions and answer among my team. I want all team members to be able to ask questions, answer the questions, and see the answers. Which template can I use for that and are there instructions?

I have a table for tasks and a table for completed tasks. Once a task is completed I want to move it to the completed tasks table but I cant seem to do this without duplicating the whole table again! Please help

Starting to tinker with Airtable, and I’m liking a number of the features so far. I’m setting up a set of bases for my small business; project tracking, expenses/income, etc. My plan was to create “master” customer and vendor tables (in a single base) that could be shared across bases, instead of having a single base with a dozen or more tabs, but it seems linked fields can only be to other tables within the same base(?) I’ve worked with databases for years, and it is possible to link to a table/field in a whole separate database in those instances, but it doesn’t seem possible in Airtable(?) Am I missing something? Thanks much, all.

Hello all, I am selling handmade items and want to track these orders via AT. Here’s what I’ve got: Orders are made up of Products with specific Styles & Materials Products are made up of Styles & Material Types Styles dictate how many and each type of Materials needed and Amount of Time to Create Materials dictate Cost of Supplies So I created the following tables with field setups (simplified to relevant fields): Custom Orders Link to Product Link Style Length Labor Cost Materials Cost Link to Materials Products Name Sample Pics Category Link to Styles Styles Style Name Time to Create (min / Length) Core 1 (In) Core 2 (In) Core 3 (In) Core 4 (In) Accent 1 (In) Accent 2 (In) Accent 3 (In) Accent 4 (In) Material

Hello everybody, From my understanding, Airtable offers permissions for workshop users and base users. Is there a way to give permissions only to a tab within a base? Thanks!