Base Design

I want to use airtable to build the application form that people submit and goes directly into my base when applying for a job. This particular job has 100 questions, and we're expecting a relatively high number of submission. The application form itself has conditional formating "like if YES to question 17, then there's a 5 more questions on that for you". The questions are sometimes drop down, single line text, long text, multiple select, and single select. How is the best way to do this? The reason I'm thinking of using airtable is because I want to filter responses as much as possible.

Hi All!Looking for a quick gut check on a build method...record templates vs task template table.Path 1I've built out the base this way task template (table C) and have it all structured,  tasks (table B), and a project (table A). So when a form is submitted it creating a record on (table A) an automation is triggered that reads the project type then finds the related tasks (table C) creates copies of them on (table B) and then links them to the project. This happens for each project created. Path 2I've built the same idea using the record template feature so when automation form is submitted to (table A) the automation is fired that looks to see what program type it is and then updates the record using a record template of the same name and adds new tasks to (table B) linked to the project. There's obviously a lift on the system to run the automation and do all the steps/com

Alright, I've watched all the YouTube videos I can, and have looked in here for help and I'm still stuck.Problem I'm Trying to SolveAs an interior designer/home stagerI want a "shopping" page of available inventorySo that I can click a button and select and item for a jobI have a grid set up, which includes all the inventory we own for staging homes. I also have a gallery view of that table. What I want to be able to do is have one of our non-technical interior designers come to the gallery and see only the available/in-stock items, I haven't tried tackling that part yet, but it seems easy enough. The part I'm stuck on is I want them to be able to click a button and add it to an order or "shopping cart" if you will. They can just scroll through, click a button for the items they want and in the end, end up with a list of all the inventory items we need to pull to stage a home. Is this possible?

The relatively recent addition of "default to current date" is really useful on date fields, where 95% of the time the user is going to select "today."However, it seems that the field doesn't use our local timezone, unless I enable "display time." I don't want to have to enable "display time" as our bases are designed to be used on mobile, so it's always a challenge to keep views succinct. Is there a setting I'm missing, or is this a bug in Airtable?Here's a couple of screenshots:Showing the variance in the baked in "created date" field and the "date" field, which defaults to current date.  Here is the edit history of the "beetroot" record, showing that the

Apologies if this already exists in the Community ... If I create a Base (Base A) that has a Table with 100 contact records (for example), can I create another Base (Base B) that has a Table that links to Base A? Then, if I update a record in Base A, it gets updated in Base B and all Bases to which these records are linked/ propagated?Thanks in advance.

Hello,My organization has developed a great app in Airtable for our really unique use case (context at the bottom). The functionality of the app is really, really great. The user interface design and usability is poor and is now causing problems, and I'd like help improving the user interface.The biggest problem is that we have so many different datapoints that we need to access, that our "Grid View" tables are too wide, so we can't see all the information at one time that we need to see. How can I transform my Airtable user interface into something that's really helpful and usable? All the data is there, and it works well, but the UI is too complicated. Does anyone have recommendations, best practices, or resources to help me understand how I can do this?I also consid

Dear community,How wonderful would it be to have the functions of: https://track.toggl.com/timer in Airtable. I would love to be able to activate the current Airtable time tracker per project (start, pause and stop) in an interface and get reports per project, sum of all projects, per week, per month per year. And be able to manually override (because it occasionally happens that I am working on a project and forgot to set my toggle timer...).I have been puzzling for over a month now with last time modified, duration, datetimediff and with the time tracker from Airtable, but I do not get the results that I want (which is basically the exact functions of Toggle). I did learn from the topics in the community, but this still does not bring be to what I really want. Is there anyone in the community that would love to have this function in Airtable as well, and do yo

New Airtable user here, so this is a pretty basic question (and so hopefully a straightforward answer!), though I can’t find existing guidance in the forum. Specifically, I’m having no luck creating a “Link to another record” column that automatically populates itself with those linked records. The Project tracker template provides an example of exactly what I mean: the Task column is linked to the Tasks table and automatically fills with any new records that are added to the latter. When I attempt to create a new “Link to another record” column with this functionality, however, it’s blank and stays blank (doesn’t pull in existing or newly created records from the Tasks table). What am I missing? Do I also need to create an automati

HelloI would like to know if there is a possibility to add lookup field data from two different tables to a third table and have them appear in the same column?  Thanks in advance!

I am using airtable to manage information related to a landscape design and installation business.   For most products, we purchase them as we need them and don't hold inventory.  However, for plants, we sometimes order in bulk (lots of 32 or 50), hold them in inventory and then use them as projects come up.  Plants that I order in bulk come in size a or b.I would like to be able to visualize projected inventory at points in the future (2w, 1m, 2m) for each plant in the different sizes we can order it in.  (i.e. today I have 0 of x, but in 2w after a purchase of 30 units and sale of 20 units I will have 10)Currently, I am using the following tables and fields to track plant inventory in and out.  The plants table is linked to sales and purchase by the SizeAIn and  SizeAOut rollups.  It can then calculate inventory by SizeAIn - SizeAOut.  I can use filters so that it excludes proposed sales/purchases or filter by date. 

Hello, Very new to airtable, I would like to create a weekly timesheet for all employees similar to the attached images, Is this possible? Thank you!

Hi, community! I need some help with this. I'm setting up a bank reconciliation in Airtable and need a column to record all the transactions from my bank account. Additionally, I'd like another column that shows the running balance for each transaction, reflecting the total income and expenses up to that point. I'm not looking for a single overall balance, but rather a balance that updates with each individual transaction.

I created a very mobile-friendly app using AirTable, had participants download the AirTable mobile app, and attempted to showcase the mobile interface with about 80 participants in a room. Participants complained of seeing completely blank screens or only partial amounts of data showing up.Is the Teams Edition insufficient for this use case, and do I need the business or enterprise version to handle this type of traffic? *P.S. The wifi was not the issue. 

I am testing a simple base approach which has three tables: Clients, Contacts and Jobs.The clients table has linked records to contacts to denote all the contacts that we work with at that client. And linked records to jobs to denote all the jobs we are working on with that client. A client can have multiple linked contacts and multiple jobs, but contacts and jobs can only be linked to one client.When I'm creating a new job record, I'd like to select the specific contact at the client who represents the lead contact for that particular project.I realise this can be achieved by a simple linked record field to the contacts table. However, when selecting from the contacts table, this shows all contacts regardless of which client they are at. Which theoretically means it would be possible to assign a contact from a different client than the job is for.What I was hoping was that there was a way to filter or add conditions to the linked record options so that w

Hello,I have a base that has many tables that are synced via emailed CSVs. One table was initially set up with multiple emailed files where they were ingested as updates to the table, which resulted in the ~100,000 records needed. for initial setup.Since then, updates are sent through each night with updates (which are much smaller record counts). Some of the records that are updated causes them to fall "out of scope", meaning they aren't needed in the table anymore. I'm aware of the ability to delete records, one by one, that are not in the source data (current emailed CSV), however since the emailed CSVs are a much smaller subset, and at this point there are MANY "out of scope" records, it would result in searching through a list of over 100,000 records, for each record that needs to be deleted.Now, to my question - is there any way to mass delete records, given the circumstances described above? I am able to identify the

What does done look like? (The requirements I collected)My CEO is wanting me to build a base that ties project management and PTO together for better task/project orientation.1. This base should display all projects and tasks as well as the leads and team members associated with them. 2. For PTO, the person's name should be linked with the dates that they will be out of the office.3. The dates for the PTO and Tasks should tie into on single calendar view that will allow my CEO to view everything from one place. 4. Alerts/errors should be displayed when a deadline or start date is set on a day where that lead, or assignee, is taking PTO.5. There should be an automated availability field that displays the persons availability for the week depending on their tasks/PTO assigned.  The base I have accomplishes 1-3, but I am stuck on completing requirements 4-5.Is there a way that this can b

I am developing software for car appraisers and have structured my database with five tables:Enduser (Appraiser) - Unique identifier: Email of the appraiserClients of the Enduser - Unique identifier: Email of the client (One appraiser can have multiple clients)Vehicles of the Client - Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)Appraisals of the Vehicle - Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)Payments for the Appraisals - Unique identifier: Payment number of the report number (Each appraisal can involve multiple payments)Is this structure appropriate? One potential drawback is that when importi

Description:I am looking to create a photo contest application in Airtable for a  pageant where users can view contestant profiles, vote for their favorite contestants, and manage the entire contest flow. SetupContestant Profile Section: Each contestant can upload their photos, provide personal details (name, age, hometown, etc.), and add a bio. This section should display contestants’ information for voters to view.Voting System: A voting mechanism where users can cast their votes for their favorite contestant. Each user can vote once per day, and votes should be tracked and counted in real-time.Voting Results Dashboard: A dashboard for tracking and displaying current vote counts for each contestant, including graphs or charts for quick visualization.Admin Panel: A panel for managing contestant entries, approving

Hello,We've got a destination base (called overview) with dozens of sync source bases and recently enabled two-way sync, mainly so we could assign projects from the overview base. When a user field is updated on the overview and the field is set to notify users when they are added, it seems that the email they receive has a link to the overview record and not the sync source record. Is this a setting that can be adjusted, or do I need to think about a workaround with automations? Most of our team will work in the source bases and not the overview, and there are fields that aren't synced which they use.I've also found that if I turn off the notification setting on the overview (but not the source base) the assigned user doesn't receive any email at all.Thanks

Hi all - I work on a team that manages contracts and all of our data lives in Airtable. We use Favro, however, to track cross-team work to resolve post-contract enrollment issues. I then create a new row in a "Post-Enrolled Issues" table of our base that is linked to the primary contract table so that we can maintain visibility on each contract's issues while also reporting on summaries in an interface view.Double data entry, however, is no bueno. I have played around with and considered transitioning from Favro to a kanban view in Airtable, but without going into detail, have decided not to pursue this further.I'm therefore wondering if anyone here has experience integrating Airtable and Favro? I did ask a colleague check it out and they said, "The biggest problem I’m having with Zapier is that it will only pull one field from Airtable and make a new card with that field as the card name, so it’s not any more efficient than doing it manually. I’m thinking we mig

Hi, I'm very new to Airtable, but I couldn't find a solution for my issue. Maybe there is one that would make my life so much sweeter :)) Let's say we have a product and this product has 2 options: Machine 1 or 2 which machine to choose depends on another single select field in another record, with options 1 or 2. now want to use an automation if 1 is 1 create new record with 1. but somehow string arrays can't be accessed in automations. I'm trying to solve everything no-code, maybe thats the issue. thank you so much for your help. Kind regards 

Hello I was wondering if there is a way to automatically populate dropdown options from data in either the same or a different table. For Example, if I have a sheet that has 5 rows (apple, banana, orange, grapes, and lemons) in one column. Then if I want to automatically add (apple, banana, orange, grapes, and lemons) into the dropdown options in another table? Is this possible? Basically, I will be adding other options in the future and I want them to automatically add to the dropdown options if they are in another table in the same base. This is just an example, but any help would be greatly appreciated! Thanks!

I've given my office manager shared access to a base as an editor. We both work from this same base throughout the day. I like to sort some of the tables in the base a certain way depending on what I'm working on, but she doesn't need them sorted that way and I don't want the table to suddenly look different on her end if she needs the table to be sorted the way it normally is. If I sort a table, will she see it sorted that way on her end too?

I am working on a seating chart for an event that has 150 tables of 10 and want to create a base that will help me assign people to tables, track how many open seats I have at a table etc. Any suggestions?

Hello. I'm brand new to airtable. Less than 2 days. I'm struggling a lot. I have a table with basic member info in it (member id, first name, last name, email, etc).  Now, I want to create a form, let's call it "sign up for party". I want the results of this form to populate another table, but be linked to the data in the main members table.When I create a linked field in the form, it shows EVERYONE in the table!! That's a huge security issue!! I want people to enter their member id into the form and have that id validated that it exists on form submit. When they submit, the record should be created in the new 'signups' table, linked to the main table.how do I accomplish this? This seems fairly simple/common, yet I've spent 8hrs trying to figure it out.