Solved

Please any guide on this? I am  trying to fetch all the data from the products endpoint of an API using a limit of max 500 data point per fetch and an offset that increment per every fetchSo if the offset is 0, and the fetching max limit of 500 the next offset = 500, 1000, 1500 in that order.I already have to script fetching the data at max of 500 but I have to always manually set the offsets which is time consuming so I want this to be automated in code. If I can get a sample code that does similar I will be glad 

Hello,Thank you in advance for your help. I explain you my project 😃I am in charge of a product sourcing agency.I need to make a catalog of my products, but I need to be able to change the price of the product depending on the country of delivery.Example:Product 1 : USA : Price 10 DollarsProduct 1 : FR : Price 15 DollarsProduct 1 : CA : Price 20 Dollars.If you can help me with this it would be great 😃I don't know how to do it, with a select single maybe?

What is the excel index match equivalent in a table?

Hi there! I'm new to Airtable and trying to figure out how everything works. Let's say I have a cell that as the following information I inserted below: Beef Onion Burgers with PicklesIngredients:2 hamburger patties1 onion, diced2 tablespoons ketchup4 slices pickles2 hamburger bunsHow can I separate all of the text to the left of the word  "ingredients" into one cell? I basically am trying to extract the name of the recipe into its own cell.

Hi, I' new to Airtable. What I'm trying to do is to create a gantt chart with the start and end dates for the phases in a record to follow up the peoples workload which is different for each phase of a project. In one table I have the phases of a project in one record. I want them in a chart like below. I can create this with an automation via a "planning" table but I can't seem to update this table when a date changes in the original table. The link in the original table to the planning table contains the ID of each created record in the planning table (so 4). Can some one help me ?  An alternative is to delete all data in het planning table on a certain time interval and rebuild the entire table but I cant find the way to delete all the records in a table. thanks,  Koen  

Hi the following is what I would like to accomplish:When a records specific column changes, wait 30 min and if it hasn't changed again, send out an email.Is this something that is possible in airtables automation?Thank you

I’ve embedded the Gallery view on to my website, but I know that having all filter options available will be confusing and hard to navigate for my users. How can I specify what filter options I want them to be able to choose from (and ensure the other options are not available) in the shared view.

Looking for someone who can help write some code for my airtable base.Here is what I'm after: Table 1:Name 1, Website 1, blankName 2, Website 2, blankName 3, Website 3, blank Table 2Name 2, Website 2, blank Output - I'd like a function that looks up rows on Table 2, see's that there is already a name 2 identified on Table 1, and puts a message in the 'blank' e.g. Confirmed.

Hello,I'm new here and I need help. Firstly, English is my second language, sorry for the grammatical mistakes.I want to set an automatization when someone submittest a form to Table "Dary" (donations), I want it to search two other tables "Kontakty" (Contacts of individuals) a "Firmy" (Contacts of companies) if there is a record of the donator. If yes add the donation to the donator's record. If not create a new record in its respective Table.Is it even possible? Thanks a lot.

I have a Table with organizations. Each org has people attached to them via a People Table. Each organization has a status. One of them can be 'Contact The Organization'. How/where do I create a View to show me all the people I should contact, for all orgs. I want a grid view with columns to display Contact details such as Name, Email, Phone plus the org name they are associated with plus a few other org columns such as Status and Country.Insights are much appreciated. 

I guess this is a dumb question ...If I design a to do list will my tasks sync between the Android app and my Windows app?

I'm pretty sure I've seen this covered before, so forgive the reposting. I want to create a field that generates a flag icon/emoji if a checkbox field is checked.I'll use this to add the icon to my field title (using Concatenate) so it draws attention. I've done the same thing using the SWITCH formula, but I can't figure out how to do it with a checkbox field.TIA! 

Hello! I have 4 date fields, and for a given record, any of the 4 could be filled in (or several of them, or all of them). I've written a formula to return 'Y' if any of the 4 dates fall within the current week. Here's what I've got:IF(OR({Date 1}, {Date 2}, {Date 3}, {Date 4},IF(OR(((DATETIME_FORMAT({Date 1}, 'YYYY')&DATETIME_FORMAT({Date 1}, 'WW'))) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW')),((DATETIME_FORMAT({Date 2}, 'YYYY')&DATETIME_FORMAT({Date 2}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW'))),((DATETIME_FORMAT({Date 3}, 'YYYY')&DATETIME_FORMAT({Date 3}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW'))),((DATETIME_FORMAT({Date 4}, 'YYYY')&DATETIME_FORMAT({Date 4}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW')))),'Y', 'N')))I added the first IF(OR( argument to allow the second IF(OR( to run, no matter how many of the date fields have data in

Hey friendsI have one table that contains all the names of the people who paid money and one table of cold leads.I want to automate that when a new record is created in the payer's table, a V will be marked with that user based on their email in the cold leads table 1.I created an automation that looks for the email of the person who pays in table 1, but I can't find an option to "update records" for that email in table 1 because I can't find his record ID.I would love to understand what I am doing wrong.Thank you! 

The field entries are £20.49 and £13.66 (both fields set to 2 decimal places) but in a third field when I use CONCATENATE this is what I get:Summary: Headline £15000 pa Actual £9975 pa £20.491666666666667 £13.661111111111111How do I get £20.49 and £13.66 ?tiaps - I daresay this (sort of) question has been asked before but I have no idea what to search for. 

Hello,I have 4 columns setup. Date Opened - is a created time field, logs when an entry is createdTime Opened - is a formula field with the following:  TONOW({Date Opened}) - Simply logs in minutes (will likely change to hours) how long an entry has been opened for.Done - Simple checkmark boxDate Closed - Is a formula Field with the following: IF(Done = 1, LAST_MODIFIED_TIME(Done)) - simply logs the time an entry is marked as Done with a checkmark.My current issue is, I'd like Time Opened to stop counting as soon as Done is checked and I cant quite figure out how to do this. Does anyone have any pointers?Thanks!

Hey Guys, Im sure there is a very simple answer here but i am very knew to javascript in general, i appreciate any insight anyone can give me. I am using the airtable script function to post new users to an external application via it's rest api. I am successfully able to create the new user but i wish to record the ID number that is returned in the call back, i would like to use this in later steps in the air table automation but cannot get output.set to work. My script looks like so let inputconfig = input.config();console.log(inputconfig);let name = inputconfig.namelet password = inputconfig.passwordlet username = inputconfig.usernameconst options = {method: 'POST',headers: {accept: 'application/json','content-type': 'application/json',authorization: 'Bearer samsara_api_lxxxxxxxxxxxxxx'},body: JSON.stringify({name: name, username: username, password: password})};let response = await fetch('https://api.samsara.com/fleet/drivers', options).then(response => response.json()).the

Not sure if this is a air-table or zaiper question hopefully someone can explain to me. This is what im trying to do:Uploaded video To frame.io where the name of the video is the same as a Unique ID in airtable ( called Asset ID ) in Airtable search for a field ( Video Edit ) Input text or link  to inform that video has been uploaded I have tried to find the record using a search function and my zap looks ok but when i run it it does not update to the correct field.when i test the last part of my zap ( input text ) it will only place it in the first record and not the one attaching the unique ID i have tried the following SEARCH functions also FIND SEARCH(({Asset ID}))!={Edit}SEARCH(({Asset ID})) = {Edit}not sure if it is that or when i go to set up my action in the RECORD section i am picking the wrong dropdown.i thought it may be “custom” “zap search was found” but didn't work , and i have also tried multiple other options  any input would

Importing into a table (CSV, Excel, Pasted, etc.) with linked records will not allow mapping to linked records. The exact same data can be pasted into the GridView of the table and Airtable will expand the table to include the record count of the pasted data and correctly add the records to the table. The values for the linked records exist as would be expected by the paste into the GridView working properly. I am I doing something wrong? Thanks, Don

Hi,I'm working with the API, and when trying to create or update a SingleSelect field with a new select option, which was not exist, I get the following error:{"error":{"type":"INVALID_MULTIPLE_CHOICE_OPTIONS","message":"Insufficient permissions to create new select option \\"\\"v0.65.1\\"\\""}}%I set my personal API key with all of the available permission, i tried editing the field's permissions and set it with:* Allow this field to be set in records created through forms* Allow this field to be modified by automationsbut it didn't work.I didn't find anything useful in the API docs. Can anyone help? 

Hello! I have a base with ingredients, recipes, and meals. I’ve seen similar bases but none that ask this specific question. Airtable Ingredients Example - Airtable Explore the "Ingredients Example" base on Airtable. Meals reference recipes, and recipes reference ingredients. The meals table has a lookup to list all ingredients for the given meal based on the listed recipes for that meal. How do I get the number of times each ingredient has been used based on the meals table?

Hey guys, this is it -I have 2 forms on the site -1. Form for capturing leads (cold)2. Another form at a more advanced stage that captures very hot leads.I have automation in MAKE that actually transfers all the cold leads that come from the first form to the Airtable list.In each line for each lead in Airtable there is a checkbox whose purpose is - did the same lead also fill out details in form 2? (in order to understand if it is a hot lead) because it is also possible to reach form 2 without going through form 1 and therefore I do not want to create an additional column for those who fill out the form 2 but to update in the same column of the lead the person who filled in form 1. (so I will not have duplicate columns with different email or something like that)I managed to create an automation in Make that checks whether the incoming lead's email is in the list and if so to update, and if not to create a new one.My problems are as follows:1. Sometimes there are leads that use differ

Hi Everyone! I have a base with 30 tweets that I'd like to automatically publish everyday. Once I get to the end of those 30 tweets, I'd like to start from the beginning and repost them. I am familiar with the "post a tweet" automation provided by airtable, but I'm unable to find out how to make it restart from the top once it reaches the end of my base.Has anyone figured out how to do this?

I am looking for help, hopefully I can explain this well enough.In my Airtable, I have a multiple select field where you can choose different available mediums.  (Video, animation, poster, pdfs etc). And I want to create another column that automatically changes depending on what is selected.  If video or animation is selected, a V would appear in the column next to it.  If a “poster or PDF” is chosen a G would appear.  I cannot figure out what Formula to use.Basically I want it to be “if this is selected” then “show this”I tried creating a formula column and addedIF(Medium, 'Video/animation', 'V')IF(Medium, 'PDF', 'G')but it doesn't work so I assume i am doing this incorrectly, I'm new to formulas and building these tables, so any help is appreciated. 

Is there a workaround to use rich text markdown for a formula that provides a URL? More context: My formula provides a lengthy URL, and it triggers a slack notification. Would love to mark down so the slack notification doesn’t take up the entire window! Thanks in advance for your advice.