Ask the Community

Hello , thanks for taking time for giving a hand  on this Table 1 ( Currency ) for Monthly Foreign Currency Ex RatesUSD Nov 2023SAR Nov 2023EGY Nov 2023 Table 2 ( Budget Line ) which contain the monthly budget line in different Monther Table 2 will have the same format as table 1 USD Nov 2023SAR Nov 2023EGY Nov 2023 in some of its records My question can i find a way that match the budget line that occure in Nov 2023 With the monthly matched exchange rate in currency record ?   

Hi, I have multiple automations pulling data from formula fields, that have been formatted to include the euro sign. This works fine in the data, however when I pull the values into automations, the euro sign and formatting that I put in the formula field isn't applied. The base I am using is under a free account.  Could you let me know of any solutions?  Thanks 

I'm working on a no-code application with Bravo Studio, using Airtable as a backend. I'm trying to implement a 'multilike' system where each user can like multiple items in an identifiable way. I've considered a table of likes with a user-element relationship, but I'd like specific suggestions on how to implement it in Airtable and how to integrate it effectively with Bravo Studio. Any ideas or advice would be greatly appreciated.Thank you!

Tables1. 2023 schedule2. Summary dashboard1st pointI have a one table named 2023 schedule where i have two columns season and week , in these columns there are repitation  of values , i have to find the unique values with combination of these two columns and populate in record picker named week2nd point On the selection of week i have to filter the games which are in the same table "2023 schedule" on basis of week from the week recordpicker and populate in the another record picker names games.3rd point on selection of game from game record picker , i have to show the data in tiles view in interfaces , the data is in the another summary tablehow to link these tables and show data in consolidate form  is this possible in interface , i am not able to achieve as far as now , please respond as soon as possible 

Hello, I’m actually using proxies to GET/POST information into Airtable from a mobile app. Proxies use the “&field” filter, so the GET response only contains a limited number of fields in the response. This is the approach I have seen suggested around the forum to return a limited number of fields. It comes to my surprise, that if “?id=record_id” is added to a proxied endpoint, no matter what “field” filters are included in the proxy internals they are bypassed and all fields from the record are returned. With all the fields returned, there are dozens of linked records from other tables. It comes again, to my surprise, that, if any of the linked record id’s from other tables are appended to the proxied url ?id=linked_record_id, then the linked record is fully returned (with all its fields). This creates a huge security issue on my app if exploited and I have seen no documentation, comments or security practices about it anywhere or ways to solve this situation. Any clue? Is anyone

Hi all, I have a two-table base. The first table/screenshot below is for survey responses; each record is an individual survey response. The second table/screenshot is where the responses roll up for each survey. Is there a way within the rollup filed formula to achieve my highlighted desired result? I'm trying to avoid adding multiple rollup fields for each response type and then concatenating all of the information in a new column.    

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I don't think I can change it from there. For example, in the column it will have-2023-09-20T00:00:00.000Z Opinion on Policy2022-10-03T00:00:00.000Z Environmental NeedsI want to removed the date and time and have the column say-Opinion on PolicyEnvironmental NeedsThanks for the help! 

Hello everyone, I'm sorry if this is not the proper place to post this, actually I dont know who or where I could get help from. And sorry for my English.I'm very new to this world so I will try to explain my problem as clear as I can.I even set up a test table so you can see it easily. First of all, I would like my clients to fill up a form like this: Then, I would like this data to be sent to my Airtable and create a new record in the column "Chosen Colection" with the chosen colection they selected in the form. The column 'collection' is linked to a price from another board, which I'll show you in the following images:Then I made a conection in Make.com to send this data, like this:Then it shows me an error like this:I'm stuck on this step and I dont know how to set it up. Please help 😞

I am trying to create a URL to search Google Shopping for a specific combination of (Brand, & Product Title), however i am noticing that if either the Brand or Title has more than one word, the URL does not form correctly:Ideally I would use the Google Shopping ID for the product search, but that is a separate URL/search entirely. I also want to add UPC to this, but that shouldn't be a problem as a UPC is not two words (however sometimes multiple UPCs may be searched, so the same issue might arise).If anyone is able to advise, I would greatly appreciate any help!

I’m keeping track of some social media captions in my Airtable base but every time I copy and paste into Airtable I get a prompt to update saved password. It’s quite annoying to have to minimize the window each time I paste something. Is there a way to disable that pop up?

I am trying to have a formula which give me the possibility to have on the same line two fields separated by a coma. This is tricky, because, i need also to have in the formula that if the field is empty if it not showing the empty space or make a break line.Right now I have this, IF({MARQUES}, " " & {MARQUES} & "\n") &IF({DESIGNER}, " , " & {DESIGNER} & "\n") &IF({DATATION}, "  " & {DATATION} & "\n") &IF({COLLECTION}, " " & {COLLECTION} & "\n") &IF({FABRICATION}, " " & {FABRICATION} & "\n") &IF({PRODUIT}, " " & {PRODUIT} & "\n") &IF({MODELE}, " - " & {MODELE} & "\n") &IF({MATIERES}, " " & {MATIERES} & "\n") &IF({COULEURS}, " " & {COULEURS} & "\n") &IF({DETAIL}, " " & {DETAIL}) &IF({GRIFFES}, " , " & {GRIFFES} & "\n") &IF({PROVENANCE}, " " & {PROVENANCE} & "\n") &IF({TAILLES}, " " & {TAILLES} & "\n") &IF({CONDITION REPORT}, "

I ran into an issue setting up an automation for some colleagues of mine. We all work in the same workspace, but depending on the team there are different tables within the workspace to manage their work. To keep things simple, lets say Team A works in Table A, and Team B works in Table B.Some of the work Team A does in Table A is for Team B. Team B asked for a way to see just that work in their production calendar on Table B. I created an automation pulling just the pertinent info from Table A to Table B so they can keep track of it. (I am oversimplifying this for the sake of my issue.)The automation has so far worked perfectly, with one issue. Team A uses a Date field for their Due dates without a time field, Team B uses a Date field for their due dates with a time field. For whatever reason, when the automation runs, it will change Team A's due date (ex. 1/2/24) to the day before at 7 or 8pm (ex. 1/1/24 7:00pm). Both date fields use the same date format of "US".What can I do to forc

https://airtable.com/apprdPguzaBCfjD56/shroyWamJGrG0yeMiIn the sample base above, I have two linked Tables. One is a list of projects, the other is information for a quarterly report. Currently, I am linking the tables to each other manually when updating project start and end dates. For example, if I add a new project scheduled to start today and end 3/1/2024, I'd add a new record with a start date of 11/30/22, the end date of 3/1/24, and then link it to the "2023 Q4" and "2024 Q1" records from the second Table. Projects don't often (if ever) end when planned, so I come back and update the end dates often which means I also have to go back to check the linked Quarter records to make sure they're still accurate. This seems like something that should be easily automatable.I don't necessarily even NEED the Quarter Table. There is no other information about each quarter that I collect. Ultimately, I just need to be able to graph the data points out to count how many projects were in proce

Hi-  I'm a pretty new Airtable user, and have been trying to find solutions via the community posts, but haven't seen anything exactly addressing what I'm attempting to do.I am trying to populate a field with a number of hours to be worked, only if the month for that work falls within a date range.  In Excel, I was able to make this formula work:  =IF(Column's Month<=Completion Date,Average Monthly Software Hours,0)-IF(Start Date>=Column's Month,Average Monthly Software Hours,0)I tried to replicate the formula in Airtable that I successfully did in Excel, but it isn't returning the same values.I've attached a screenshot of the base as well as the formula I tried.  It feels like there's something wrong with how I'm handling the Column's Month formatting, but I can't figure out what...Many thanks in advance!-Robin

Hello. I have a base that has the following tables in it: Projects, Tasks, Communications Form, Web Form, Creative Request Form and Photo/Video Request Form. Under the Tasks table, we have a view that shows what everyone is working on. Each Table that has a Form also has a grid to collect responses and assign a user to the task. Is there a way to pull the tasks from the form tables to the "What are people working on" view in the task table? If not, is there a good workaround that might help people not have to check multiple tables?Thanks!

Hi, is there a way I can send a webhook to an automation in another base via a button which runs a script?So like:press button on record on base A > runs script > script sends webhook to base B > webhook triggers automation to create recordI can achieve what i want via a checkbox and syncing but i dont want them to have to uncheck and check the box to do it againAny ideas?

I need an automation to remove a linked record from a linked record field, without removing all linked records from that field.For instance, if a student is in enrolled in the courses 'knitting for war, animal husbandry and marriage, ice cream + pies', but drops 'knitting for war', I'd like the automation to leave the field as 'animal husbandry and marriage, ice cream + pies'. I gather from some forum browsing (specifically this thread) that this cannot be done without scripting. The good news is someone posted a script on that thread. Yay!The bad news is that the script looks like hieroglyphs to me. So, my questions:1) Is it even safe to implement a script for someone whose understanding of scripts boils down to 'it's magic, I guess?' Like, do I need to worry about having to debug it if I change some info in my base or similar?2) I assume I'll need to make some basic modifications to the linked script, like updating table names and such. Could somebody point to wha

This post is a follow up to earlier (closed) post here. I’m reopening it because the proposed solution doesn’t work. “Thumbnail Link” is not a solution to upload images from Google Drive to AirTable , because Thumbnail Link images are low resolution. Uploading attachment from Google drive with Integromat Base design OK so it works with Thumbnail Link which seems to be different from Web Content Link. So the case is over. If you generate barcodes and then get low resolution barcodes uploaded to Airtable that could become an issue when later printing the barcodes. Cheap scanners are bad at picking up EAN and UPC barcodes in general so you want to have better resolution image used for printing the barcodes. I am running it with Remove.BG and although Remove.BG produces high resolution image that is uploaded to Google Drive folder, the last step in the flow (Airtable update) is not able to grab the full resolution image from Google drive, instead, it takes

Hi everyone,I'm new to the airtable world and I would like to understand if there is a way to synchronize the field of a base with the field of a different base.Any advice is welcome, thanks!

hello I use airtable as a database for an external application creation solution. I would like to create a Like option but I cannot find the solution because when a user likes it is all the other utilities that see their like so I would like to know if there is a solution via airtable so that the user identifier and like is only visible and operational for the user account in question

Hi allI'm trying to make a URL to link directly to show just images in an attachment field.I've created a shared view, and am happy making a formula which replaces the record ID to the correct record but I can't get the attachment ID programatically.  If I omit it from the URL (ie airtable.com/appXXX/shrXXX/tblXXX/viwXX/recXXX/fldXX/ then it directs the user to the full record page - I just want them to see the attachments so need the "att" IDAny ideas?Hope that makes sense!Andrew

I've been working on a project where I'm utilizing Airtable for data management and an external automation website for process automation. Everything was running smoothly until I encountered a peculiar issue. I'm struggling to seamlessly integrate the automation website with Airtable.The challenge lies in ensuring that specific triggers in the automation website accurately update corresponding records in my Airtable base. Has anyone else faced a similar situation or found a workaround for such a nuanced integration? Your insights would be extermely valuable in helping me to sort out this process.

Hey community, Aundre here. I hope you're all doing well!I found this script on YouTube that works once you're on any table view where applicable. I need to automate it to work without being on a specific view. When I run it from automations, it does not work, I get the error below.The automation I am trying to create is to run whenever a record enters a view. It should run the script which compresses images in the IMAGE column via TinyPNG, and then output them in IMAGE COMPRESSION. However, I find that I have to be on the view itself, click 'run script' for it to work. The automation however is not running from a view standpoint, hence why I believe it's giving an error.After the image has been compressed, I'd like the IMAGE column to clear (delete) the original image, leaving only the compressed one. I've been able to do a simple automation for this by making the action an Update record and leaving the IMAGE field blank. However, I need it to be in one where it will clear the origina

Hi everyone, I am trying to automate an SMS using a basic Twilio script that I found here: Twilio Script This script works when I run it within the script app, even with my changes made to disable to input text. When I run the same code in the automation run script action I get the error code ‘ReferenceError: btoa is not defined’. My code is below: * Twilio send SMS script * * Send a single SMS to a provided telephone number using the Twilio service * * The Airtable "Send SMS" Block (available to customers with a "Pro" account) * is capable of sending many messages in batches based on the contents of the * Airtable Base in which it is installed. * * **Notes on adapting this script.** * * The script prompts for input every time it is run. For some users, one or * more of these values may be the same with every execution. To streamline * their workflow, these users may modify this script by defining the constant * values in the first few lines. The values should be expressed

Hi there - I am trying to set-up scripting to work with Whatsapp & Twilio. Which is the best and easiest language of those below to interface with airtable scripting?