Other Questions

I have a need to upload records from an excel file on a daily basis. I want to automate the process so that only the fresh records added are imported. I dont know if Airtable can be configured to import only those records that were added on a certain day? Thanks in advance!

Hi all,Is there any way to have a table in page designer where Table columns are on the left and their values on the right? Attached photo, top is how it is, bottom how I would like.

I am trying to find and compare exact value from a table to other.Table A: I will insert 'Key' of other table's record. Once I insert the key, automation script will run and it will search the corresponding record.Table B: Bunch of records are exist in this table with unique "Key".  I am trying to make script as below:   console.log("스크립트를 실행합니다.") let tableName = "Review Ticket" let tabledata = base.getTable(tableName); let record_id = input.config().recordID let record2 = await tabledata.selectRecordAsync( record_id, {fields: ["Title", "Key", "Task to Review", "Subtask to Review", "Asset to Review"]} ) let input_key = record2.getCellValueAsString("Key").toUpperCase() if (input_key.charAt(0) == "T") { var table = base.getTable("Tasks") // var fieldName = "Title" // var keyValue = "Key" var queryResult = await table.selectRecordsAsync({fields: [fieldName, keyValue]}) var findKey = queryResult.records.filter(element => ( element.getCellValueAsString

hi. I’ve created a new base in a new workspace starting from the project plan template. is there any way to remove the lis of names in the assignee dropdown? can’t find it in help of see a table it uses to generate the list thanks

Hi there! I’ve been using DATETIME_PARSE for some time now to convert outputs (datetime strings) from formulas into dates with format but now DATETIME_PARSE is not working anymore. I don´t know if Airtable has made any updates around this function recently? Just to give a further context, I use DATETIME_PARSE to convert datetime strings (with this format ‘DD/MM/YYYY’) resulting from a formula into Dates with a format that Airtable can read in order to compare them with other dates (these dates have the Airtable format). DATETIME_PARSE used to convert them into comparable dates but now the formula says #ERROR! all the time. If any of you know about any updates Airtable made around this formula or instead knows how I could solve this problema please let me know!! I’ve already tried 1.000 different things :frowning: Thank you for your time!!!

Looking for some airtable advice! We essentially run a startup event where we collect a bunch of data points on founders, present that back to VCs and Investors and allow them to get in touch (right now we have a form with a dropdown to select the founder record but this adds a layer of friction). What we would like to do is remove the barrier of the form and have a button to automate the intros (ideally just on a single view).  I've tried creating a button linking through to founder details which triggers an email, but I'm struggling to input the fields that link back to the person who's logged into the airtable as a collaborator. Additionally, we would want to create more data points. Any help/other suggestions to using the likes of softr would be massively appreciated!

As unfortunately, Interface cannot be shared with non Airtable users with a paid account, I am trying to see how I can make data visible outside Airtable.I have used Looker Studio (Google) by syncing Airtbale to Google Sheet using Make (Former Integromat), and then use Looker Studio to create my graph from the data in the google sheet, but it is lot of work, not super user friendly process.  I have seen solutions to sync Airtable and Google Sheet easier but are super expensive solution. Or solutions to extract the data from Airtable and import it into Looker Studio directly, but again quite expensive.What other solution am I missing?

Can any or all of these be done?Share an interface with people in my organization without the link being public facing, with navigation links to multiple pagesShare with people in my organization without adding them as a member of AirtableThe option to create a universal link that is not public facing and is only available to people within our companies web domain, ex: widgets.comUnlimited sharing with as many people in my organization as needed, with "view only" accessThe context is that I am creating a user research repository and exploring Airtable as a solution. It needs to be shared ideally without having to add individual users, and it needs to be a secure link.

The 'Send Record' feature still shows on the Desktop version, but it is missing from the app. (When you click the three dots the only options are "Duplicate record" or "Delete record."AirTable Version 9.5 on iPhone 14 Plus running iOS 16.5.1. Also not showing for one of our staff using Pixel 7 Pro.Can someone tell me where it went??? This is a pretty important feature for us!Thanks,Terry

Hi guys, We are a builder and I want to be able to report on the Issue Types encountered during the each build and when and how often they are occurring. Therefore I have the following tables: Builds - (Linked to Issue Occurrences, Page Designer Based on this table) Issue Types - (Unique Types of Issue) Issue Occurrences - (linked to Builds and Issue Types) On site the guys register occurrences of different issue types against each Build as they happen. I want to produce a report on each build that summarises the build and gives information about what issues we had and how frequently they occurred. I have a Page Designer Report done up based off the Build Table. When I drop the linked field to Issue Occurrences onto the page it gives me a list of all Issue Occurrences. What I actually want is a summarised list of these occurrences. This would be solved with a Group By operation normally but that is not available in the Page Designer Options and the Group By function for the Issue Occur

When I scroll down on a table in the Grid view when I have more records than fit on the screen everything scrolls back up to the top. See the video below.

Hello, I do have a table with 10k rows in it. The table contains WooCommerce orders (including the address from both the buyer and recipient). Each address has about 5 different columns (i.e. address, second address line, postcode, ZIP etc.).So what I need to do is to append both address types (buyers address and address of recipients) in the same columns. At the end it won't make any difference if it is an address from the buyer or recipient. All data should be in the same columns.So at the end there should around 20k rows in the table (containing the addresse of both buyers and recipients). I.e. row 1–10000 should contain the buyers addresses and in the same columns from row 10001–20000 the addresses of the recipients. How can I add 10k more rows and copy paste the values from the columns (recipient) in the corresponding columns of the buyer? Thanks a lot for help, Michael

Hello. I've just started using Airtable today. I've created a database of workshops for my job. I have add a calendar view, which shows the workshop title and facilitator. It all looks great! However, when I subscribe to this calendar through Outlook or Google Calendar, it only shows the workshop ID. How can I also display at least the title, too?Thank you!

Hello, I have a table whose fields are mostly file attachments. when I 'send record' via email, the attachment resolution decreases and images are pixelated upon zooming. Also the file names are being changed from the original names.Are there workarounds?

We have a seasonal workforce of 2,000 to 5,000 people. During twice a year events, we need to email these people many times based on views. We 're wrapping up our first event of the year, and the messaging has been a disaster. We are spending (wasting) HOURS on email management.Our IT department will not allow us to use Airtable's built-in email features so we must use the SendGrid extension.RequirementsLook up a person and see which emails were sent to them.Resend an email to a specific person.Email templates that can be reused and/or copied for future events.The Extensions dashboards are impossible to manage. The "Manage Extensions" window is so narrow that you can't see the full titles of the extensions. Making it full screen doesn't help.Extensions appear to be ordered from oldest to newest with no way to sort or search them.When you do find the extension you want, you then have to choose the view for it. We cannot discover any sorting logic to that list. All you seem to be able to

I see the confirmation on my account page that all of my collaborators have joined. However, it was a few months ago for some and they do not remember accepting or logging in. Where can I send them to login if they don't know or remember creating a password? Is there a way I can send them another "first time / start" email? Should they just go do the steps for creating a new password?Thanks.

For the Free version I only have 1 base for my social media calendar. Can i have 4 collaborators that can edit and comment without upgrading. This is the only thing I’m using Airtable for.

Hey Guys, could you tell me about the tools that you’ve used or heard to create a mobile app with Airtable as a database. I have some experience with Glide and Adalo but they do not have Airtable integrations, so I need to migrate data to google sheets somehow, looks like a complicated thing to do. I need to represent my Airtable data with some mobile app interface. What would be the best options?

In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modified in some way because of the lookup field issue, but I'm not sure how: 'templateRate': c.getCellValue('Rate')

Hello, When setting up the Gantt view, I have the start date field as 'start date' which is a date field that is added manually by the user.For the end date field, I want to add 'Due Date test' which is a formula field. If I select the due date test as an end date field, I cannot change the timeline (drag the box) in Gantt view since the fields in start date and end date are different. It looks like I can add dependencies. Does anyone have advice? I need to keep the due date test as a formula, but the Gantt view and making changes in that view is crucial.Thank you.

I have a table called Job Codes/Job Titles. I listed the job codes (numbers) in the primary field and then the job titles in the secondary field. In another table I added the Job Codes/Job Titles as a linked field. I want the ability to look up a Job Code (in this linked field) by its Job Title in case I can't remember the Job Code.  Right now I have to start typing in the Job Code number (but we have hundreds of Job Codes). Is there a way to do this other than making the Job Title the primary field?For instance, I may have a job code 0004 with a job title Academic Intern. In the linked field Job Codes/Job Titles I want to be able to start typing in Academic Intern and have it bring up both the job code (primary) and title (secondary).Thanks for your thoughts.

I'm trying to set-up some complex financial calculations, including amortisation schedules per new user record, based on data entered by the user as well as set annual figures from another table. I am struggling with the best way to set this up. There are 3 amortisation schedule type tables I need to set-up for each user, but am feeling that the horizontal nature of the table ( since the users are on the vertical axis) makes this a rather complex and confusing string of data. Perhaps there is a trick I am missing to make this easier? or have a nicer view without needing to automatically create tables for each new user and their specific schedules? 

I was creating a new base and went to add in a synced table from our main data set and got the above error. Has anyone seen this before and know how to fix it? We are on the Enterprise plan and as far as we are aware there are no limits on synced views

Does anyone have any feedback from being on the enterprise plan? I’m curious what the deal is and what the drivers were to switch from pro to enterprise.

I'm going through a pretty typical workflow here of mapping Airtable to Webflow with the NoBull Airtable Extension.1. I have a created two tables "Blog Posts" and "Categories" with the standard Airtable fields mapped to Webflow fields. All good.2. I have connected the "Categories" table to Webflow through a NoBull "Categories" Connect--All good. 3. I have connected the "Blog Posts" table to Webflow through a NoBull "Blog Posts" Connect--All good.3. I have created a linked field called "Categories" in my "Blog Posts" table which links to the "Categories" table. It works.4. When I go to map the linked "Categories" field from my "Blog Posts" table to the Webflow Categories field through the NoBull "Blog Posts" Connect, I am select the appropriate Airtable & Webflow fields, but I am not able to do anything with the "Select Reference Connect" dropdown, to connect the linked table--the option is not available to me.