Other Questions

Hello everyone! I’d highly appreciate it if some could advise how to manage the below task: I am building a “recipe cost calculator”, where each recipe has a different amount of ingredients to use. I want to make a form where chef could input data and create new recipe, were main goal is to calculate the cost of this recipe. So, chef inputs the Recipe name, image, category, chooses ingredients, inputs its amount to use, and in the final box should appear a cost ($) of the recipe based on ingredients and their amounts. The existing “Food cost calculator” does not have option of calculation in this manner. It’s more general and is not as precise as I am want to build. I am struggling to build a form where chef can choose the ingredient and input its amount to use. Formulas for calculations are not a problem. Below is a sample form And table Thanks everyone in advance! Ahmet

Hello. I have two tables - Orders and Shipments. Orders are pre populated using an integration with Hubspot. Shipments are created manually using a ‘Create Shipment’ form on the Shipments table. I want to assign Shipments to Orders by clicking on a button in the record of the ‘Order’ named something like ‘Add Shipment’. This should then open a URL for the ‘Create Shipment’ form on the Shipments table. Ideally here though I want to pre fill the Order Number of the record that I clicked the button on. I have created a linked record field in the Shipments table which links to the Orders table. I have then appended the following to the URL for the button: “prefill_Order Number={RECORD_ID}” The linked record displays and I can choose the order number manually but it doesn’t pre fill. Can you let me know where I’m going wrong if possible? Thanks! Dan

Most of my attachments are no more displayed. The files name are still there but are replaced by a picture icon. The files are there too (I can download them from Airtable). Same things happen if I add new attachments : the files are imported, but are replaced by an icon. I have a presentation to a customer in a few hours…

I know this had been reported in the past, and had been marked as resolved, but it seems that the issue came back. Simply put, image attachments are not displayed, neither in the Android app nor on the web browser. You can still download the attachment, just not have it displayed in the table. The issue is happening with old images that used to display correctly as well as with newly uploaded images. Anyone else experiencing this issue?

Hi, i’m having an issue on the gallery view… I uploaded a pdf document on one my tabs…When i click on it, it got a broken image icon… If i click on it i get an error "We’re sorry, the preview didn’t load… This document may be protected… However document is not protected…If i download it from the options, i can open and view perfectly… This problem only started this morning…

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