Other Questions

I am trying to connect Airtable and Google sheet through IFTTT Triggers I seek to a row of data entered in Google Sheet pulled from Airtable whenever a Trigger is fired in IFTTT. It all working fine. But the Google Sheet has data spat out and the data is scattered in the a single colum, and is not properly formatted, which is cumbersome to read as IFTTT is getting the row of data and adding the row to Google Sheets without adding the Colum Heads in the Sheet. Here is how the Google Sheet displays the date: all in one ROW… INV-10010100 {“Invoice Date and Time”:“2020-04-27T10:47:26.000Z”,“Invoice Number”:“INV-2004271047”,“Revenue Increased”:0,“Link to Client Database”:[“rec7OMmNrmhRjUCAx”],“Courses”:[“recIj3orTEDtSQQ7Q”],“Create Link to Education Provider Database”:[“rec9z2OcyOanZhakS”],“Education Provider Address”:[“13 Benowa Road Southport Postal: PO Box 4931, Bundall, Qld 4217”],“ABN”:[27620585615],“Link to Agreement Entities”:[“recBfs6qyHhEYCpYB”],“From”:["30609/9 Lawson St Southport

Hello, This is my first post. I’m thinking of using airtable to manage our website build project. We use Hubspot and I’m wondering if anyone has used Airtable to sitemap and integrate it with Hubspot. I’m an Airtable noob.

Hi all,On of my bases shows a warning label: This base is over record limits.That's not possible, there are only 140 records in the base.I have bases with over 10.000 records that do not show this warning.How do I solve this?p.s. Why is it so hard to just reach someone at Airtable for support...?

Hello, Im trying to create a form where someone will need to upload some assets. But I want the assets to automatically be added to dropbox where I will store the assets. The form is just a way to get the required form filled out and assets uploaded.  

Hi all!I'm using Airtable to track leave requests and automatically add peoples approved leave requests to Google Calendar. Currently, I have 'Leave Start Date' and 'Leave End Date' date fields which are used as the 'Start Date' and 'End Date' of the creating a google calendar event automation. However, the event rarely gets published with the correct end date. Instead, the event often gets published with an End Date one day before the submitted 'Leave End Date' (i.e. a leave that's supposed to be from October 1-October 10 will get published as October 1-October 9). Both of my calendars are in the same time zone, and even more confusing, the Start Date is always correct. Any help or suggestions would be greatly appreciated. Thanks so much!!

Hi, I'm trying to link two tables.  One of my tables (Inventory) has a URL field that I'd like to reference in the other table (Customer Project).  All the fields have linked well except the URL isn't working on the field I linked to (Customer Project).  For reference I have an inventory table and a Customer Project Table.  When I go to the customers table, I'd like to use the link from the inventory table.  I set the Field with the URL as a look up.Seems I've missed a step or misunderstood something. Thanks  

As the name suggests, I would like to copy and consolidate records based on one field into new tables. Perhaps an example would help: Let’s say I’m a store that sells apples, oranges, and bananas. Every time I sell a fruit, I record it in the Main Table by selecting the fruit in a dropdown menu with other purchase information like customer name, date and time of purchase, etc. The dropdown menu is multi-select since customers can buy more than one kind of fruit at a time. In addition to all fruit purchase information in the Main Table, I would like to create three new tables: Apples, Oranges, and Bananas that only contain the purchase history of the one respective fruit. The idea is that each table will automatically copy over a record from the Main Table when I select a fruit. Any ideas on how I might go about doing this? Thanks in advance!

I have searched for how to do this, but it seems unclear. There is no way to group by year, specifically. You can only select past year, next year, specific number of days, etc. So how do you group items by year?

Has anyone had success asking Chat GPT for Airtable formulas? I've only asked it a few Airtable related questions so far, but I have to correct them all. Curious if anyone knows if there's a specific way to ask that will get formulas in the correct Airtable format.

Good morning.I use Airtable to inventory my craft supplies.I have built a new workspace, exactly like my first one. I am trying to move individual records from the first base to the second base.I am not techy (read senior citizen) and need the simplest solution. To build buttons or automations or any of the other wonderful things mentioned is beyond my ken. Of course, if this is the only way for it to be done, I will need very simple instructions. I did try to copy and paste, and it didn't work. It only moved one cell.TIA

I've come across a strange issue.Using MAKE (aka Integromat) I'm using an Airtable Search Records module with the following formula:AND(Lower({Email (from Members)}) = "{{lower(2.`recipient email`)}}", {Order Number} = "{{51.`$1`}}")It accepts it but does not return the required record. The Order Number is a number field, and I've tried the formula with and without the "I've done with this similar tables and records but for some reason this one is not working and I cannot fathom out why.Any ideas?

Anyone know how can I enable these selections shown on the video?https://www.youtube.com/watch?v=38sS2hJKKtk : This is what it looks at my end: 

Dear,I have created different gallery views and would like to embed them on a website, but without the Airtable logo (on the bottom left) and the enlarge option (on the bottom right).We have a team licence.I couldn't find the solution 😞Thanks for your help

Hola! Hi! i'm new using Airtable! so, everything in my code was ok but when i try to do a Update Records, i have problems with patch. I have all permissions in my token, i write well the sentence to change, but appear this:

I’m trying to figure out the best way to send single send sorts of emails to people in my database.I’ve tried using the built in segmentation tools of typical mailing list software, but my needs are much more variable and ultimately at the end of the day it’s soooo much easier to just put together my list in Airtable via filters.  And then I could fill in the little extra info I need from there into a templated email of some sort.  I really only need to send a few sentences of info. Is this something I could feasibly do? I assume using sendgrid or similar?

I am unable to view Getting Started webinar. Each time I click on it, it takes me to registration page. I can't even find an email address to contact AirTable. The bot is worthless. Please help, thank you. https://www.airtable.com/lp/resources/webinars/get-started-airtable-od

Hi,I would like to share a record from my base via email.I opened the base, selected the record I wanted to share and chosen "send record."Then I got an error message "this row could not be sent because recipients must be collaborators on the base or workspace." So I invited the recipient to become a collaborator. The recipient received and accepted the invitation but even so they are not showing as a collaborator in the base and I am getting the same error message when I try to "send record."I am on the free plan and I have not allocated all the editor roles availableDoes anyone have any ideas/suggestions what I can do?Thanks 

Just need help determining the correct selector and attribute on the Linkedin applicant html page.I first tried Text Content by CSS Selector using the id which worked flawlessly until I realized that the id isn't static. It changes every time I open a different candidate. Now I want to try using the HTML Attribute by CSS Selector but I need help determining which HTML to use. The code is attached.Thank you so much in advance for any help you can provide.

My team is in the process of building a master planning base that will require eventual syncing from several different Airtable bases across our company. We've installed the dedupe extension and it works for anything created in our master tab. However, it doesn't work on items in that tab where one or more of the duplicates was synced in from another base (for reference each department currently has its own tab with one way sync enabled into this base, and then we have automations set up to create records with the needed information in our master tab whenever something is added to a dept tab).  Is it because some records are being created in our master tab using an automation? Any help would be appreciated, thanks! 

i have a field that is a text field, i am trying to set up an automation to copy the contents of the text field to a linked field, is that possible?

Hi I am an Airtable user on a Team plan ($24 a month). I want to invite a collaborator to see their own tasks and update their status eg. ‘to do’ to ‘ done’ and add a comment. I am going to have lots of task owners – but to invite them all is going to cost $24 each a month for essentially a very simple limited use of Airtable from their part? I need my table to be in the ‘Team’ space for the additional color and formatting although my ‘task editors’ don’t need to be in that space. Is there a cost effective way of setting up the above? Kind regardsAndrew

Hello All,My team and I are trying to manage the accesses of our collaborators within the same workspace.We are trying to have bases within the same workspace where not everyone has access.We are under the pro plan (team) and so far this is how we did:We removed most of the team from the workspace and added them back to the individual bases they need.However this is still limiting because we need users to be able to create their own bases which is impossible without Workspace Access.So two questions:Is this possible without upgrading plan? (the business plan allows feature I've seen)If not, is it possible to upgare plan of 1 admin collaborator to manage the access (and the reste of the team would remain on the same plan)

Has anyone else encountered this bug:I have a destination table that takes synced data from 2 source tables, things were working fine until just a few moments ago -When I have new data in source tables, and hit sync manually "Sync Now", new data rows show up in the destination table. However, a few minutes later, an automatic sync happened, and those new roles disappeared from the destination table (I didn't change the source or any filters, the automatic sync just undo my sync).If I hit sync manually again, the data rows appear again. Then automatic sync kicks in, and they are gone again.Already messaged support, but wanted to see if anyone else is encountering this.Thanks

I'd like to report a bug related to date sorting in the interfaces (especially in lists with nested records)The field is a formula type field, with date formatting

This seems to be a commonly asked question but I am yet to see an answer that works for me. I am trying to build a base which will manage activity in our building in London UK. There is never a time that I don’t want any times entered to be treated as Europe/London - even if I am overseas the times should always be entered and displayed as London times, allowing for changes to GMT/BST when the clocks change. One thought I had was to use a Date field for the Date, and a single line text field for the time. I could then use a formula to create the dateTime, however in doing this I don’t seem to be able to find a way to use SET_TIMEZONE to force the calculation into Europe/London at the point when I am creating the dateTime - it seems that this is always calculated into GMT. A lot of Airtable support seems to suggest I use an offset to calculate this, but this seems to be deliberately ignoring the daylight savings issue. Putting in a single offset time just doesn’t work. I feel I must be