Other Questions

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!

Hello guys, Im have a simple question about timeline view, I want to creat a timeline view with hours insted of days is that possible?

Organize everything with view sections Once you start building out an Airtable base, the number of views (like the new Gantt view ) can quickly multiply. To help better organize all of your views we’ve created view sections to enable base creators to organize views into collapsible sections. This provides a new way to manage your views - especially for bases that take advantage of all the different view types, including collaborative, personal, and locked views. Utilizing view sections will allow you to easily find and take action on your views while keeping your view experience organized. Learn more about view sections in this support article Hi, All “Organize everything with view sections” Tools disappeared from my UI ! On each and every Base, even after hard resetting my computer ! Am I the only one to know this issue, both in Firefox, Chrome and on two different MAC OS & Devices ? Thx, olπ

Hi there! I noticed a problem on a multiselect field. The problem is on the Android version app. I click on a multiselect field and select some values from the available choices. My choices are normally noted as selected. When i go back or revisit this record, these values appear as selected but when i click on the field to add some values or change what i have selected, no value is selected. If i try to select again some values for this field, i get the following error message “Sorry, your request conflicted with another change” Have you noticed this problem? Thank you

Hello, I have a table where all records have the created time field. I would like to add a view with only one record, the latest record created. It needs to update every time a new record is created being always up-to-date. Is it possible? Thanks

Hello, I’d like to count repetitive information only 1 unit and not all time it appears. For example in this image attached. I have 2 REIs and not 16.

Hello, I’m having a bit of trouble with the final piece of a project. In Table A I have a list of clients with their service rates for on-going deliveries. In Table B I have a set of fields used to capture specific components of the delivery and this acts as a database for all deliveries performed. I have set a linked record in Table B which links back to the client in Table A and have also set up a form for our drivers to capture the delivery within Table B. Now to keep things simple (as 90% of the time deliveries are the same each week but some do change), I made a calculated field in Table A which says is delivery today = “Yes” or “No” in Table A and created view which filters is delivery today = yes. This means our drivers know which clients to deliver to on a specific day. Now the problem is, I have the URL for the form from Table B in Table A showing to the driver and each time they perform a delivery they need to choose which client. Is there a way I can pre-populate the from fr

New to Airtable! I’m using several different forms to add contacts to a CRM (each with a new name) - is there any way to use a formula or automate a column or something similar that will note which form the person filled out?

Hey there! We’re trying to make our team check and update their own info already recorded in a table. Everyone will get a unique user and password. Let’s suppose John signed in correctly… the form will check if his user and password does exist and will show some fields like his full name, address,… that are in the table. Now John can update his info if needed. Is there a way to populate the fields based on the table’s records? Thanks in advance.

Date field are single date entries only. Other than manual entry in a long text field or multiple select field (using the actual date), is there a way to enter more than one date in a date field? Also, how can I filter for a range of dates, for example 30/10/2021 to 01/04/2022 tia

Hello! I’m trying to find a way to link 1 table to multiple rows in another table within the same base. For example – The first table in the base lists all of our customers (one per row). Another table in the base includes all of the action items that should be done for each customer (they are all the same). Is there a way to link the action items table to each customer, and further, allow for items to be checked off as they are done for each individual customer, without impacting those of another customer? Thanks in advance!