Other Questions

Hey all! I have recently started using Airtable and I have been searching for an answer to this question for too long. I am attempting to track volunteer hours. I have a form that people will complete every time they have a “shift”. This form asks people when they came in and when they left. I want to create a formula that finds the difference of the End time and the Start time in order to find the total time of their shift. I have read through several ask the community questions similar to this and tried several formulas; including DATETIME_DIFF. However, nothing seems to be working. Please help! Thanks in advance.

In Table 1, I have a list of names. In Table 2, I’d like a single select drop down list that comes from the list of names in Table. This way I can add more names to the column in Table 1 and have them show up as options on the list in Table 2. Can anyone tell me if this is possible? I have played around with linked records and can’t figure it out. Thanks, Jim

Hi, I have a Base called “BaseName” table with a checkbox field “Show in filtered view?”, and another view called “Only Filtered Items” of that table showing only checkboxed items. There are 74 total items and 44 of them are checked. And the “Only Filtered Items” view in Airtable itself contains only 44 items, as expected. But, when I export that “Only Filtered Items” view, it still contains all the items. The csv exported file is called “BaseName-Only Filtered Items.csv”. Is there some way to make the csv export only contain the 44 filtered items? Another detail, I filled out the checkbox field by copy-pasting from an excel sheet which was formatting as “Y/N”, but the check boxes look like they were inputted just fine. Lastly, I referenced Export selected records to .csv and I think it should be working based on that. So I’m not sure if I’m encountering a b

Our project management company is on the pro-plan and has multiple projects schedules in the one base, across many tables. From there, in each table/project we assign different team members, and have multiple different views for agendas etc. Is there a way to sync/combine the tables into one master to-do list for 1 team member? We are open to using automations, integrations, and even software outside of AT (if it can’t be done within AT). However, we don’t have much tech knowledge (we don’t know how to use automations well). If anyone knows of a way, that would be great. Thank you.

I created a Kanban in an interface. When I click on an entry the detailed view opens. It would be nice if you had the option of leaving a checklist entry with an entry as information for yourself.I once tried a “multiple selection” but you can only predefine the entries.You could try with a text field, but it would be nicer with a checklist where you can create the entries in the detail view.

I am new to Airtable and haven’t had luck finding a solution for this use case. Is there a native or third-party function that automatically populates a Single-Select or Multi-Select field with the values from a column as selectable options? A manual copy/paste would not work, as the data would need to be dynamic in cases where new data is added to the source column or if one of the column’s values change.

I have about 15 checkboxes in a form, I would like to output only the clicked checkboxes as text in email.Example:Check box “You need a driver’s license”If this is choppy, I would like to have the "title" as text in the email so that the customer knows what things they need.So far it only gives me "True".

Does anyone know of a way to duplicate a base while keeping the record ids the same?We are trying to set up a "staging" instance of our Airtable tables but we have references to the record ids outside of Airtable. This causes all of the references break because new records ids are generated when we duplicate the base.Is there any way around this?Thanks,Chris

Problem:Using a "website" type tab in Microsoft Teams to embed an Airtable via URL, gives a nasty cookies popup that won't go away. Solution:Use the URL from the embed-code instead of the normal share URL. 

in a form I have a record selection field. where employees are selected, I want only 1 name to be selected and not 2 or 3. But I don't know how to do it. have under:Minimum and Maximum set the value at Maximum to 1. but doesn't work.

I'm hoping some can provide some advice on which direction I should research on what I'm trying to do.I help run a makerspace, and we don't have employees.  We have members, and some volunteer to be board members, but they cycle out quite frequently, making it difficult to manage any SAS solution that requires us to pay per team member. Plus, our revenue stream only comes from member dues so we don't have deep pockets, also since we're all volunteer and we all have day jobs so we have limited time to dedicate to development.I've been able to do a lot of things so far on my path of learning airtable and fillout, and I think those will be great solutions. Once (and if) we get our nonprofit status accepted by airtable we'll be buying a discounted Team account.Things we track are member applications, member maintenance, assets (equipment tracking), and board meetings. So far, the airtable and fillout automations have been awesome, and I'm looking forward to lea

Why does my primary field total display xxx Stories on some dBases and xxx Records on others. OK, dumb question, but I had to ask... and it's not in the AT Glossary of Terms.

I have 3 records:MembersSkillsMember Skills Xref (a linked table that joins members to skillsI have seen the tutorial on how I can edit a member record and add skills to the member using fillout.com, but is there a way to display the skills associated with a member when editing a member record?  In other words, I want to have the parent record and show all the detail records (skills).Thanks.

Hello dear Community,I am brand-spankin' new to this platform. I am doing a trial interview in a few weeks and the organization that I am interviewing for uses Airtable especially for managing their staff and for their intense travel and organizational schedules. Might anyone have a referral for me either a mentor/tutor or for a program that I can access online? Thank you! 

Is anyone else seeing the Apply button in their filter conditions?  It showed up some time this week but it's not in every table.  This is annoying! Is there a way to turn it off?There:Not there: 

Can we please get an option on Air table that is a fixed monthly rate for either unlimited or a large, allocated amounts of users! I need to scale but paying $54 per user per month when we need 20-50 users is an insane amount of money just to be able to tag the correct person i need to assign something to. Does anyone have a workaround for this so I can delegate tasks to people and actually have them get a notification???? 

Hi Community,  is there any way to use Assignee fields from Airtable in Fillout? BestMirko 

Hello everyone,I have a table in which we record events. Some of these events relate to a media campaign that is also recorded in the same table.I have therefore created a column in which you can link a campaign when creating an event. To do this, I use a view in which only the campaigns are displayed.This works without any problems. However, when I assign an event to a campaign, I would like the assigned events to be displayed in the campaign data record.Does anyone have any idea how I can implement this?Currently, only the selected campaign is displayed in the event record, but not the other way around.I would like to be able to click on the campaign record and see all linked events.Does anyone have any ideas on how I can implement this?Thank you very much and best regardsMirko

Greetings, I have an Airtable field titled: Course Status and to the right of that field is Total Enrollment. In my Excel spreadsheet version, I used a vlookup to return the value of ‘course status’ The formula: =VLOOKUP([@Enrolled],Table30,2,FALSE) Table30 0-2 enrolled = On Standby 3-9 enrolled = Low Enrollment 10-28 = Will Make! Is there a way to accomplish this in Airtable? Thanks in advance for your support! Lisa

I'm building an automation.If a condition is met, a specific field should be updated with the data from another field. These are date fields. but I always just get an error message

Hello, I want to use forms to let people outside my organization link records among my existing tables. I don’t want to let them create new records. Just let them link one field to another. Is there a way to achieve this through forms? I’m having trouble with the primary field being just a string of text. Ideally, someone could select the primary field from a dropdown, and then link whatever they want to to that specific primary field, without creating a new record. Use case example I have a list of companies as my primary field. I want someone to use forms to pick a company and associate it to a topic (currently linked to a Topics table, it basically acts as a multiple select).

Hi. I've not really used forms very much, so please bear with me!I would like to have a form, accessed from a unique form-record-URL, that allows anyone with the link to access only the attachment field in a record, so they can view or download (but not edit or delete) the attachment.Is this something that can be done with forms?Very many thanks.

Hey everyone,I have a 2 formula fields that generate prefilled form links. The forms are nearly identical and contain a number of linked record fields. I have noted that some of the prefilled linked record fields fail to prefill when opened with different Chrome profiles, or on Safari, on my own computer. Here is the spread of variation:Chrome Profile 1: Everything works as expected across both formsChrome Profile 2: For given records, both form links failed to load (Chrome says the page is unresponsive). I have not determined a common cause across records who's links fail yet. When the form links do load, there are (2) linked record fields that do not prefill.Incognito: All form links load (including those that do not load in Profile 2). 1 form works fully as expected, the other has (1) linked record field that does not prefill.Safari:  An inconsistent mixture of all anomalous behavior referenced above.I understand tha

Not all data records are stored in my table A, so some fields are empty. Now I would like to fill the empty fields using a form. is this possible?Approach: I would have to select the data record or data from the primary field so that the data records to be updated can be assigned correctly. so that the missing data is added when submitting the form.

Hello, our team is using AirTable in a Scrum environment. Each sprint we point our stories and calculate our velocity. Currently this is a manual process. Is there a way to automate in in AirTable?