Other Questions

Hey everyone, Sorry if this has been asked before, I couldn’t find anything. I am still a beginner. My Problem is the following: IF({Laufzeit (Monate)}= BLANK(),"", DATEADD(Vertragsbeginn,{Laufzeit (Monate)},“Month”)) It works, but the result it is no longer shown as a date. I guess because it could either be a date or a text, it doesn’t recognize it. So what I want is to have an empty cell in case “Laufzeit (Monate)” ist empty and the calculated date as a date in case “Laufzeit (Monate)” is filled. Could anyone help?

I can’t seem to both calculate and format a date in the same cell. I add 55 years to a date of birth to come up with a 55th birthday (call this cell 55bday). That returns an ISO date that includes a time. I can, in another cell, use DATETIME_FORMAT and reference cell 55bday to remove the time. Can I do that all in one cell?

I want to trigger a zap when a date in Airtable equals the current date. Looking at the triggers in Zapier (New Record; New Record in View; New or Updated Record), I don’t see a way to do that. For example, if I have an Airtable comprised of people and their 21st birthday, could a Zap trigger when the date of the 21st birthday matches the current date. I’m having a hard time seeing how any of the three Zapier triggers could do that.

Hi, I see that a few people asked about editable shared grid views in Fall of 2020, and the general consensus that it could only be done with software like Stacker, but that it was on Airtable’s upcoming features. Does anyone know if it is now possible to share editable grid views yet?

Hi folks, I’m an Airtable rookie trying to do something fairly complex… thanks in advance for the help! My main table has a list of projects (films) with several additional fields, the most relevant being Completion Date, Revenue, Team Hours Dedicated, and Quality Score. I’m trying to create another table (or series of tables) with a monthly scorecard which automatically calculates the following metrics on the first day of each month, only for projects which were completed in the last 90 days: Total Revenue Average Team Hours Dedicated per project Median Quality Score I’ve been trying various combinations of IF statements, DATEADD, etc., but am making little headway. Any ideas?

So I have a little project Im working on currently, Currently im using the Zendesk Beta and im trying to utilize the “Assignee” which is email addresses. I want to have a formula that can replace the email address that’s in the assignee to another table that has my employees names (also includes their email) so I can have a formula that replaces the data with that name instead of an email (I know you cant edit Sync Sources thought this would be best bet type of solution). Any help would be awesome im fairly new to AirTable still learning some of its tricks and features.

Hi, I am the founder of NoCodeGuides.io which helps users of NoCode software like Airtable obtain mentoring through one-on-one paid online calls. I am currently working on building out our Airtable category and am looking for experts who want to join as early-access mentors. There’s no fee for mentors to join and they can either make money from the calls or donate their earnings to one of the charities that we support. If you are an expert in Airtable and are interested please go to Bubble, Glide and Adalo Live Mentoring | NoCode Guides to submit an application. Thanks, John

Hi! I checked through the community posts but can’t seem to find the answer. Is there a way to use automations to insert multiple records into a linked record field? Context: I am creating an automation where in an employee can update their leave application via airtable form. The automation works if the employee is only encoding one date. However, since the field allows a multiple linking of records they can select multiple dates as well. This is where the error comes in. Is there any work around?

Hi, I have an airtable that I send at to clients. Once they complete it can I get a sms alert so I know someone has filled the form out?

Hi we have recently deleted our account on airtable and it still deducted the payment. Do let us know how we ca. Resolve that

We have mapped all legal professionals in our state for recruitment purposes. Need some help on the following: creating an easy to use search so we can find the lawyers easily? clean up the data (deduping) set up automations to keep it updated. Thanks Jason

Hi all :wave: , I’m a founder at Vero. We’ve just released Vero Newsletters, a newsletter tool that enables you to connect to Airtable, query your data “in place” and send. Most newsletter products, like Mailchimp, want to both store your customer data and send your newsletters. We’ve built something different. Something more flexible: we don’t want to store your data, we just want to help you use it. This let’s you decide where you store your customer data, how you organise it, how you segment it and if you enrich it with other data. I wrote a blog piece last week to show one way to create a double opt-in newsletter subscription list Using Airtable, Netlify and Vero Newsletters. Hopefully it provides some ideas of what you can do and the way we’re thinking about this use case. It’s early days for this product but we’ve had a great reception. I’m posting here in the hope that some savvy Airtablers see this, find what we’re doing useful and interesting and check out our new product. I’

I’m prefilling a link in a button field to an adobe webform. It works perfectly if I click the button on desktop, but on mobile it encodes the # that adobes requires as is and doesnt fill the form. Is there something I change in the button? Its useless if mobile users can’t use it since most of the team uses their phones vs desktop. My button: CONCATENATE("https://na1.documents.adobe.com/public/esignWidget?xxxxxxxxxxxx*#”,”L-Number=",{L#s...},"&Name=",{ID.},"&Microchip=",{Microchip Number},"&Age=",{Years/Months},"&Breed=",Breed,"&Sex=",Sex,"&Fee=",Fee) iOS link that opens the right form but doesnt prefill: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXX*%23L-Number=CP21-069&Name=Cassie&Microchip=990000005808221&Age=1%20year&Breed=Border%20Collie&Sex=Female&Fee=175 Link that opens and works on desktop: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXXXXXX*#L-Number=CP21-069&Name=Cassie&Microchip=99000000

Hey there, we’re just starting using Airtable a bit more intensive than in the past. One of the biggest issue we are facing is performance when switching between tables. Our customer table only contains around 3000 rows of data but it takes 3-5 secs at a minimum to load each time we switch to other tables. There are connections to another table with around 8000 rows which are linked to the customers but I can’t believe it is checking these connections on every reload/switch to other tables, is it? If so the problem would only get worse with growing numbers and we could just stop using Airtable again. Any other idea?

I created a form (or survey) successfully and embeded it on a web page for my university class, but it is cut off. Not all the questions show, yet the submission button is there at the bottom as it should be. Any suggestions? Thanks KGB

Can you use automations in airtable to automatically extract a csv of a view in your base? I have a views that I’d like to have extracted automatically without having to go into airtable each time to do it. Can this be done? Thanks!

Is the a way that a non collaborator can take some (but not all) fields from an existing record and create a new record from it that then can be edited, using some sort of form, button or automation?. Ie Can I have a name, address, email address duplicated but not the various date/$ amount and various notes fields? We have a table that includes customer name and address and payments made and often we have to pay the same person more than once but with different amounts and for different reasons. I realise if we had known this from the start we could have created a seperate customer table but we are to far down the road to go back and change that. Thanks in advance

How do I filter a view where the date record created is greater than a specifc date? ie ony show records more recent than July 1st 2021 I assume it is simple but I can’t work it out.

Hello there, I have a table [Main] with PNG files in {Attachments}. Unfortunately, the file name is “UnnamedAttachment” for most of them. The desired file name (including .png extension) can be found in the field {Filename}. How can I manually trigger a batch name change of the files in {Attachments} to the the name in {Filename}? Thank you! Cheers Christoph

I want to create a view where I can see ONLY milestones. I don’t see a way to filter based on milestone. Ideas? I suppose I could make a new field called milestones, but was thinking maybe there is already a button.

Hello All, I created a table in my base called notes. Customized the field type to Long Text then turned on the Enable rich text formatting. Copied and pasted a bunch of town names into one of the cells. Clicked on expand cell blue button so I could see the whole list. When it opened it had a red zig-zag underline under most of the names. I was right clicking on them all one by one and selecting add to dictionary when I realized I had added one of them to the dictionary that was spelled incorrectly. NOTE: Undo from adding to dictionary only seems to work on the LAST word added. Q: How do I find this dictionary and remove the misspelled word so it is caught again in the future! Thank you Jonathan

Hi all, Is there a way to run Run the first Datetime formula and if an error automatically run the second date time formula to pull the information in? DATETIME_FORMAT({Date Paid}, ‘MMMM-YYYY’) DATETIME_FORMAT({Order Date}, ‘MMMM-YYYY’))

Hot off the press! Airtable is acquiring the team and assets from Bayes to help people better manage complex workflows) :blush: Seems like we can expect some new and/or improved apps no doubt. Today, we’re announcing that Airtable has acquired the team and assets from Bayes, a no-code data visualization tool that shares our vision of making highly technical concepts more intuitive for non-developers. […] This is Airtable’s first acquisition, and the Bayes team will now focus on strengthening Airtable’s data visualization and reporting capabilities, including better insights for people who manage bases and new ways to depict complex workflows.

Hi I was wondering when you export a table to a website can i also export the search so as to use the search to bring up relevant information onto the site.

I am aware that Airtable does not have included functionality to use the embed app based on a field in a record. Is there a custom app or other option to accomplish this? Possibly using the field URL in an iFrame through Javascript or typescript? I want to be able to view a google doc URL from a record as an embedded URL so we can type and update the doc in real time without leaving Airtable.