Other Questions

when i have tried to open a table on airtable, it always show me just like this especially when it has run on Windows OS, nearly has not a chance to open it what can i do to make it runs normally again? (PS. with my assumption that i have tried, using hotspot make it runs faster than wifi router)

I represent a sports group that puts on outdoor lawn bowling tournaments. The number of participants range from 32 to 320. I want to track vaccination cards, serology reports and negative testing prior to the day of a tournament. I also need to track temperatures and symptoms the day of a tournament. There will be multiple users of the database.

I’m having trouble when expanding a linked record in the mobile app. My understanding is that expanding a linked record should open the top-most view of the linked table. When using Airtable on my laptop, this is the behavior I experience. However, when expanding a linked record in the mobile app, the view used on the fourth view down on the linked table. I can’t figure this out. Is this a bug? Anyone else experiencing this in the mobile app? Note: I have confirmed my mobile app is up to date. Also, my tables do not have any personal views; they are all public views. Thanks in advance for any assistance!

Is there anyway to use Automations to automate a scripting block script? If so, an example would be awesome! TIA

Hello, I need help with creating an if then that statement. I want to create a formula where if a record is created then the status should change to “needs to be scheduled”, if the scheduled checkbox is selected then the status needs to change to “needs to be submitted to publication”, if both check boxes are filled then it will change the status to “complete”

I’ve added a new collaborator and she can see our base and edit records. She cannot however create new records. Where I have a +, she has a lock. I’ve tried changing her permissions via the table’s drop down edit permissions menu. I’ve tried each option for her on the workspace, editor, creator etc. I’ve also tried manually selecting her via the “specific users” option on the table. Any tips on how to enable her to add records?

Hi, I have a list of workouts with exercises in each row and another sheet with list of all exercises with details about them (equipment, pictures, and …). I used relational to link exercises in workout sheet to exercises in a list of all exercises sheet but then when I do rollup or lookup for pictures and instructions of the exercises it just displays them blank. Why is this happening? Side question: when I do relational sometimes it duplicated the data. So if I relate row 1-5 in Sheet A to row 1-5 in Sheet B, all the values in that row in sheet B are duplicated. So rows in sheet be would go 1-5 and then 1-5 would be repeated again below it. 1-2-3-4-5-1-2-3-4-5. Why is this happening and how can I stop this? I’ve been working on this for a few days now and it’s driving me nuts.

Hey Community, I’m trying to create a formula to add 7 days to a {Date} and add the Last Modified time to the the end of the result. I am currently using this formula DATEADD({Date}, 7,‘day’) & DATETIME_FORMAT({Last Modified}, ‘h:mm’) but this is what I get back example: 2021-12-07T00:00:00.000Z6:35 I have also tried adding SET_TIMEZONE({Last Modified}, ‘America/Los_Angeles’ after the DateTime_Format but I am met with the same result. Would love some help please!

Hello, I have made an Airtable base and would like to require people to fill out a form before being able to access it. Is this possible? My thought is that in exchange for providing very valuable data in my airtable, I could collect their name, email, and some other required fields before they can gain access. Please let me know if there are certain integrations I would need to make or if this is at all possible.

Hi All, How our system work: We have a 3 step application process… Applicant complete Typeform A. Data is sent to Malchimp and Airtable. Malchimp sends out a specific email with a link to Typeform 2. Applicant completes Typeform B. Data is sent to Mailchimp and Airtable. a Panel of about 5 people reviews the information on airtable as provided by the applicant. We give admission on Airtable (Yes/No) which triggers a new email to be sent via Malichimp with the 3rd and final Typeform. Question: We want to create an automated vorm on Airtable to rate applicants. The vorm should include some info of the application that is going to be rated. We would like this to be an automated process which sends out the vorm to 5 emails(our panel). The vorm that they would receive would be applicant 1 or 115 for examp

Hi, I am using Airtable as a personal CRM and have a table with each person listed individually e.g. father, mother, child 1, child 2 etc. and then details e.g. dob, address (in multiple fields), email etc. I also have a field linking spouse, children, parent etc. However, I am trying to find a way to link the address so that I can update one record when the family moves house (rather than all 4 individually). Any help please?!

I’ve created an employee survey. I’d like to send it out periodically and track the results. What are my options for doing that (capturing the results)? Where do the results get captured? Can I track the results of the entire survey AND individual questions? Any helpful Airtable support links you can point me to?

Is there a way to select the second line in your google docs as a source of information to input within a record. For example, I want the second line that I write in google docs to fill out the “subtitle” field.

I would like to import a csv with more fields than are in my Airtable, and I want Airtable to expand its table to include all the data in the csv, including the first row as field headers. Is this possible? The only work-around I was able to do was paste the first row into row 1, which expanded the table but I’m working with 50+ fields so manually renaming them one by one is not ideal.

I would like to create multiple new row entries from a long text. My current long text looks something like this, item1,2 item2,3 item3,4 Is it possible for airtable to seperate the entries into multi rows and columns? Item | Quantity item1 | 2 item2 | 3 item3 | 4

Hello everyone. I’m trying to set up an automation to create new records in airtable when I update a row in a google sheet. A little background, I’m using an email parser to gather order data from emails, which are then sent to the google sheet. I want the google sheet to then update my airtable orders page. Mostly it seems to work, except that I can’t seem to update linked fields. For example on my orders page, each order is linked to a “Customer”, and I have a separate “Customers” page. If my google sheet has a name for the order, it is unable to update the “Customer” field on the orders page. However, if I create a new column which instead of being linked to my “Customers” page, is just a single line text field, then it is able to update. However then I’d have to manually go in and edit the linked “customer” field. Is there anyway to have the google sheets to airtable automation update a linked field? (Link to an existing customer?) Could it also crea

I currently need to calculate, given any date, what is that week’s Saturday. I am currently using to following formula: IF(Start,DATETIME_PARSE( DATETIME_FORMAT(DATEADD(Start,-DATETIME_FORMAT(Start,'e')+6,'days'),'Y-M-D'))) , where Start is the date to be used as input. The issue I have is that, while it works in the middle of the month, If I have a week that spans multiple months, this does not work. For example. inputting 1 December 2021 should yield 4 December 2021 as output, but I get 1 December 2021 back instead. If I input 8 December 2021, I get the expected 11 December 2021 as output. Any ideas on how this can be fixed?

I have a List where I want different non-registred people to enter data using a form, and afterwards being able to see the results. It works well with the form, and I have the link to the shared grid view after the submission, so that the people can watch the results. The grid view is grouped and I have the problem, that the view is not grouped on mobile phones. It works fine on PCs. However, the view is grouped on any device as soon as I have signed in. So it is only the shared-by-a-link-view that is not grouped. Anyone knowing more about this issue? Thanks in advance, it would make my life so much easier! :slightly_smiling_face: Best Peter

Hi I am stuck with a problem here. I have two tables. Table A where a single record can have multiple relations to records in Table B. In Table B I have a field with numerical numbers. So my challenge is to make a form from Table A that can manage a one to many relation in Table B AND add the numerical numbers to Table B as single records. The numerical numbers show up in Table A as numbers seperated with commas. Is there a way to accomplish this. I have made Interface that works in the new Interface Designer. But the interface seems not to do well on mobile units and can not act as a form without a user to be logged in. Is it possible to have it as a form like in views ?

I’m trying to be able to sort my groups by the first created date/time of a record in that group. Essentially, I am trying to create an order form, where the customer’s phone number is the primary field. Each item a customer orders will need to be its own record, and there might be multiple customer orders coming in from the form by different employees sometimes a few minutes apart, but each customers’ items would be fulfilled at the same time. In my screenshot, I would need the 0433 order to come 2nd, as the the first item for them was placed before the first item for 0422 . Any help would be greatly appreciated!

I want to sync one view into another base. I found this documentation stating how to do that. As far as I understood, that Link that I create can be viewed by anybody in possession of that link. In addition, I can protect it with a password, but then the sync will stop working. Is that correct? If so, the sync feature is pretty much useless for everyone who doesn’t want views to be accessible publicly (I know, it’s a private link, but I don’t really trust that kind of private link), or am I mistaken? Am I missing something here?

Hi, I would like to design a base that multiple managers can see which employees (labor hands) are available in half day increments (morning and afternoon). Ideally, managers have a running task list that is then assigned to an employee and all managers can see which time slots are taken and available. Currently a spreadsheet is used with 2 row entries per labor hand (morning and afternoon) and a column for each calendar day of the year. A tab is within the spreadsheet for the running task list and each task is given a number. That number is then assigned by typing in the appropriate cell to an employee for a specific date or dates for the morning and or afternoon. I’ve considered making an airtable with all calendar dates with 2 records each (morning and afternoon) then having a form created to send to each employee with their availability. The form isn’t allowing multiple dates to be selected. The problem is the ease of use with the spreadsheet for managers is high, meaning

Hoping you all can help a new Airtable workspace user out. I’m trying to find the right combination of permissions that would allow someone outside our organization to: Access a table or base ideally with a shareable link and Have editing access to the fields in selected column only. Essentially lock/unlock columns while all others remain read only. I do not want to give access to: Expanding records which allows information in the hidden fields to be seen. This happens when giving read only and above access to a base users. Is this possible? Any insight and guidance is greatly appreciated!

I have a base and a table that tracks a list of classes by title, also showing date and assigned faculty. I need a list organized by faculty showing which classes they have each taught in the past. The assigned faculty is a linked record field that pulls faculty names from another table. This at least gives me a list organized by faculty. But, when showing the courses they teach, it shows every instance of a course taught, which may result in too many duplicates. For example, if John Smith teaches Class A 20 times in a year, Class B 5 times in a year and Class C 3 times in a year, I just need a list showing John Smith teaching 3 classes, not 28. How can I eliminate those 25 duplicates and just get a list of each unique course title taught be a faculty? So far, I have just exported to Excel and manually removed duplicates. But, this is a time consuming way to run a report regularly. Any help is very much appreciated!

I have an onboarding form at google forms. I know you can use type form to sync to Airtable but I already built the google form and its free how to keep a google form sync’d to Airtable is it still just Zapier?