Have other Airtable related questions? Post here!
Recently active
We do see issues today around Airtable attachments not being loaded and instead throwing back 500 error: https://dl.airtable.com/.attachments/35670b1d2eb89a62cdb718ec6acbd547/3a6815f8/Alisonhomepage.PNG https://dl.airtable.com/.attachmentThumbnails/b3d19273f72a3d6a7747ec71e3cbab0e/5dc94b33
Looking for a Page Designer font reference chart. Does anyone have a cheat-sheet that lists the font style for each available font in Page Designer?
Has anyone gotten this error? We use our SendGrid app to send weekly emails to our students, and this is the first time this has happened.
Hi everyone, Is there any possible to make a form for students to check their own attendance in whole semester? I know how to make a form but I can’t figure out what to do to bring specific data information to students who submitted the form. I have tried to check is there any similar topic to help me making this, but not enough for me to learn how.
Hi, I have the need to show linked fields as well as the primary in a form. Users click a field selection on the form and it does not explain or show them what they are picking? In this example Current Doc is the primary and is only a number. When i click Add, i get the scrolling pop-up window of all options: This is not helpful and would like to see the linked field which is the description of the Document as well? and then once a record is selected, it display’s the description linked field in the form as well So there is 2 issues here; Showing the linked field when choosing the input field, scrolling up and down the pop-up window, Embedding the linked field in the form, based on the selection in 1). Any guidance would be appreciated.
I community, I need your help. My customer can choose their date of delivery on my website. I have a formula on Airtable who calculate the sending date depending of the carrier choose by the customer : IF(Transporteur, DATEADD({Date souhaitée par le client}, SWITCH(Transporteur, ‘GLS’, -2, ‘Chronopost’, -1), ‘days’) ) {Date souhaitée par le client} : Delivery date Transporteur : GLS or Chronopost (my 2 carriers) -1 or -2 : calculation for "if the client ask for the 10th of december, the order has to be send the 8h if the client choose GLS. Finally, the time depend of the day of the week end. For exemple, if a cliente have a delivery date on Tuesday, i need to calcul -1 for GLS and not -2. How can i conditionned that ? Thank’s for your help Matthieu
Hi Community, I need your help and i have a simple question : with a submitted form, is it possible to create multiple records ? If yes, do you have a simple example ? Thank’s a lot, Matthieu
I need direction for this goal… I have a large list of names that I want a smaller number of users to interact with, primarily, selecting some names from the large list. The smaller user group are not collaborators; I could never afford that and they don’t really change any data, they make selections. The large list could be in the thousands, the smaller User Group in the hundreds. People are usually selecting between 1 and 30 names. I need to be able to embed this name selection process into a website and mobile environment. I’ve tried Google Sheets, but hit a brick wall. I am afraid I’m going to need to develop a formal app and have no idea how to do that. So… Does anyone have any ideas? Thank you, in advance, for any input.
Hey there, I am wanting to make an improved pivot table that allows me to do extra formatting and remove the sum fields which I am not interested in. I see a lot of the airtable apps are available to extend from in the blocks Github, but I don’t see the pivot table. Is this available somewhere or am I missing something?
Is there a way to build an interface or is there an app or script that will allow our company to use Airtable as a kiosk for our clients that come in our lobby? I have an airtable base for our thousands of program applicants, and we I want people to come up to our kiosk and search their names in the database, without seeing anyone else’s information (privacy is very important). Perhaps they look their names up and it just states what is the day they applied to the program and how long until they are selected? Or if they are not on the list, allow them to submit a message to our staff. The records view in the new Interface seems great, but we do not want everyone to see everyone else. This is why we are using the last name, first name, and birth date search engine. Is this at all possible in Airtable or any apps or scripts? Drew
Hi people, Dose anyone know how to make the correct date (I need year/mm/dd and time) in my table when my form get submitted? I tried the formula DATETIME_FORMAT(NOW(),'YYYY-MM-DD') also I tried CREATED_TIME() but the date and time shows up incorrect.
Hi! When I embed a grid view of a table, the Attachments of a linked record (a photo in this case) it s not shown And this is how it originally looks the view in my Airtable base: Can someone help me to understand why this is happening? Thanks
Hello, I have already asked a similar question with no success. I will try to explain a bit better what I am trying to achieve here. I am building a website where users can send offers/bids for items on Webflow. I connected Zapier and Airtable to achieve this flow. Everything is ok, the only problem is if someone sends a bid that is lower than the highest bid it will show as the highest. I managed to see the record I want to be synced to Webflow on my airtable if I multi filter by “bid” (highest first) and “date” (latest first). The problem is that when I run Zapier, it will transfer all the data from airtable and not only the top one. Here a screenshot to help you understand: ImgBB Frame-53 Image Frame-53 hosted in ImgBB Also, the bids sent are for connected to multiple records on another table, so I would need to select only the top bid for different records. My question is: How do I select only the highest number and the lates
Hi, I am brand new to Airtable, but loving it so far. I have a table that has one record that is more important than the rest, its the Master Document in a Document Register. What I would like to be able to do is display on the dashboard some info about this Master Record, but unable to select from the current Apps a way to do this? I don’t even need to find the document, as I know what it is by Doc Name, and simply want to look at this record and report on the Dashboard its Revision and its Date of Revision, (i have Fields that have this info already) To give you some context, as I’m not sure this makes sense, I have a record like this… Master Document 1.0 01/11/201 … and i simply want the App to display this for one Record, a bit like the Summary Settings app. Thank, Simon
I’m new to Airtable. I’m trying to fetch data from the CSV file and populate a content box. Trying to fetch data doing AJAX call. In google spreadsheet it’s pretty simple. var URL = spreadsheetsgooglecomfeedslist"+Yourkey+"defaultpublicvalues?alt=json url:URL method:“GET”, crossdomain:true, success:function(data){ var eventsData = data.feed.entry; My question is how can you get the URL for the CSV file you created in airtable.
Hello there so the title tells its self var type = "Coupons" var api_key = "?api_key=123456" var maxRecords = "&maxRecords=10" var filterByFormula = "&filterByFormula=%7Bvip_ou_50%7D%3D%2250%222" var next_page = document.getElementById("next"); var offset = ""; var page_suivante = function () { console.log(offset); offset = data.offset; console.log(offset); } page_suivante.onclick = page_suivante; var url = "https://api.airtable.com/v0/app123456/" + type + api_key + maxRecords + "&offset=" + offset + "&sort%5B0%5D%5Bfield%5D=coupons_id"; as you see i created function to change the link of the offset var next_page = function () { console.log(offset); offset = data.offset; console.log(offset); } page_suivante.onclick = next_page; What I should do or should add to the code ? Thanks for your help !
Hi, The calendar view does not show the subject. It shows only date and time. (See attachment)Screenshot_20211115_142953|252x500 Any way we can show the event name or subject?
To convert Hijri calender date, Excel formula is as follows: hijri = Gregorian - 622 + (Greorian - 622/33) I tried to get the Gregorian date for these Hijri dates but without success. Today’s Hijri Date is: 10/04/1443 Any help !!?
Hi, we had our base system set up and have basic knowledge but are now looking for someone to assist us with the more higher level/refining of our system. Someone based in New Zealand or Australia would be the most ideal.
Here is the use case: I have barcodes that are scanned to match data from Sheet 1 (Bins) to Sheet 2 (Pickups). Barcodes are in rotation, but only one barcode is scanned at each Pickup and Bin on the same day - giving us ability to match the data from each location. I have created a formula to create “Barcode - Date” in both sheets, then copy/pasted them as I read on this forum that you cannot link formulas. Issue is: When I go to link them and pull data from Sheet 1 to Sheet 2 it cannot find the data I am looking for (a dropdown of “customers” from “pickups”). Instead, Airtable seems to copy/paste my entire table, add it to the top couple thousand rows with no data pulled except for the Row ID (a long string used as a unique identifier) and matches that to the customer. So all other columns are empty, it is matching it to the wrong column from Sheet 2, AND in the table I have in the bottom couple thousand rows, it cannot lookup the data I want. Is this a bug?? Am I doing this wrong? Th
My Volunteer Application is filled out by people interested in volunteering. After attending an Orientation, they decide if they want to volunteer, not all people volunteer. For those who do volunteer, I need information from the volunteer application for two separate Google spreadsheets. Can airtable perform these functions so I don’t have to type in the information for the two spreadsheets? thanks
Hello everyone I’m trying to delete a file that I’ve uploaded. I realized that after a record delete, the attachment still existis in dll.airtable. How can I delete definitively any attachment from Airtable? Can I use the API for it?
Hi, I want to achieve the following, wonder if it’s possible with airtable I have an ongoing table of data, which I’m updating daily, I want to share this data with other users so they can add their own data into it but also get the updates I add daily into their table, in another word, there is a table AA, which updates daily, there are some user tables, which are based on the table AA, Users need to be able to add data into their own table but there is a need to import all the updates from table AA into the user’s table. does this sound doable in Airtable?
Hello! I’m new to airtable and formulas, and I’d love to figure out an automatic way to check if things are ideal as they or, or if I need to work on them… I have two fields: “Whose Job Now?” and “Whose Ideal Job?” that contain the same multi-select options. How could I use a formula to compare the two columns and check a box in another column called “Ideal?” when they match? Thanks so much for your help! -Allie
If you are saving a URL, what is the advantage of using field type URL vs single line text? Is there any difference? I can’t see a difference, but there probably is one! PS I love you all!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.