Solved

I recently discovered that when I multiply 6.1 * 3, and convert the product to a string using product & “” the result is a string with repeating decimals, even though the numeric result is simply 18.3. This is actually causing a serious problem in my table when formatting prices for invoices. Any insight is appreciated, thanks!

Dear Airtable, I am trying to automate something. I am having people submit a form. In this form, Column/Question 2 corresponds to a Multiple Select field where they can select their name from a dropdown. Column/Question 3 is where they input a time and then they hit submit I want the value from Sheet 2 Person A Column 3 to add with the value on Sheet 1 Person A Column 3, value from Sheet 2 Person B Column 3 to add with the value on Sheet 2 Person B Column 3 etc. I have spent the past 3 days trying to figure it out with rollup and I’m still super confused. Any help is appreciated. Thanks in advance!

I have two types of contacts in our CRM. I would like to be able to show certain fields for one type and show other fields for the other type. Is this possible to have this behavior? Thanks.

Hi How do I do the interactive tutorial on this community forum? Here is the screenshot of the Badge description: Thank you, Mary P.S. Another member was looking for this too, so I hope I will be able to find it, so I can do the tutorial. Mary

Airtable Gurus, I need help! I’m looking for a way to return all the field names that contain a certain value. Let me explain: I’m gathering documents from clients, and I’ve sent them a survey asking them what types of documents they have, and in what form. The survey contained multiple questions along these lines: Do you have documents relating to Topic X? Check all that apply: [ ] Emails [ ] Hard Copy Documents [ ] Electronic Documents As a result, I have many multiple-select Document Category Fields that contain one or more of the “Document Format” responses (e.g., “Emails,” “Hard Copy,” etc.). What I’d like to do is now generate a list for each client of all the documents they said they had, so that I can follow up on each category and ensure that we’ve collected everything they have. The way I imagine this working (although I’m open to other suggestions), is a single field for each document category, which would search in each Document Category Field for a particular Docum

I’m writing a php script in which I need to fetch all records from a certain base of about 1000 records (and store them in one array so I can handle some stuff). As I understand the max pageSize is 100, but with the offset it returns and using this as a parameter in your next request you can get the next pages. But this doesn’t seem to really work. I can get a few pages (actually sometimes just one) until it throws the error LIST_RECORDS_ITERATOR_NOT_AVAILABLE on me. I simply never am able to fetch every page. This error always occurs. How can I proceed from this error to be able to fetch every record? Am I missing something? A snippet from my code: //curl code ... curl_close($ch); $airtable_response = json_decode($entries, TRUE); foreach ($airtable_response["records"] as $key => $record) { $all_records[] = $record; } // Next page if there is one if( $airtable_response['offset'] ) { fetch_records($url . "?offset=" . $airtable_response['offset']); } else { return $all_records; }

Newbie here. I have a school table with a list of schools, a School district table, and a Contacts table. Schools are linked to school districts. Contacts can be linked to a school OR a school district. What I am trying to do is enter a new contact in the contacts table:. If the contact is related to a school, I choose the school in the school field and the district field is auto-populated If the contact is a district contact (no school) I want to be able to type in or choose the district in the same District field. I don’t know how to accomplish both in the same district field.

Hi there I am just getting started with air table and am stuck on something. Say I have a table which is categories of tasks, and then I want within each category to have actual tasks. Is there a way that I can click on something in the higher level table (a category) and then go to the lower level table, but only see the tasks associated with that category, without having to filter the tasks by the category field? - i.e. it would auto-filter the task table based on what I had clicked on? I know it will seem like, in this situation, it isn’t that hard to just then filter, but this is just an example of how I want to use it - I want to be able to drill-down into data which is all nested.

Hi. I thought i would see if I could execute a simple class booking system where the Airtable booking form was linked to an art class session. It doesn’t look like I can allow people to book only clases in the future etc. Any ideas would be appreciated. Thanks. Update: Playing around with form prefilling and this seems to have potential…

Hi, I haven’t seem to come across this on Airtable forums and cannot seem to find the answer across other online communities. While prefilling an Airtable form is pretty straightforward, I’m not sure how to insert a line break into a long text field type. The parameter for the URL to insert a blank space is ‘%20’ or ( ‘+’ ), I’m wondering what the parameter might be for a line break? Any help appreciated. Tom.

Hi, I teach an online course, and I’m using a base to collect files from students for assignments, sort of like a dropbox. I’ve built a form that has required fields, like Name, Student ID Number, and a dropdown menu for choosing which assignment they’re turning in. This works beautifully, except there’s no timestamp associated with their upload of an assignment. So, if I don’t record all of the assignments turned in by the deadline, someone could turn in something late without my knowing it’s late. Is there a way to add a timestamp to a field within a form? Thanks for your help!

Hello! I would like to set up a sort of competition. For example, let’s say I would like to keep track of the number of pushups someone does and reward the person with the most push-ups (assume that no one will lie). I was thinking of the following setup. One table hosting the user’s information, and a second table that contains entries for every single day. I can’t really do a normal linked column because that reveals all of the information of the other participants when I make a form. I tried doing something using the incrementing number field on the users table and then having an ID column on the pushups table but I can’t really find a way to do something like SELECT * FROM pushups WHERE ID=1. Is this too complex for Airtable? I can provide any more information if you need. Thanks

So I have a potential client who would like to embed specific views on his site so the public can view the data, but he doesn’t want the user to be able to sort and group the data. The request seems a little wild to me, but that is what they want and you give the customer what they want! Is there anyway to do this? Currently I am just saying we can send you PDFs and then you can post those on the site, but that obviously isn’t as cool. Does anyone have any better ideas?

I’m trying to create a formula that will list multiple fields that are empty, but can only get it to list a single field. It is meant to be a quick reference field to see what info is not filled out in a row. The goal: IF {Field 1}, {Field 2}, {Field 3} are all empty, but {Field 4} is filled out, then list “Field 1, Field 2, Field 3” Below is my attempt. It only ever lists a single field, seemingly overwriting other values that would be returned. If I introduce OR IF it breaks the formula. IF({Film Year}=BLANK(), “Film Year”, IF({Print Source}=BLANK(), “Print Source”,IF({RT (min)}=BLANK(), “RT (min)”)))

Hello. I have product titles which are generated by combining quantity per set, color, and finish. So far, I have managed to write an IF nested formula for the color & finish scenarios: {IDENTITY_Parent Product Name}&IF(OPTION_Color=BLANK(), ‘, ‘&OPTION_Finish&’ Finish’, IF(OPTION_Finish, ‘, ‘&OPTION_Color&’, ‘&OPTION_Finish&’ Finish’, IF(OPTION_Color, ', '&OPTION_Color))) However, I would like to add a scenario at the beginning, that IF the “SET OF” field is >1, it will then write ‘Set Of {Set of}’ right after the {IDENTITY_Parent Product Name}. For that part, I wrote the following: IF({FEATURES_QTY Per SKU}>1, {IDENTITY_Parent Product Name}&’, Set Of '&{FEATURES_QTY Per SKU} The challenge I am having is that any way I tried to combine either I would get an error, or it would stop reading if it found the Set Of >1, whereas I want the formula to not stop reading there but continue on and apply the rest of it to have a result where we

in our simple CRM system for our shop, we’d like to keep record of which dates the repeat customers have visited in the past. (and count them up to know how times total he/she has visited) We know each day the customer visits since the staff enters it, but what’s the best practice for keeping track of all the dates of the visits? Is there a way to automate some of this?

Hi all, I am wondering if I had a long text field and then a multi select field for key words, could I create a formula to show each key word and a count of it’s occurrence in the text field.

Expected behaviour: return the number of selected items.

I would like to use lookup in formula field. How can I make it? Here is my Airtable. Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free. In the Table A, the data which entered by the user via form is “a”. Then the data will convert by a formula into “aa”. This “aa” is the key data in the Table B. I want to lookup the data form Table B using “aa”. Here is the form. Airtable Form - Airtable Fill out the "Form" form quickly and securely on Airtable. Thanks for your great support!

So, I made a calendar view based on a calculated field. Everything in the calculation seems correct and items appear in the proper spots within the calendar. But every entry on the calendar begins by showing the month in the date calculation. Why? You can clearly see which month each entry is using - it’s a calendar! So why show this subset of a field before showing the primary field name? Seems like a bug.

Hi I have a student / courses many to many relationship. I’d like to have a column in the Students table with only the current year’s course. Is there a way to to this using a formula? It guess it would have to filter according to the year column of the Courses table. If courses.year = 17 () Is this in any way possible?

How long can long text be?

Airtable doesn’t seem especially forgiving of formulas doing numerical operations when the original cell contained text. For example, I have a cell describing engine sizes of cars. They’re pasted in like the following: “1498cc”. I’d like to show the engine size in litres, which would translate to “1.5 Litres” What I’d like to do is have a formula substitute out the ‘cc’, then divide the remaining 1498 by 1000 (which would be 1.498), then round the 1.498 to 1 decimal place (1.5), and then put " Litres" at the end of it. The following formula works exactly as you’d expect in Google Sheets / Excel: =concatenate(round(substitute({Engine Size}, “cc”, “”)/1000, 1), " Litres") However, Airtable formulas doesn’t seem to be able to treat ‘1498’ as a number after the ‘cc’ has been removed.

I’m struggling with dates, and suspect it might have to do with the different conventions for describing dates. Here in NZ (and in most of Europe) we use DD-MM-YYYY whereas in the US you use MM-DD-YYYY. Rather than describe in words, it will be easier to show you these screenshots that tell the story. I’m trying to present a date (that is recognised as a date), that is stripped of the time details in the DateTimeStart field.

I have a field called {Expires}. I would like to use the filterByFormula parameter via the API to retrieve records that have no expiration date or that have not yet expired. This successfully retrieves records that have no expiration: {Expires}=’’ This successfully retrieves records that have not yet expired: IS_BEFORE(TODAY(), {Expires}) Putting the two statements into an “OR” condition seems like it should work, however it only returns records that have not yet expired—omitting records that are empty/blank/have no expiration: OR({Expires}=’’, IS_BEFORE(TODAY(), {Expires})) I have also tried testing for ISERROR rather than =’’, but the behavior is the same. This works as expected (returns records with an empty/blank {Expires} field): ISERROR(IS_BEFORE(TODAY(), {Expires})) This omits records with empty {Expires}: OR(ISERROR(IS_BEFORE(TODAY(), {Expires})), IS_BEFORE(TODAY(), {Expires}))