Other Questions

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.

Hi folks, I’ve searched for an answer to this and have yet to find it. Will consider hiring someone to handle this use case, too. My e-commerce platform allows me to create a number of custom fields that are essential for me to use in several ways, but it provides no way to edit them in bulk. In fact, it will only export those fields in a single cell like this: AWG=10;Color=Black;“Number of Conductors=4”;“Conductor type=Stranded”;CSA=YES;“Insulation=EPDM - Ethylene Propylene Diene Monomer”;“Jacket type=Thermoset CPE”; Not every product uses all the same fields, though many do. That means there is no consistent number of values in every cell. It could be several or 16 or …something else. Also, I don’t know why it puts quotes around some fo the value pairs but not others. It seems not to do it for short ones. Very odd. I would like to: Expand the one cell into columns using the value label before the “=” then populate the product row with the custom value that comes after the “=”. Edit

We are planning a conference with numerous workshops, each of which has a limited number of “spots” available. What is the best way to allow students to register until the slots are filled? We thought about using Forms, but we don’t know how to make the Form close automatically once the workshop capacity has been reached. Thank you!

I have a column “Company Name” that I want to check for possible duplicates. I love the Dedupe app, it’s very powerful but I need a way to highlighting the possible dupes without deciding what to do about those. I’ve seen some solutions but they all seem complicated. For now grouping by “Company Name” is the easiest way but means you need to scroll through the whole table.

Wondering if there is anyone workaround or app to achieve this? My ideal workflow is: User submits info via typeform Info gets logged in Airtable Database (table 1). Calculations are performed. A new airtable is generated (table 2) containing some info from table 1. Namely the calculation results Table 2 is delivered to customer with ability to edit as needed I know Airtable doesnt let you generate a new table automatically so wondering if theres another option Part 3 seems to be where AT breaks down

Hi! Just started to use AirTable and I like it very much! I understand that everything won’t be possible using this tools, so you have to be creative. But one thing that I can’t find, which I think should be there, is customizing/displaying more info in the week view in the calendar. Is that possible?

Our table can calculate our conversion % using a summary stat (% Filled). How can we make a chart using an app that will show this % change over time, since we want to see how our conversion rate changes over time.

Trying to figure this out…

I need to create a simple table which allows multiple people to enter their availability each day (everyday may be different). Everyone is located in a different timezone though and I want there to be a field which will display it in our native time gmt+7. Some ideas i had were Creating the time field, then another field which has their timezone + our timezone calculation, then parsing it into a new date/time field. Any help would be appreciated thank you

Hi, I created a form to share externally and had a private link I was using. A few days ago, I disabled that link but now need to re-enable it. I clicked into “Share Form” and the same link popped up, but when I click to open the form, it says " The private share link you tried to reach is not available. The owner of this base may have unshared or deleted it. Please contact them if you need access.". Is there a way to re-enable my previous link after I disabled it? I see there’s an option to generate a new link but have not tried that yet as I would ideally be able to use the previous one. Thank you!

Hello community I’m trying to add this function to the main column. This is the formula concatenate I use to show specific data. CONCATENATE({ :anger: Nombre Jugador},’ ‘,’|’,’ ‘, MID({ :anger: Año},3,2)) &’ '& { :star: :x: :heavy_dollar_sign: :older_man:t2: }& { :fire: }& ’ | '&{ :anger: Club 20/21} What I am looking to do is replace the star :star: emoji by :fire: when this column contains the emoji. And when doesn’t maintain the :star: emoji. Thanks in advance for your time and effort.

Hi:) How do I know if someone assessed a base? As i sent an invite and they assessed it, but I have no way of knowing it’s been assessed. Do I not receive notifications? Thanks,

Hi all (please forgive my amateur status & language) - I have two forms that feed into one base. Is there a way to tag the entries on the backend so they can be categorized separately? (For instance, some are coming through an application form, and others through an interest form.) We want the entries to be tagged based on which form they’re coming from, but the only tags we can see are based on what the user is selecting on the form itself. Thank you!!