Other Questions

Hello! Has anyone managed to create a workflow that generates a pdf from the document creator using a code step and attaches it to the record? I’m looking for ways to automate document creation based on a button press, or programmatically, and I’m not seeing any option without using other software…Which is frustrating, as it feels like Airtable is SOOOOOOO close to what I need

I have a Zap that includes running Javascript in response to a trigger. Specifically, when a record enters a view in the project table, the zap adds tasks for that project into the task table. Here’s what the Zap screen looks like for the Run Javascript action: Input Data csString 1. Task Record IDs: record id…record id… Code //this code is required to turn the string containing record IDs into //an array of objects. Because the output is an array of objects the following //steps will run for each record found. if (inputData.csString == null) { var listArray = ; } else { var listArray = inputData.csString.split(","); } var output = ; var arrayNos = listArray.length; var i=0; do { var thisItem = new String(listArray[i]); var thisItemObj = {}; thisItemObj.record = thisItem; output.push({thisItemObj}); i++; } while (i < arrayNos); I’m trying to recreate this Zap using Airtable automation. Step 1, of course, is the trigger. In Step 2, I chose a “run script” action. I pa

Hello, We have an Airtable base set up to receive information from JotForm. The form will collect emails from every submission; sometimes the submission is missing components to make it a complete application. We would like to notify this customer, with the incomplete application, what is missing by sending them an email copy of their record. If we right-click and select ‘Send Record’, the way bottom part of the message has a ‘View in Airtable’ link. We can not send these to the customers because they will try to request access to our workspace. Is there a reliable way to send a single record to a customer without having this link embedded? The SendGrid app only appears to be able to send to whole columns, and it just seems tedious to single out a record, enter it into a view, and send the email that way.

I have 3 tables: Units - a list of all our technology units whether classified as inventory or leased to a customer Customers - linked to the Units table Unit Setup - this is a form to be used by the shipping department to go through shipping checklists AND assign a Unit to a Customer. I cannot figure out how to get the Unit Setup Form to update the Unit assigned to the Customer. I can get it to add a new linked record column… but I want it to update the main associated Customer record to the Unit.

Hi! Yesterday evening my SendGrid Airtable app stopped working. I would get an error sign after clicking send and no explanation. After a day of lots of testing, I was able to figure out that what’s triggering the error is that the email template contains more than 8,000 characters, including characters created by merged fields. That’s so little for an HTML email…! I don’t want to go back to plain text, and have so many templates that I use… Has anyone else ran into this issue? Any workarounds? Thanks so much!

I have a master media list set up as a relational database in Airtable. I now want to create individual lists from the master list for each of my clients. I have considered using ‘Views’ but if I delete a contact in one view it will delete the data in all views. Is there an easier way to achieve my goal?

Somehow my apps aren’t loading the past 5 days. Everything else is working fine. Here’s what I’ve tried that’s not working: reloading the window reopening the Airtable base restarting Chrome It works and loads just fine in my desktop app. Anyone know what’s going on here? Thanks for any input in advance!

Hi there! We have a base on the pro plan that we normally use from EU locations without any issues. Now we are trying to use it from Canada and the browser tab where Airtable is open freezes making it impossible to work on the base. Our tech staff has checked the issue and concluded that it is related to Airtable performance. *Her laptop has enough specifications to work with Airtable (Intel Core i5, 16GB RAM, Windows 10, Chrome) In fact it works with Mercury, Zoiper, Slack normal, and without communications cuts. During the 5 min call, there have been no cuts, however, Airtable stayed blocked 2 times. * Analyzing the calls the browser makes to Airtable, he sees the calls POST to https://airtable.com/internal/beacon are those which stayed blocked and take more than 20 secs to resolve but just happens with some of them. Anyone experiencing similar issues?

Hi, i’m working with airtable a while now and i think it’s a really good software. But at the moment i’m stucked and i don’t find a solution. I was searching in the forum but didn’t find a solution that matches my problem. Maybe i’m not searching with the right keywords. Here is what i like to do: I have a table in which i import csv files called “Keywords” (let’s say f.e. every day a different csv file with the same structure). Every record which i import needs to be linked to a record in a second table called customer. At the moment i’m using the app “CSV Import” and after that i need to link every record manually to the other table (customer). For every record of a CSV file i import it is always the same record in the other table i like to link to. So i’m wondering if it’s possible to use a script (?) to import the csv file and have the opportunity to say to which record i like to link the records to so it’s just one step and it’s done automatically? I’m an absolute beginner in codi

My apps have not been loading for over two weeks! I do not know what is going on. My Gantt chart worked for a couple days after going pro, but now it just sits and spins. I have submitted help requests every way I know how, but have gotten no response. The support page is terrible. The contact us page just goes to the community instead of actually having contact info. The community has no good information for my problem. The last post only has 10 views so no one that can help is seeing it. When I try to post a new topic I have to select a category. I don’t feel any of the categories are correct and fear that they are not going to the correct support staff. Terrible support.

It’s impossible to scroll the desktop version of Airtable on an iPad Pro (2018, 12.9”) - either with touch or with the Magic Keyboard trackpad. I use the iPad as my primary device for work that often brings me away from the desktop, and so I essentially can’t work with Airtable unless I’m at home on a desktop. The iOS app does not have anywhere close to feature or interface-quality parity to the desktop, which makes it not an option for doing serious work in Airtable. Is there any plan to fix this? Are there any workarounds? Bug: Scrolling in Airtable Desktop on iPad Pro w/ Magic Keyboard

Zapier has now Google Home Assistant module. I was excited to see that as a potential replacement for IFTTT. It seems (at least in theory from how I see it), the Zapier workflow should allow to tell a command (in your phone or google speaker etc), Google Assistant will ask for the record I want to look up (e.g. by by number) and then update the field in the record using the voice. That’s how I see it. Wouldn’t this be amazing? Flow is setup and configured all green and good but if I tell Google the command, the flow doesn’t get triggered. I know it’s not issue with Google Assistant because my IFTTT flows still work. So it’s maybe Zapier flow still doesn’t work. It’s in Beta. Or has anybody get it working? What’s your experience?

Hello, I was hoping to show a field on a Gallery View but only if it had data in it. If this were possible some cards would show a field if there is data in it and others would not show the field if there was no data entered in the field. I have long cards taking up space with blank voids. Is this feature available? Similarly, the cards allow the same amount of space for all fields that are showing regardless of how much data there is. If there is a one-word answer I do not need three+ lines of empty space after it. I do not need the cards to be the same length. Thanks

How do you insert a zip code in a record when the zip code begins with “0”? In excel, I would place an “’” ahead of the 0 and it would remain. Thanks for the help.

Hi, my team and I are using the Web Clipper app to add relevant news articles to a News table which uses a linked record field to connect articles to our clients & prospects. Our total list of clients & prospects is currently ~10k so I limited our linked record to a view of our most recent contacts (~250). Unfortunately, the limited linked record selection doesn’t follow through to our Web Clipper and instead of 250, we have to select from a list of 10k when clipping articles which causes the extension to crash… Do you all know of a workaround or if this on the app’s roadmap? Thank you!

Hi, so when I drag and drop the single list item it doesn’t completely show the entire text . The height seems to be cut off and I need some help adjusting it.

I know that we can open the form in a web page. Just looking for a way to enter data directly into a form while its on the design mode.

I’m using the below formula to group by quarter. How do I change the dates they are using to determine the quarters? For example, our quarter 3 ended on 9/27, however the formula is including everything through 9/30 in quarter 3. CONCATENATE(“Q”,DATETIME_FORMAT({Invoice sent date}, “Q”)," ",YEAR({Invoice sent date}))

Hi everybody I’m looking for a formula that goes like this: IF: Created time is in week no. 40 then “A” IF: Created time is in week no. 41 then “B” IF: Created time is in week no. 42 then “C” I tried to do it myself… Nearly had it (I think) But I got errors. Can you guys help me?

Hi everyone, I’m new to Airtable and am wondering if it’s ideal for this application. I am working with a community to prioritize product selections: everyone gets a vote, and if something is missing they can add it. Not unlike what Rtings is doing with their product review backlog: https://www.rtings.com/tv/suggestions Would airtable allow: Users to view the table sorted by votes Vote on a finite number of items (a fixed number, bonus: within a fixed time frame) Add items that aren’t there Fetch item previews from provided URLs (in Rtings case, it’s amazon.com)

I have used Airtable for 1 year dropping Dropbox files into many Bases. For the last week, when I go into the Attachment Field and click on Dropbox, only a few folders pop up and then as you scroll, it stops after a few folders and an orange bar pops up saying “Error requesting Cloud.” I have tried on other bases and have tried to check all accounts, but no such luck. Suggestions?

Hi, I run an e-commerce website I built in Webflow and already collect both orders and users data in Airtable using Integromat. I am new to Airtable but already in love with the product. I would like to use Airtable and the data I have put into it to enhance my business emailing strategy. For now, I use the standard Webflow ecommerce emails to send orders notifications to my customers and don’t have yet a proper email marketing solution. The idea is to pair Airtable with an email service (like SendGrid for instance) using Integromat to trigger all kind of emails, from order notifications, to marketing emails, to product feedback emails, etc. I would like to use Airtable as a supercharged leads database (with more data than just contact details) to send emails using pre-built templates that would be filled by data picked in Airtable. For instance, if I need to send a “order shipped” email, I would like to create a scenario in Integromat that would pick all the needed data in Airtable, c

Hi all, let me try to explain what I am looking for and hopefully someone can follow and assist. I have a shared view link and wish to embed that into a web page. I want to filter the embedded view based on user input and not have to create multiple view links. More detail: User submits a form (think of the user “logging in”) Based on their input, the shared view link embedded on the web page is filtered (lets say by state) Cogntio Forms and other apps permit embedded items to be filled based on URL parameters. Thanks in advance for your help.

I have a couple of questions about billing which are making my head hurt when I try look up the answers in the support documentation. Maybe you can help? I have 2 business. One of which I run with a business partner who has his own “Pro Level” Airtable workspace that he shares with me. He gets charged for me being a Pro level collaborator and then I reimburse him that cost. My 2nd business I run on my own but I also want Pro level features on those bases. However, I don’t necessarily want to have to keep them in the shared workspace with my partner from the other business but I would get charged an additional fee for having Pro on 2 workspaces, correct? It seems weird that I would get charged for a 2nd Pro workspace when really all I’m trying to do is keep certain bases private and keep them visually organized. I’m not understanding the logic behind the billing of Airtable at all and I really have tried. I’ve never encountered any other company that has such a convoluted billing system

Hi everyone, I need create date format as below (Monday 5-Oct-2020) in excel we easy to to use ddd dd-mmm-yyyy. I can’t find any preset date format as my request format, anybody can show me how to create date format with day. Thanks