Other Questions

I have 3 tables: Budget, Liabilities, Projections. All have different columns, but there is one Total column in each table for multiple items, and I want to link to the sum of that Total column. Example: Budget = $5,000; Liabilities = $2,000; Projections = $15,000. I want the Overview to have a row for each, with that sum value in a column. I want to have a 4th table (Overview) with 3 rows, one for each table, and one column linking the Total from each table, that’s it. How can I do this? I’ve been able to use rollup but I need a separate column for each table and it looks odd. Any way to have one column showing the Total from each table on the 4th table?

Hi everybody, I’m new here and i passed all the afternoon trying to find a solution… My boss asked me to add to an existing database photos from a folder in Google drive that have more than 6000 references. I would like to do it automaticaly, the database has only 300 specifics references and i would like that the system find which photo correspond to which record to add it in attachement files. Just as a precision if it can helps, the references of each record and the “name” of the photo are the same, i just need the system upload me this 300 specific photos not the 6000 ones. Thank you !!

Hi there: On my website, I endeavor to: collect email address from user (used as an identifier) provide an image picker for an media type (ex: PDF, jpeg) store media in a file share somewhere (ex: G-Drive, Box, DropBox, Cloudinary, Typeform) synch the media (not just URL) between the file share and AirTable Bonus: The file share uses Google Computer Vision API for OCR and template recognition (ex: Box, Cloudinary). So what’s the best file picker, smart storage (ex: Cloudinary, Box), and integration tool?

Anyone else having issues with apps loading today? I am using chart and search app, but they keep crashing. The base is working fine as long as I don’t open the app.

I have heard that you are able to send thank-you cards to customers, as an automated service through Airtable. Any body know how to do this? Thanks in advance

Hi, I am sending emails to customer after a payment is made. I am using airtable and Zapier to do it. I have to ask the customer in that email if their phone number that they gave us is correct. If not, I would like to generate an individual link to click on that I can insert in that email in order to update the phone number. The data would be updated in the customer airtable record. Do you know how do to it without code ? Maybe it typeforme and zapier or something ? I could not find anything on it. Many thanks

Good Morning Airtable Community!! Here are two screenshots from my current table. The first one shows my field (Technology Stack Managed) across several different views. The second one is where I open up a specific view and you can see all of the options for that field within the individual view. I had duplicated an entire field to get this field so a lot of views were already filled in. But I need to delete the options within that new field for each record. I do NOT want to delete the field itself, just the options that are currently there, so each view can start with a clean slate. What I have been doing so empty each field so far is I have just been X-ing out each individual option to clear the whole thing out. There must be a way to clear out all options at once instead of doing it one by one I am sure there is a simple fix for this, but I’ve spent a few hours researching stuff on the community boards as well as the help page and I couldn’t find anything. Thanks in advance for

Hello! Is there any way to share the org chart block? I would like to share an interactive org chart with my company. Thank you!

Hi there, i’ve a form wich allow to enter bank details, i wonder if i can implement a control of the key account. thanks for your response

Hi ! I would like to automate a sending email but when I want to use information (email adress, prospect name…) from lookup function or Formula function, Airtable does not propose the content. ( Do you know why it is not possible ? Sorry for my english

hello. I have problem when I export gantt to pdf. It’s not suppot Thai Language How can I do to resolve this problem. Thank you. Joey Joy

Airtable asking me for feedback in a survey but the survey is not accessible (likely permissions issue in one of their customer support forms in Airtable). See screenshot. I use outlook email so why Airtable wouldn’t want to hear my feedback to survey sent to my email.

Hi, just wondering if comments also get deleted after one year (on the Pro plan) along with the revision history? Thanks!

Hello everyone, I have an airtable with a list of customers who are signed up to use a beta version of one of our software products. I have two multi-select columns, one that says “Must have features” and another that says “Important features” - many of them have multiple reasons. Each customer has a status (ex. live customer, demoed, etc) and a vertical (ex. home services, retail, etc). I want to be able to create a CHART to say - okay out of our retail customers, 10 want X feature, 5 want X feature, etc. However, customers that have more than one must have or important feature are being lumped into their own category. Unfortunately, airtable does not make it easy for me to use filters and see a count of the multi-select options. Also, this chart is extremely limited. When I try to export the data, all of the multiple select options are being lumped into one column. Does anyone have any suggestions on how I can better separate out this data?

How could I use a script that does this to update two fields in my table? IF(FIND(",",{Name}),TRIM(MID({Name},SEARCH(",",{Name})+1,500))) I know it works fine as a formula but I don’t want a formula field since I want to link the email to another table. I’m pulling info from new gmail emails with zapier but there’s is always going to be two recipients and I only need the second person’s name and email.

Hi, I had multiple databases on my username. I have used another account for an extended period. Now upon logging back in, I can only find a “virgin” account with only a few sample databases as if the account was set up afresh. All my databases have disappeared. I’m logging in with the correct ID/ password (I get in without any troubles) and I have never deleted my databases. Where are they and how can I get them back?

I’m new to all this, so have a very simple question - how do I alter the width of my columns in my Base? I’ve started from scratch on my iPad with a Recipe database and I want to expand the left hand column to display the full title of the recipe, but it just won’t let me do it. I also want a narrower column which just lists the type of recipe and I can’t do that either.

Apologies if I’ve posted in the wrong section. I’m looking for a Kickstarter fulfillment management solution. Is Airtable the correct approach for me or would I be better served by sticking to Mailchimp? I need to refer to and update about 1800 personal records with backer no.s and UIDs, what they’ve paid for or haven’t paid for. I need to distribute individual digital keys via email and be able to check if an email has been opened. Currently I’m using MailChimp for this but it’s clearly not suited for database management vs Airtable. Bottom line: Airtable will clearly provide me with a relatively easy to use database but will the email management tools or add-ons be as effective as MailChimp’s? Any advice would be gratefully received. FWIW the built in tools for communicating with Backers on the Kickstarter site are woefully inadequate and 3rd party solutions are very expensive. We’re cleaning someone else’s Kickstarter so it’s a thankless task as we didn’t receive a cent of the origi

hello, i’m trying to use the vega-Lite block but something eludes me: when I try to use as x: a lookup field, it just doesnt work. Here’s my very basic code: { “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “title”: “XXX”, “width”: “container”, “height”: “container”, “mark”: “bar”, “encoding”: { “x”: { “field”: “CAFF.agence”, “type”: “nominal” }, “y”: { “aggregate”: “count”, “type”: “quantitative” } } } And here is the result : obviously CAFF.agence is well defined… And it works if I try on a non-lookup field. When I try other types, the graph preview doesnt print, so I guess that’s not the issue ; anyway CAFF.agence should be a town name (like, “Paris”). Is it a limitation of the vega-lite block? Or is it my understanding of the “type” ? Thanks

I was supposed to be charged with 13$ & as soon as I put my card you charged me with 3 transactions, 520$, 45$ & 48$. That’s 613$ I need my transactions back now please.

Hey :slightly_smiling_face: We have about 50 bases and we wish to change some fields type in all bases and add more filelds to all bases at once. any idea how to do that?

Hey, guys! A complete newbie to Integromat here. How does the Sleep module work between different scenarios? Let’s say I have a scenario with a Sleep module of 300s. Will the 2nd scenario wait for the 1st scenario to finish its Sleep module? In my case, the 1st scenario is when a new record is created in Airtable → send notification to Slack → then after it Sleeps for 300s → it searches any status updates were made in the same record with the same record ID. But what if I I want to delay the module for 1 hour instead of Sleep (300s), will my 2nd scenario wait 1 hour too?

Hello, I am trying to implement a leaderboard in my game, and am having issues with getting the record ID for a record based on the user’s unique UserID from my base, so I can update that record. I searched and found this post with 2 different examples, but wasn’t able to adapt them to my use. Here is my code, with the field from my base being “userid” and “recordid” being the variable I want to fill with the Record ID: const myuseridstring = String(myuserid); base('Table 1').select({ filterByFormula: '{userid} = "${name}"', }).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved record', record.getId('myuseridstring')); recordid = record.getId('myuseridstring'); }); }, function done(error) { }); I appreciate any help, I’ve been stuck on this for a while. Thanks!

is there a way to do everything i can within the gui of airtable, within an app or javascript? i want to use this not for personal use. i want to use this as a (would it be considered a…?) database for my web-app. sorry if i do not provide enough context. i am pretty new here.

Hi everyone. I am trying to create a marking schedule for my university. Each of the assessments to be marked has a score, depending upon how much work it will be. I’m trying to find a way of divvying up the work so that I can adjust everyone’s marking workload. Not all of us are full time. Ideally, there would be a way that I could assign a number of assessments to each colleague and see what the “score” is. Kind of stuck on it right now. Help please! Airtable Marking Schedule - Airtable Explore the "Marking Schedule" base on Airtable.