Other Questions

We need customers to enter an address, typeform doesn’t have this and neither does airtable, using jotform which is poorly designed. Does anyone have a solution? I mean the maps block uses google api? Why can’t a field?

Is there a formula I can plug in to see their age (so I don’t have to calculate anything?)

Hi everyone! Im new here so thanks in advance! My problem is simple , I have listing manager with a full record of my clients | Name, last name, phone,webflow member ID, Photo of listing, price and etc… I Want to split it that I will have one table I can see all the listings with a record of who submits that Flat. I use it to make a “status” function to send the data to my webflow site. Please help me out here :slightly_smiling_face:

Hi, I’ve created a shareable Calendar link following the steps described here. Integrating Airtable with external calendar applications – Airtable Support However, in Google Calendar the generated events don’t have an end date. Most events in my Airtable last more than 1 day, so that’s a big problem for me. Anyone else had this problem?

I am currently Syncing a Calendar from Google Calendar. In the same base, I have a calendar view of upcoming projects. How can I see both calendars at the same time??

Hi - Thank you in advance for any support or help you can provide. I am not sure which side is the issue but I have filed the very same question on Dropbox Support to see if we can get an answer. I have connected my AirTable Base to my Dropbox to be able to link from my ONLY Drop box account. When I go into my Attachment field -and Select Dropbox - I am only shown two Dropbox folders (I have many folders synced and stored in Dropbox. - I am not seeing all my folders. I have a DropboxPlus with extra storage. I have a Airtable Pro 1 collaborator (aka me) plan. We know that the two folders that are showing are - folders in the cloud only that have been stored up in Airtable but not on my computer. Non of my computer folders are showing when I select Dropbox in Attachment field. The Airtable and Dropbox system both acknowledge they are indeed connected. Any help is greatly appreciated because honestly - that is why I have Dropbox is for my storage.

Hello all! Really glad I discovered Airtable! I was experimenting with the filters tonight, and noticed that it doesn’t look like I can combine “And” searches with “Or” searches. Am I over looking something obvious, or is there another way around this? Example: I have a list of job descriptions, and my client sometimes uses abbreviations. So I want to search for: 20oz AND GT OR GREEN TEA Thanks!

Working with the Airtable Python Wrapper to batch insert records that have multiple field types, including “select” fields. even when Typecast is enabled, I get the below error: Unprocessable Entity for url: https://api.airtable.com/v0/appPdjdf8ska/rtt (Decoded URL) [Error: {‘type’: ‘INVALID_MULTIPLE_CHOICE_OPTIONS’, ‘message’: ‘Insufficient permissions to create new select option ““ja””’}] The code below works when all fields are text fields, so i’m not sure what I need to change? airtable_conn.batch_insert(data, typecast=True)

… this is my first time with online database work. I am have a table listing the 50 States, with each having a unique URL field in the record. On a web page, I want to display a drop list of the 50 States. The web visitor will select one State from the list which will then will display the unique URL to the visitor. This is web page has the function I want to use on my site. https://www.needtechs.com/techs_search.php Anyone know of a guide that will help me figure out how to do the view and or filter to accomplish this? Thanks in Advance.

For hours all I can see is a message that the table is loading. How do I fix this?

Hello, I’m using Integromat to look at the Airtable Record Last Modified Time Field as the trigger, then it goes to GMAPS and gets some mileages and comes back and updates the record. Does anyone know how to keep it from recalculating all the mileages and updating all the records, only the ones that have been modified? I have the scenario set to 'Choose Where To Start ’ “From Now On” Its running up a lot of “Operations” in Integromat. Thanks!

Hi guys! So, I’m trying to do something that feels WAY more complicated than it should be. I have a view which groups records by week, then by type, then by status, and we use this as a dashboard to measure activity. However, we’d like a static report every Monday that summarises the counts in each of these dropdowns, otherwise we’ll need to manually ensure we check it every week and scrape the data on a Monday. I’ve tried roll-ups and count fields, but the way the base is set up means having a linked field just for this adds an otherwise redundant step into our users’ day. Even just the ability to do a rollup of things tagged as “content type x” within the last week would be better than nothing, but it’s seemingly not possible. It’s a long-term bug-bear of mine that it’s so weirdly hard to get record counts out of Airtable in an easy way, so any help would be appreciated. Thanks, Josie

I have a base where I track several daily routines to try to gamify the forming of new habits. Each row is a bunch of checkboxes and a date. Is there some way to count streaks like this? How many days in a row have I managed not to smoke for example :smoking:

Hi, We have a base that lists our staff calendar and we have approx 20 employees. When we duplicate the data for the next week, it is very cumbersome to keep the hours the same but change the date for each employee as they all work different hours. Is there a way that we can duplicate a previous working week and get the new dates populated in a more efficient manner?

Hi, How can I hide data in column for collaborators with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

Hey Airtable Community! For the past few weeks I’ve been trying to design the following process: A user submits a form entry. Depending on whether the user indicates if they’ve submitted an entry before and whether they want their entry used for a specific project, a formula field will produce a certain text string. 3.That formula field is added in curly brackets to a SendGrid HTML template, so that the appropriate text swaps in to each individual email, rather than me needing several different templates. This all works fine. I started running into trouble when I then tried to add hypertext. I thought I could get away with this by putting it directly in my formula (this is an example version): IF({Adaptation Switch}="Yes", "Text 1","Text two, and visit us <a href=\\"https://www.airtable.com\\">here</a>!") Of course, the slashes are there so that the quotations for the hypertext HTML don’t mess with the string formula. But when I then go to preview the email in SendGrid, i

I want to upload the photos I took to Airtable. How should I do that? thanks！

Hello, is it possible to periodically export our data from Moonclerk to Airtable? if there is a way, I would love to know.

Hi community, I have a Base for customers that is shared by several other bases using the Synced Table feature. Is it possible for linked records to be shown in the original table, as they are with the synced table? Example: I have a table of contracts with a linked customers field. I can see all of the contracts for a given customer when I open the synced customer entry, but it doesn’t show up in the original customers Base Thanks everyone!

Hi there! I am trying to devise a way to send an email with a recap of our sold inventory from the past week using Zapier. The Zap will be triggered upon a new record in a view. (Our sales manager will Audit the list from the past week, then use a checkbox to say it’s ready to go). Obviously, the number of units sold will change week to week, so I can’t use a static HTML table in my email. Ultimately, I’d love to end up with the same design I have in Page Designer - see below screenshot. (side note: I will be ecstatic on the day that Page Designer/other blocks integrate with Zapier - it would solve SO MANY of my problems if I could attach a page from Page Designer as a PDF to an email or to a record). Any ideas as to what sort of action steps I need to use before I build my email template? Thanks so much!

Hello everyone! I’ve created a calendar view (with correct dates) and shared the link to my Google Calendar. For some reason, the entry in my Google calendar is displaying 1 day late. It should display today September 25th and instead, it’s September 26th!

I am using the free version of airtable, just so you know before moving forward. I know you can simply look at your settings and whatnot and see the number of records is in your base. However, I want to display that number on a website that will change as the record count does. For example, I am running a database that can be viewed by the public. I want a message on my website that states something like, “number here objects in the database and counting!” I don’t know how to do script or anything so I figure I could use a COUNT formula or something and display that in a field, then embed that airtable onto the webpage. I know there is a count field function, but I am not wanting to count the number of linked records (you have to have linked records for the count category to work).

I have a central Airtable repository where records are managed. That repository is synced up to a second base. In that second base, whenever a record is added to the central repository, a new record is created in the second base in a tab separate from the synced data. All this works well. But what I’d like to achieve is the following: When new records are added to the central repository, I automatically assign them a Pending status. A new record is created in the second base with that status based on the sync. But when I update the status to Complete in the central repository, the already created record in the second base retains the Pending status, even though the central repository and synced data display the updated Complete status. Any thoughts on how I can resolve this? The automation I’ve set up to add a new record to the 2nd base whenever added to the central repository is demonstrated in the below screenshot.

Does anyone experience time zone issues when syncing date/time fields across bases? In one of my bases, I have many date/time fields that I’m syncing over to a different base. Those date/time fields have GMT selected in the original base. However, when these fields are synced across to different base, those fields became single line text fields instead. Thus, I have to use DATETIME_PARSE on them, so I can perform calculations on them later on. The following is an example of how I parse a synced date/time field: DATETIME_PARSE({Synced Date}, “M/D/Y h:ma”) I am in California, and I found out that my newly created fields may sometimes jump 7 hours forward or backward whenever AirTable syncs any new data, so I know that it is the time zone that is causing the issue. I’ve tried to manually assign the time zone on them but it doesn’t solve the issue: SET_TIMEZONE(DATETIME_PARSE({Synced Date}, “M/D/Y h:ma”), “America/Los_Angeles”) I’ve also played with setting the newly created fields wi

Hello All I work in the Marketing Dept and we have all day events in AT as records. After creating a calendar view and adding the iCal file to Outlook, these events show up as busy in the Outlook calendar blocking our entire day preventing us from scheduling a meeting with others. Is there a way to add the Calendar view to Outlook where the records don’t show up as busy as a default. Thanks