Other Questions

Hello, i’d like to add X month to a given date. Example 12/31/2019 + 1 month = 12/31/2020 =EDATE(date,months) How can i do this with Airtable. I got stuck, because there is no EDATE function like in Excel. Thank you for your help Emin

My Creator account got bumped into the Pro plan trial period by accident, and now is stuck in the Free plan, which removed a bunch of functionality. How can I get back to the Creator status? I’ve tried contacting support through the Help function, but just have an automated reply. I’m really disappointed that something so serious could happen so easily to a user.

So I have a table with a multiselect field that contains about 1000 different values that were used as general metadata tags for video content (topics, people, companies, events, etc). I want to somehow be able to use this multiselect field across different tables but have the ability for users to add new tags/values and have these new tags available on all tables. There’s probably a better way to do this, but I thought I could somehow convert these multiselect options into individual records on a new table… then somehow be able to turn it back into a multiselect type field? I was able to copy the multiselect field with its options into a new black table (just copied and pasted all values and then deleted it), but I don’t know how to convert them into records The ultimate goal is to then have this synced multiselect field available in a form, but somehow give the user the ability to add new tags from within the form… somehow… might require a link in the form to a “add tags” form?

Hello all, Thank you in advance for your help. It seems I have a simple formula requirement but can’t get my head around the Airtable syntax. Pseudo code below: IF((eligible = yeswithplan OR eligible = yeswithoutplan) AND (purchase timeframe = 12 weeks OR purchase timeframe = 3 - 6 MONTHS) AND (stage != just looking)) RETURN true OR(appointment != empty) RETURN true ELSE false Would someone be so kind to translate this into the formula for Airtable? Eddie

Just discovered this new option and I’m stoked! Let’s hope they add this for automations as well!

Hi, I have published a Template of a base that I have created - and assume that over time with community suggestions I am going to have some updates. Is there a way for people to update their own bases that are made from my template, when i update the template without starting again from scratch with their data or having to copy/paste it in?

I’m getting this message when sharing the link for my form. I have contacted Airtable, but have heard nothing yet, and this has not been resolved in past forums. No one has filled out the form. Please advise!

Hi I paid for the pro 5 seater pack but I can’t use the gantt chart. Is this normal?

Is there a way I can copy a friends project or template? Is it possible for him to export it to me and have me import it into my program so I don’t have to start from scratch?

I can not figure out why this is not working for me. I get the previous & future but anything for today comes up as Future. IF({Meeting Date Calc}=Today(), “Today”, IF({Meeting Date Calc}>Today(), “Future”, IF({Meeting Date Calc}<Today(), “Previous”)))

Hi, I synced the AirTable to my Outlook calendar but the details are not showing up on Outlook. Can someone help?

Is there an integration available that allows edits made to contacts in Outlook to be automatically replicated in AirTable and vice versa?

I’m new to Airtable. In the ScholarMatch template why do the donations have to be individually matched to the students when the Donations table lists the relevant student against each donation, rather than using a lookup? Thanks!

Situation Have a client who is the Owner of the Workspace. I logged in with client’s credentials and made a Base for them. Trained them. Set them free. Client may share views, but not whole Base. Issue They let me know that something is not working. I login and see that they have broken a Link field from one Table to another. Possible solutions to keep the client from breaking again Make the Owner of the Workspace be just an Editor of the Base in question. Is this doable without making another user for the client, sharing to that second user as Editor, and client has to login as that second user? Or do i have to become the Owner of the Workspace, and share to my client as an Editor so they can’t break anything again? And if i become the owner, then i have to pay the bill right? Or is there another construct that i am missing? I’ve searched for this in support and in this awesome community but can’t find anything that directly addresses this issue. Any help appreciated. Stay safe, Da

Does anyone have any tips for copy pasting directly from Airtable into powerpoint? I have statistics I need to report on frequently, and I don’t want to have to export to csv first.

Hello, I am having an issue trying to upgrade a free base that isn’t an “Example Base”, and everytime I do the Example Bases is Upgraded not the base that I want to upgrade. I have also tried to move the base I would like upgraded into the example base and can’t move it. Any suggestions? Thanks - Ruth

I have been using the AirTable Pivot App for over a year to summarize data. Today, after a few months, I looked and for some reason on one of my existing pivots that has been in place for a year, the row variable is showing every value instead of aggregating. I checked the variable and it looks right (no weird duplicates or strange spelling). It works using the Group command on the grid view. I tried deleting and recreating the pivot, but same problem. The pivot works for other variables, but I get the same problem when the variable is brought into the table using the LookUP command, even when that command works using Group and even when that variable was previously aggregating in the pivot. Any suggestions?

Hi Airtable Community, I’m looking to pull Facebook engagement metrics for URLs in a view of my Airtable base. I have the URL field in Airtable, and I would like a second field that pulls the total likes, comments, shares, etc. Any ideas on how to do this with free or paid solutions? Ideally, I’m looking to not be reliant on a paid subscription. Many thanks! Column A | Column B URL A | 100 shares URL B | 50 shares Resources: Facebook for Developers Graph API Engagement - Documentation - Facebook for Developers Graph API Engagement https://www.sharedcount.com/api-docs/getting-started

Hello. I built a small chat bot that fetches some data on regular basis (weekly) and stores the results in database. So I run a job daily that does this work, and to determine which records I need to check I added previousCheck field with type number, where I store unix timecode after every check (so the next time I get to it will be in a week). Is this a bad idea? Will I run into problems in 10-15 years? How long is Airtable’s integer?

Steps I’ve done: Download CSV from airtable (with field “Name”) Add some columns (“Name” field doesn’t changed) Trying to import CSV back to the airtable Some records are recognized (by “Name” field) and merged with existing records Most records don’t recognized and so airtable create New records Why does it happen? Why airtable create new records instead of merge with existing records?

Hi there! I plan to use one of these templates BotMakers 7 Influencer Chatbot Templates for Facebook Messenger Launch your own Influencer Chatbot for Facebook Messenger today with our prebuilt chatbot templates. Starting from $79. and run a chatbot for my fb page. It’s necessary to integrate it with Airtable. Is it possible?

Anyone else having issues with Automations?

Hey guys My automations are failing, not responding and some triggering randomly. Is this systemic across users?

A view was accidentally deleted from my airtable. Is there a way to recover a view that has been deleted?

Right now we have some records/projects that have been sitting for awhile because we are waiting on other people to respond. We need to create some sort of Slack notification system to ensure we, and the others, are staying on top of these, figuring in different outreaches and time lapses. How can airtable be used for this purpose? If others have similar circumstances, how have you used Airtable to manage this aspect of your business? Thanks!