Other Questions

I have an Airtable Database with Fieldname (“Expense”) and values. I am trying to write a JS code to query if user input available in this database. Here is what I got so far. Appreciate help in getting the RegexMatch / FilterbyFormula work. Thank you! var Airtable = require('airtable'); var base = new Airtable({apiKey: 'myAPIkey'}).base('myAirtablebase'); var expenseCat = base('Imported table'); //name of the table function matchDemo(airtableField, testString) { console.log(airtableField,testString); // output works correctly "Expense Ikea" const records = base('Imported table').select({filterByFormula:`REGEX_MATCH({${airtableField}},"${testString}")`}).all(); return records; console.log(records); }; matchDemo("Expense", "ikea"); // sample call to check if use input "ikea" is available in the Database

I get checkin and check our dates from an outside source, and need to add hours to the date field in order to set a specific time in a calendar. The date with default time is stored as: 3/6/2020 12:00am the variable for this field is {Start date} I need to add 15 hours to this calendar entry to make the check-in time 3/6/2020 3:00pm I use this formula, in order to be able to have the “15” a variable, I use CONCATENTATE to all for a variable in the future. DATETIME_PARSE( DATETIME_FORMAT( DATEADD({Start date}, CONCATENATE(’+’,15),‘hours’) ,‘M/DD/YYYY h:mm’)) the result of this is… 3/6/2020 3:00am it should be 3:00pm… if I add another 12 hours - + 27h the results are… 3/7/2020 3:00am am I missing something… why can’t I get the time into the pm half of the day?

I have a 4-room B&B, and I’m created a base (“Stats” base) that shows that stats of my B&B (i.e occupancy rate, occupied nights etc). I linked that to a “Bookings” based where there is a separate column for check-in and check-out dates. They’re also linked by month I have a guest who booked from February 26 to March 26. How do I pro-rate that entry so that 3 days will be counted in Feb, and 26 days will be counted in March?

I am new to Airtable. I am on free tier now. I have an extension to run a script - essentially for lookup. I am using a script for lookup as my base needs two conditions for reference and I cannot use the native Lookup functionality. My issue is that the script works perfectly for the first 15 records. The script stops working from record 16 onwards (I have total 29 records currently). To check whether there was anything wrong in records 16-29 that was causing trouble, I copied the base, deleted the first 15 records and ran the script. The script worked perfectly in the copied base on the remaining records (erstwhile record no. 15-29). I am quite perplexed. Can anyone guide me why is this happening. I checked if I had exceed the record limit. The total records across tables in my base adds up to ~600. Thanks in advance for helping

Hi all, lovely to be part of this community :slightly_smiling_face: I’m looking for a way to create badass overview over all of my tasks, from a homescreen base. I would want a simple homebase that shows me what to focus my attention on, pulled from different tables in different bases a) posts and articles that are in a specific phase (pulled from table 1 in base a) b) tasks (pulled from table 2 in base a) c) tasks (pulled from base b t/m infinite) ← my clients have their own base d) trigger reminders from a script i run (pulled from table 3 in base a) Is this doable? Is this the right setup? What with the clients all having their own base and such. Love to hear y our perspective on this. Thanks for you time!

Is there a way to quickly see all of the different values in a field, similar to how you can click to filter on a column in Excel and see all of the possible options (similar to screenshot from Excel below)? As an example, I have a field that is mostly blank but has a few records with varied single line text data. I want to quickly see what those different single line text lines are to see if I want to filter on any of them, but they’re not consistent enough to make it a single select field. For another example, I have a field of various dates and would like to filter by certain dates, but don’t know all of the choices off the top of my head. Is there a way to quickly see the list of choices without creating a separate view or using a pivot table? Again, I could choose a type of ‘single select field’ but it doesn’t organize the dates nicely to see by year/month/day like you can see when clicking to filter values in Excel. Thanks!

I got a notice from airtable. my records are over 1200. and I counted all records in each table in 1 base. (1 includes sync table from another base). my detailed questions are below. Is airtable import all records when I sync records from another base even if I filtered some records? Is there any other hidden things I need to know when I count records. I counted all current records and all synced records, but still 100 records difference between my count and airtable count.

Hi. I insert fields left and right in my table. I go about my business. I come back and Airtable has reset the order of the fields clearly into the Create Date order. Which means as i build out my table - and it is a big one! - i have to manually move every single column back to the position i had created it in. There is not bulk move function so this is painful. Additionally, there is no reason for Airtable to do this. IF we are given an Insert Left or Insert Right function it must be because it is recognised that we want This new field in This particular location. So why does it overwrite and default back to create date order? It is driving me nuts. Any workarounds? Oh, also, I found an old topic post where someone suggested that “Because it is a database it does not care about field order(Airtable does not anyway)”. But this is not at all true… a database should not randomly decide to re-order fields and column order EVER. Help! Please and thank you :slightly_smiling_face:

Hello airtable community, I have a query, I would like to know how I can do so that a button can have more than one link when pressing and that activates a pre-filled form. I share images of someone who has been able to do this that I mention. in image 1 it shows that it has the gallery view and below is the button and it is marked when you click on the first button it sends it to the url with the pre-filled form that is marked in image 2, and finally when you click Clicking the following button sends you to another url in image 3 with the pre-filled form. Thank you very much for your time. IMAGE 1 IMAGE 2 IMAGE3

Hi, so I am trying to create something like easy ERP/CRM for creating orders and have one “small” problem with linking multiple values to the table. I have: Table with products and prices Table with companies and their info Table with employes that are linked to specific companies (that works) Table with orders (here I have a problem) In that order I am linking to which company it belongs to (so far so good) But then I want to link one employe that is responsible for it - But only from company that was picked previously. I can’t be mixed from other company. Now I can Link any company to the order and any employe from any other company to the same order. Is there any way how to limit that? Thank you and have a nice day. Matt

Hey guys, I need some help and can’t find de answer for this! I have some projects and tasks, but each one have a kind of “weight” in certain steps, like: When a task is in To Do, it have a weight of 5% When a task is in Doing, it have a weight of 40% When a task is in Validation, it have a weight of 5% When a task is in Done, it have a weight of 50% When I sum all of them, the result is 100% I don’t know if it’s clear. I just want to do something like this /

Hi, I am an old school database developer and have recently discovered Airtable. I am intrigued and have signed up for the free account to try to discover what it’s about and how it all fits together. However, I am gobsmacked that there appears to be no downloads available to study Airtable. I am unable to learn from a screen. Whenever I teach myself new skills I do it by pouring over reference manuals and experimenting - that’s the way I learn. I simply cannot concentrate when some is spouting information at me in a webinar or a training video, clicking on various things instructing you to do this and that with out learning the REASON and UNDERLYING logic behind what you are doing. I also cannot read from the guides displayed onscreen, mainly because you have to keep swapping form the guide to your workspace trying to copy the examples. What I need is a printed manual I can learn from. I am not asking Airtable to provide printed manuals, just PDFs that I can download and print m

Hi there! I’m having an issue where I can’t add certain multi-select options to a form view that are referenced in another linked table. For example, in one table called “Groups”, there’s a series of options like A,B,C that a group organizer can set. In another table called “Participants”, (linked to Groups), I want the ability to reference those options to be selectable in a form to be filled out by the participants. However, any referenced or linked field does NOT appear as an available field to use in my Participants Table form, even though I can see them in grid view. I’ve tried every formula I can think of. What am I missing, or is there a workaround where I can duplicate data in a referenced column so it becomes “native” to that table and I can put it in a form? Thanks!

Hello, I am tryig to setup automatic CSV import of our product catalog to Airtable. Every morning it should update in case there are changes in prices or stuff. I was able to setup the Make.com (Integromat) scenario to: Get the CSV from FTP Parse the CSV And I can even create new records in airtable sucesfully BUT We use our codes for every product (and it is unique). I amy trying to setup that it will “Create new” record if it doesnt exist and “Update” if it does. I am trying to use “Upsert a Record” in Make.com scenario. But that only let me to pair it with Airtable “Record ID”… which the CSV of course can’t have. Does anyone figured out how to pair the records by OUR id? (which is IN the CSV and also Airtable first column) Thanks! Matt

Hi everyone. Let’s pretend that i have a table with some entries and an external person knows the name of a specific entry that he wants to update (maybe just one field). The table might be populated with colums with name/surname/mail address/phone number, and the external user is able to add an entry by a dedicated Form. Is there a way for an external user (which knows his email) to use this field to update somehow it’s phone number? A possible solution, for instance, is to have a form in which an external user input his mail and a phone number, and if his mail is recorded, the form updates the phone number. Maybe can be a form for another table, and an automation that checks at every new entry if something has to be changed. Is this doable? Thank you in advance.

Hello, I am looking to extract the individual dimensions of an object from a cell that contains them as a LXWXH string. for example, I have a cell that looks like 11’9" X 4’11" X 8’0", and would need those in three different cells as 11’9" | 4’11" | 8’0". Trying to find a formula that would do this for me. Thanks!

I’ve built a Project tracking space in Airtable and I would like it to automatically import my emails pertaining to that project into the project record. Is there a way to do that? Ultimately, I’d like to open the project record and see everything that’s involved with that project, emails, PO’s, Art Files and Client conversations. Right now the Airtable world is totally separate from the email world unless I take the time to copy an email and add it to the Chat of the project record.

Hi all, First time poster.! I am looking to import a file each day that we receive via e-mail. Using Zapier I can save the attachment to G Drive but can’t figure out how to get this data into a base as it hits the folder. I have tried using New file in G folder but you can’t see inside the file so you can’t map the data fields. I’ve converted the file to a Google Sheet to see if it was a CVS thing but same issue. Any help would be gratefully accepted.

Hi, I’ve built a website that pulls data from Airtable and displays them as custom posts in Wordpress. If a row is deleted from Airtable, it is deleted from Wordpress. If row-data is changed in Airtable, it is updated in Wordpress. All row data is stored in a custom field and can be displayed on the site using a bit of custom php. I know AirPress has been working on the same thing, although it didn’t quite fit my needs. If you want to have a look, go to individual books or authors here (http://700d196048ef63665a08376aa5dd9bebacc382bc.web26.temporaryurl.org/historier/) - it is, unfortunately for many, in Danish. If anyone knows how to make a php-lookup of a key/value-pair in a custom field, feel free to let me know! Regards

Hello Airtable community :slightly_smiling_face: First of all, apologize if I missed something, I’ve tried to find a way -as usual- before posting here. This seems so obvious that I can hardly believe it’s not possible … or I am totally wrong about how to use Airtable ! A few months ago, when discovering AirTable, I separated things on multiple bases within our workspace. Now that I have a better understanding of our needs, I would like to gather various bases, adding new tabs … but from what I see, using “+Add or import” only allows to create an empty table or to sync data from another table. I can’t import an existing “tab” from another base. Sure I could simply copy/paste records, but doing this, I’d lose the views I set up for the tables I’d like to import. I’d need to do this all the more that I’ve recently discovered Image MarkUp extension, that we badly need, and it seems the only way to get what we want, is to get our various bases in multiple tabs. Thanks in advance for you

I keep attendance with airtable. I would like my clients to be able to request a copy of their attendance and see it automatically. Ideally they would go to a website link “please show me my attendance” and it would show them their attendance for a range of dates. Is this possible? If so, how? Thank you.

I’m working on a fun, friends and family base for recording daily quiz results (Wordle etc.). The idea is that people can use an iOS shortcut to parse their score and past it to an Airtable base using the API. The eventual goal is to build a friends and family league for these types of games and maybe use interfaces to display the league. I’ve got the shortcut working for the most part in so much as I have game name, the game #, date and number of attempts to successfully get the answer working. However I thought it would be nice to bring through the visual representation of the attempts - this is the bit normally displayed using emoji. For example… :brown_square: :brown_square: :orange_square: :orange_square: :yellow_square: :yellow_square: :green_square: :star2: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :hammer: :star2: I was simply going to add these lines as a multi line text field in the base but I am st

Hello. My question here is if it is possible to give access to a Record just to a few people (non-collaborators) by a shared link, and if those people can edit the same record. I don’t want those people to have access to the full database, just to a specific record within a table. Many thanks.

Greetings wise ones! I have a base to track family medical history which includes a Doctors table and a Dr Appointment table. All appointments in the Dr Appointment table are linked to a doctor in the Doctors table. This includes past appointments and upcoming scheduled ones. In the Doctors table I would like one field where the date of the next appointment is calculated and shown and one where the most recent appointment is calculated and shown. How do I write a formula/rollup that looks at only the past or only the future dates and chooses the last of the past or next of the future? I’ve created fields calculating the appointment dates from TODAY if that helps. Thank you!

Hi, I am new and am attempting to show Gantt colored by ‘Category’. However, no matter what the only category I can use to color right now is ‘Status’. Thank you in advance for your help.