Solved

Hi, Just trying out Airtable as an alternative to Notion. So far so good, however there is an issue for me in Safari (v13.1.1, on macOS) in that I cannot scroll my table at all (horizontally or vertically). The same table works perfectly in Chrome on the same machine. Let me know how I can provide more details (i.e. a private link to the table if it helps support) Thanks - Ian.

We have used CSV Import block, and it work well. But when we integrate it into our website using iframe, it seems that CSV Import block didn’t work. Do CSV import block work within an iframe? Thank you.

Hi, I’m wanting to create a table with functionality such that: The “Name” of session Making Software is classified by “Topic” and “Subtopic”. Now, “Topic” is a linked to a list of records in the Topic table: This is pretty straightforward. And you can see that the Topic table links to a Subtopic table, with subtopics for each topic. When creating Sessions, I’d like to: Create a new Session record and specify the name (e.g. Making Software) Then select one of the Topics for that record (e.g. Computers) And then when I go to Subtopic for the Session … only subtopics for the topic are displayed and selectable (i.e. Apple & Windows are displayed, not Dyson) Is there some capability in AirTable that says: display the linked records for this table, but only those whose field matches that which is in this column? I hope that’s sufficiently clear :slightly_smiling_face: Thanks, Daniel

I have 2 fields Field 1: Date (lookup) Field 2: I wanna if the date (and time) Duplicate , just show 1 value date time . If it has 2,3 different date, i wanna show all of them And i use this formula and it shows error, what am i missing ?

Hello Community! Hoping, yet again, for assistance from a Formula pro. My table has the following look up fields: 1 - {Invite Docs} 2 - {Other Task-Related Docs} 3 - {Calendaring Docs} 4 - {Plan/MTG/After Event Docs} If there is a document in any one of these four fields, I need the Formula to return a value of “Has Docs”. In oher words, records that have blanks in all four fields would not return the “Has Docs” value. I attempted an IF statement, but with unsatisfactory results! :worried: I’m afraid the use of BLANK () is currently beyond my skill level. Thanks in advance for any assistance you can provide.

Hi, Looking for the best way to do this. I’ve got a Unit table that stores all the details for a course Unit (e.g. Introduction to French): I want to specify records for each week of that Unit, e.g. for the Unit “Musicianship 101”, we have a record for Week 1, Week 2, Week 3, etc (tracking information for each week): Musicianship 101 Week 1 Week 2 Week 3 … I created a table Unit Weeks that looks like this: Where the “Unit” field is a linked record back to the corresponding unit record in *Unit table. What’s the neatest way to do this? I’d like to hide the “Name” primary field. Is there any way? I’ve used grouping on the “Unit” field and hidden the “Name” primary field. Any better ways of doing this? Thanks, Daniel

IF( SEARCH(“1”, {Type of Workshop or Class Offered}), DATEADD({Proposed Date of Workshop or Class}, 0, ‘days’), IF( SEARCH(“2”, {Type of Workshop or Class Offered}), DATEADD({Proposed Date of Workshop or Class}, 1, ‘days’), IF( SEARCH(“3”, {Type of Workshop or Class Offered}), DATEADD({Proposed Date of Workshop or Class}, 2, 'days’), IF( SEARCH(“4", {Type of Workshop or Class Offered}), DATEADD({Proposed Date of Workshop or Class}, 3, ‘days’) ) ) ) I added the last bit by copying the one before it and now the formula doesn’t work, what am I doing wrong?

Hey, I’m trying to import a CSV that was initially exported from airtable but some of the feild names have changed. How do I do that without creating duplicates?

Hello everyone! Ive exhausted all my options. Hopefully the amazing Airtable Community can help me out… So in essence the formula needs to get words from Column A and separate them with a vertical bar i.e. " | " and if a set of words like “New This Month” exists in column A the spaces need to be replaced by underscores. In column A (Multiple Select) I have e.g: Movie, New This Month, Entertainment I need for column B (Formula) to produce the following with the data in column A e.g: Movie | New_This_Month | Entertainment Thank you in advance!

Is there a way to solve a simplex algorithm in airtable? Similar to solver in excel?

I have a table in which I track each time I contact a client. I also have a formula that uses the date contacted and cycle frequency to determine the next date to connect with the client. I also have a view that filters the view to only show future “next contact date.” I would like to create a way to show in this view only the clients I need to contact within the current 7 DAY week. I can’t come up with a formula, and the filter options for the view don’t provide a way to do this. I was thinking a separate column with a formula that would only populate if the “next contact date” column had a date for the current 7 DAY week. Maybe a checkmark and the view can be filtered if a record has a checkmark. I’m stumped and would love some thoughts.

I wrote a formula that converts options chosen from a multi-select list into a string and appends the responses when “other” is selected. I want to take the resulting comma separated string and convert them into links to connect to other records. Is there any way to do that without disrupting the formula? Or is there a way to continually copy the contents of column A into column B while being able to link column B to other records?

Hi, New to AirTable. I’ve got tables that look like: Courses (links to Units) Units (links to Modules) Modules (have a field called Video) A Unit will have one or more Modules. I know how to show Videos for a given Unit via lookup of all the Modules for a Unit. A Course will have one or more Units. What’s the best way in AirTable to show the Videos for a Course? Thanks, Daniel

This closed topic answered my question about accurate time stamps for imported records but i can’t figure out the formula… what is the operator for “not blank”. This is all very new to me and i am learning as i go… IF({Original Time Stamp}=BLANK(),"{Time Stamp}",IF{Original Time Stamp}=ISNOTBLANK, {Original Time Stamp}) https://community.airtable.com/t/created-date-time-field-and-imported-data/30941

Hello! I have 2 tables - “product” and “supplier” These tables are related: in the table “product” I see the supplier, in the table “supplier” I see what goods he has. When I am in the “supplier” table and click delete product, only the relationship between the tables is deleted. There are no changes to the “product” table. How to make it possible to remove goods from the table “supplier”? To remove not only the relationship between the tables, but also goods from the “product” table.

In my database of garden plants I use the field WETENSCHAPPELIJKE NAAM, it has two or three strings, the genus, the species and/or the variety of the plant. the variety always between apostrophe’s. I like to create a formula-field which automatically creates a CODE, the first character of each string in the field WETENSCHAPPELIJKE NAAM, without the apostroph. I tried but without the result, can somebody help?

I am creating an IF formula in the Primary field so I know which apartment my maintenance manager was in, doing what, on what date. I have a table that breaks it down by per suite so it is organized. I have this as my formula: Suite & “: " & Comments & " - " & IF({Date Completed}, " (” & DATETIME_FORMAT({Date Completed}, ‘ll’) & “)”) I copied and pasted it from a sample but it puts the date in brackets. I don’t want brackets around the date. I cannot figure out which parenthesis to eliminate. I have tried different ones but then I cannot save it due to errors in the formula. Is there a way to do this formula so the date is not in (bracketed)?

Is there any way to hide the view selector on the left to gain screen space?

Is there a way that we can automatically calculating based on different conditions For example IF Service: Deep tissue massage Time: 60 minutes Result: Commission: 80 IF Service: Deep tissue massage Time: 90 minutes Result: Commission: 150 IF Service: Pain Relief massage Time: 90 minutes Result: Commission: 140 Thank you so much :pray:

Anyone have any suggestions as to why I am not receiving a notification email when a form is submitted to airtable? After a form is submitted, a record does get created, it’s only the notification I don’t get. Also: I do have the “email me at xx@xxx.com” selected on the form, and I have checked my spam folder, but nothing there. Any advice?

Hi all, I created a survey in the form version and send out the links for those to complete. As with other surveys I’ve made, I should see the responses coming in in the Grid version however this isn’t occurring. I am not sure what troubleshooting I could do to get these responses visible. I completed the form, as a test, and that response is also not appearing. Any support or direction is greatly appreciated. Thanks, Samantha

Hi @Katherine_Duh, What is your Airtable’s Community Engine which it’s powered by ? I suppose backend is Airtable + Airtable’s API but I’m feeling a :star_struck: UX on your Airtable’s Community frontend so I’m curious ! Best, oLπ

Hello, I’m studying Airtable API and I have problem with receiving anything with cURL in PHP. All I’m getting is NULL value. Here is my code: function refreshCache(){ //get cURL resource $ch = curl_init(); //set url curl_setopt($ch, CURLOPT_URL, 'https://airtable.com/tbl5g83TtrSE0LpS0/viwcGbSmDc5FhHrHg/rec2UUOz1aQEPsuFL?api_key=MY_HIDDEN_KEY'); $out = curl_exec($ch); curl_close($ch); file_put_contents('cache.txt', $out); print_r($out); echo("<br/>"); var_dump(json_decode($out)); } refreshCache(); I know that I should receive SOMETHING, because table and rows aren’t empty. What I’m doing wornd? Thank you!

I’m new to Airtable and databases in general. My database will be used to organize a dance competition. I’m trying to construct a formula to calculate how many medals I will need for each competition. The number of medals needed depends on the type of dance and the number of competitors, a few of which are shown in the image below: My formula keeps returning an error (Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.). I have been through many Airtable articles, tutorials, and forum posts, and still do not know what I have done wrong. Any help is much appreciated. IF( AND( OR({Dance} = “Reel”, {Dance} = “Slip Jig”, {Dance} = “Single Jig”, {Dance} = “Light Jig”, {Dance} = “Treble Jig”, {Dance} = “Hornpipe”, {Dance} = “St Patricks Day”, {Dance} = “Humours of Bandon”, {Dance} = “Job of Journeywork”, {Dance} = “Blackbird”, {Dance} = “Garden of Daisies”, {Dance} = “White Blanket”), {Number Entered}>=4), 1, IF( AND({Dance} = “Reel & Set”,

I am trying to upload several jpgs to one record. I use ‘Gallery’ and drop files in bulk to the plus sign bottom right. They are pages from a book and therefore in a sequence. The files are numbered as jpgs in a numerical sequence. Why can I not have the viewed output remain in the correct sequence? Why is the output always reversed with the last item first? How can I fix this? Many thanks if anybody can help!