Solved

Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?

https://github.com/sleiman/airtable-phpI have been using this tool flawlessly and working my new Personal Token where my API key existed.use \TANIOS\Airtable\Airtable; $airtable = new Airtable(array( 'api_key' => 'API_KEY', 'base' => 'BASE_ID' ));When I swap out the API_KEY with my new Personal Token it doesn't work, which I suspected. What do I need to change api_key to? Is it that simple I hope! Thanks in advance!- Jon

Hi. Sorry if this is a silly question. I need to rename a table that has some airtable automations linked to it. Can anyone tell me whether the automations will dynamically change their settings to use the renamed table as before - or do I have to manually re-configure them to use the new table name?Many thanks.

Hi,Is there a way I can create a formula that will determine the Monday for all these dates and return just one date. For example, in this table it's looking up data from another table, in this case the Monday for this set of dates is the 12th. How con I accomplish this? I need it to create a "end of week".. which I already have the formula for that. Please help.

Dear all, With my team we are using airtable to do systematic reviews and extract data from science literature papers. For each study we created 2 rows and each one is assigned to a reviewer. So, for example, we have the coloumn “sample size” and reviewer 1 writes 89 in his record and reviewer 2 writes 98 in her record. Let us suppose that there is an incrugruence. I am using rollup function to ask Airtable to show me the content of the two cells. First I used rollup function ARRAYUNIQUE(values). It was ok but if a reviewer did not report the value he should had reported, I cannot see it and it might be useful to see this discrepance between filled and unfilled cells. Thus I used the ARRAYJOIN(values) to see both the values. It fixes the problem above because I can see what both reviewer have extracted, but for long text it might be difficoult to spot differences. So, here it comes my question. Is there any direct or indirect way to compare with (or without) rollup function two cell of

I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calculations)2. I also want to only include records with an authorized budget entered, so exclude any that the authorized budget=$0.00 (this removes TEST 2 and TEST 3 from my calculations)3. Of those filtered to only budgeted or not budgeted and not $0.00, I want to count the ones with a remaining budget greater than 0, and count those with remaining budget less than zero, getting a percentage of the two. (in this table you can see there would be 50% on budget, 50% remaining budget is negative.The end goal is to display the percent of records on budget, the percent of records over budget, and possibly the percent of records with no authorized budget entered. I know the process would involve another table with lookup fields and rollup fi

Hello. Still fairly new to Airtable and working to better understand formulas. I'm looking for input on the following.We have a rental space where rates are set based on duration (up to 4 hours, up to 6 hours, all day). I've set up a table for Rental Rates. Separately, I have a table for rental details, and this includes a duration field ("1st Day Duration") calculated based on rental start and end times.I'm trying to figure out how to create a formula that calculates the correct rental rate based on the duration and then pulling the correct rental rate. So for example, if a duration is 3 hours, the fee would be $x (since that's the "Up to 4 hours" fee). But if the duration is 7 hours, the fee would be $x since it would be a "Full day" rental.One other variable. I'm not sure how to plan for future rental rate changes, so that when rates change existing entries do not change (only newer entries). I'm assuming this starts with a date variable tied to rate increases. In the Rental Rates t

hello!I have a simple automation that finds a value in one record, finds the match in another table and links it in the source table. It works great for matching but when my source cell is blank it links all the records from the other table:here is a screenshot of the automation: https://cln.sh/dZzXpYYjand here is how it looks in data with the blank cell linking both records from the second table: https://cln.sh/n6S2g7kFim also suprised that is even able to link to multiple records as I do not have that option enabled: https://cln.sh/c3JVy3ggmy goal is for a blank source record to not link any record to the second tableI must be missing something simple but for the life of me can't figure out what im missing and searched all over... any thoughts appreciated!

Dear Airtable Community,I'm working in a multilingual environment (I'm based in Switzerland and working with partners in Africa, my daily job can involve up to 6 languages) . It is essential for my job to be able to collect data with multilingual forms, but then aggregate the results in the same answer field. For the survey part, Airtable allow very conveniently to reformulate the questions in the form view in as many languages as I want, and that is a no brainer.Where the things get complicated is when the survey includes a single or a multiple choice question.For the single choice, I've found a very practical solution:Insert all the possible answers in all the languages in a single choice field, then generate as many form as the languages and for each one filter out all the answers that are not in the correct language. Finally, aggregate all the answers in another field with a SWITCH Formula, as shown in this example here: https://airtable.com/shr9d4kkhOACVv5VK. I can then this

Integration with make.com + airtableI want to automate posting on different social media channels based on information in an Airtable database. After each successful post, I want to update a status column in Airtable to reflect which social media platform the post is live on.The issue I'm facing is that the status column keeps getting overwritten, so only the latest post's status is shown, instead of all the platforms the post is live on.I've tried using this command:{{merge(6.Live Status; add(emptyarray; "Live - FB"))}}The command works when there's pre-existing data in the Airtable cell BEFORE the router. However, it fails to recognize the updated status created after the router for each post. It seems to only read the Airtable data from before the router was introduced.Can anyone help? see attached screenshot for the scenario. Thanks

Hi! Wondering if there's any way to make this work...I have a formula field that pulls info from multiple fields & concatenates it all together to create an email (content) to be delivered to the person associated with that record.I want to include a Loom video gif in these emails. (To be clear: This is one shared video link/gif which is going out to everyone. Not unique videos for each person.)Is there any way to do this within Airtable? I'm aware that I could simply paste in the Loom URL. I'm hoping for a way to insert the video's gif file if possible.Thanks in advance!

Hi,It's been several months since I've done this, but basically, I'm trying to send an automation from a clicked button in an AT interface to a Make webhook that I've created. The automation so far was when a button is clicked > run a script. I've been able to successfully pull in a test record id via the "when a button is clicked" stage -- my field is named "rec_id" with the autogenerated formula and that works fine.FYI--when I hardcode the rec_id in there with the actual value, it works just fine with significantly less code. But with the code below--whenever I get to this step below, it just doesn't work. Can anyone help? Thanks!let recordID = input.config().rec_id;// Validate that recordID is not undefinedif (!recordID) {    throw new Error('recordID is undefined. Check the input configuration.');}THE WHOLE CODE// Define the record ID manually for testing purposes// Define the base URL for the HTTP request to the Make webhooklet url = "https://hook.us1.make.com/my

below is my code but the console log doesnt give me the number of records:async function loadRecordsAndLogCount() {console.log("Script started - attempting to fetch records.");try {const table = base.getTable("Tasks");console.log("Table 'Tasks' successfully accessed.");// Correctly await the asynchronous call to selectRecordsAsyncconst query = await table.selectRecordsAsync({fields: ["Predecessors", "Tasks", "Next task"]});// Log the total number of records fetchedconsole.log("Records selected, total:", query.records.length);} catch (error) {// Log any errors encountered during the executionconsole.error("Script encountered an error:", error);}}// Make sure to call the async function and properly handle any uncaught errorsloadRecordsAndLogCount().catch(error => console.error("Unhandled script error:", error));

=XLOOKUP(9,Table2[max],Table2[tier],,1) Trying to recreate this with automation but keep getting a list error.Have two tables: Projects and Fees, Projects has a number field, and Fees has a list of pricing tiers with a max number field. I want link fee data by automating the record link between Projects and Fees based on match the Project number field within a Fee Tier.See below, ignore first two setup steps, Find records find the Tier, but the last step fails due to "insufficient permissions"    

Hi!I'm new to the Airtable community, I'm still finding my way around. I hope all is well!Sooooo, Im wanting to create a smoother process for sending out invoices to my sub-contractors for a work week (Mon- Sun). I have come across a bump!Let's pretend this work week is Feb/12 - Feb/18 (Mon-Sun)So I have two tables:1. Booking Details: ignore the entry at the bottom, it's not part of the pretend work week2. Payout Details Now, The info from table 1 contains a job record: who worked it, the price, the date, etc. In this case, all those jobs were worked by "test@gmail.com" (one person). These jobs were done in different days but in the same Work week of Feb.12-Feb.18. Table 2 is supposed to put all the jobs together from this work week and combine them into 1 record: who worked them, the names of the jobs... which would go under booking details (name: from table 1, first column), and add the total of jobs completed.Now, for table 2, the reason I put start date and end date (although

Bonjour à tous, J'ai un fichier avec une colonne TEXTE LONG et je souhaite remplir une colonne de SELECTION UNIQUE automatiquement en fonction d'un morceau de TEXTPouvez-vous m'aider ?

Hello everyone, I’ve got this error Error: network timeout at: https://api.airtable.com/v2/bases/appOZnMxRdfPA9ddR/tables/tbledHinNmtQRT4lb/records/update But this weird thing is that the update works. But still, i have this error. tableSociete.updateRecordsAsync([{ id: societe.id, fields: { "refreshtoken": responseJson.refresh_token, "accesstoken": responseJson.access_token }, }]) The other weird thing is that i dont have the error everytime but just with some “societe.id”

Hi !     I created a column to identify if the "End Date" of a task belongs to one of the weeks below, based on the ISO numbers for each week of the year (1~52 or 53).      But I am facing an error due to the year, that I cannot overpass.      It is considering the pure number of a week in 2023 (e.g.: #49) as a week in future, because the actual week number in 2024 is less than that.     Please, can someone help me with it?PAST: "End Date" week number < actual week numberTHIS WEEK: "End Date" week number = actual week numberNEXT WEEK: "End Date" week number = actual week number +1FUTURE: End "Date" week number = actual week number +2Here is the actual formula I have that is running, depite the error from year:"IF({End Date},IF(AND(YEAR({End Date}) = YEAR(TODAY()),DATETIME_DIFF({End Date}, TODAY(), 'days') < 0),"PAST",IF(AND(YEAR({End Date}) = YEAR(TODAY()),VALUE(DATETIME_FORMAT({End Date}, 'W')) = VALUE(DA

I'm new to formulas but have learned quite a bit from these forums. I have arrays of Hardiness Zones for plants, which are written like this: 4a, 4b, 5a, 5b, 6a, 6b and so on. I need to put them into ranges like this "Zone 4-8". So far I have it this way:I used this formula to get it:IF(NOT(Zones=''), 'Zone' & ' ' & LEFT(ARRAYJOIN({Number value (from Zone test)}), 2) & '-' & RIGHT(ARRAYJOIN({Number value (from Zone test)}), 2), "")There is another column named Zones, and in the linked table, I had to put a space after 9 so that it would still register as having 2 characters in the field instead of just one.There are two problems with my outcome.Problem 1: Some of them only have a single number in the Number Value field. So that return looks like "Zone 10-10" and I want it just to say "Zone 10". I'm trying to use a nested IF(LEN) function in there but it's not coming

OverviewAllow users to assign different detail pages based on conditions.When a user expands a record from an interface, allow users to change which details page opens based on conditions of the expanded record.Setting the conditions could work using a UI similar to the one conditional coloring uses.Problem:There are many instances where I have records that share 90% of the same info, but based on some differences - such as Type or Status, need to be interacted with differently.For example, for my business we track furnishings and fixtures we refer to as "Items" for architectural projects. We need to ensure that certain pieces of information are recorded for each Item, but what pieces of information we need varies based on the Type of Item. There are so many different kinds of information that we need to record that we have as many as 120 different fields in our Items Table. ideally, we could show only those fields that apply based on a condition, in this case, the "Type" Field.I.E. If

How can I customize the Airtable interface to dynamically adjust bar colors based on the values stored within specific cells?Specifically, I'm interested in understanding the process of implementing such a feature within Airtable's interface to visually represent data more effectively.Are there any specific settings, configurations, or formulas that need to be applied to achieve this level of customization within Airtable's platform?Additionally, what are some best practices or considerations to keep in mind when setting up this feature to ensure clarity and coherence in data visualization?

I am NOT a coder... but this process is slowly making me one (sometimes to my regret).I am trying to put together a script triggered by a change in a field titled "Invoicing?" on a table named "ALL INVOICES 2024" that will update a different table titled "Client Overview" by adding "Offboard/Last Inv" to a field named "Active/Inactive." These two tables are NOT linked to each other and I don't want them to be, but they do have one field that is identical between the two of them: "Client ID."After banging my head against a wall for about two days, I decided to just backtrack to the most basic tutorial to see how I might put this together. My first task to "learn" is how to make Airtable identify the record that triggered the script to run. I stripped down to the easiest of tasks: Output the Record ID of the table that caused the trigger. I used a bit of code from this article: https://www.airscript.dev/2021/01/31/airtable-automations-scripts let inputConfig = input.c

Hello, let me first give a little backstory on the process I have leading up to where I need help...I have two tables (Table1 and Table2). There is a button on Table1 that triggers a script. The script copies a few fields from Table1 over to Table2, one of which is an alphanumeric code. While copying this alphanumeric code over to Table2, it also performs a check to see how many times this code already exists in Table2, and populates that number into a field. Table2 contains a complex formula that uses the existing alphanumeric code and the number of times that code has been seen before, to generate a new unique alphanumeric code. All of this works flawlessly, I'm just struggling to figure out how to execute the last step... copying this new unique alphanumeric code back to a field on Table1.First attempt at a solve, I setup a new automation that watches for new records entering a view on Table2. From there I know I'll be able to reference my new unique alphanumeric code, but I can't f

I’m trying to create an automation to take data from one cell in a record and paste it into another, linked, cell in that record. I set it up to trigger if “PART NAME” is not empty and “PARTS” is empty. Then it is supposed to take the value from “PART NAME” and update “PARTS”. When I run a test it does find a record to update but when I turn the automation on nothing happens. Any idea where I’m going wrong?

Hi,I'm not sure if this is the right place for this, but here goes. I have a table containing the following 'data'Project, Person, Start, FinishI want to plot on a Vega-Lite Heatmap style Histogram the 'heat' of these people over time. So the more 'Projects' then the higher the 'heat'. I could see that Joe is cold in Jan, but hot in July.This is the style of heat map: https://vega.github.io/vega-lite/examples/rect_binned_heatmap.htmlI guess I need to transform the 'hits' per say, month. But I have no idea how to do that!Thanks in advance.