Solved

I have a column named Day name which is a single select field containing names of day - Monday, Tuesday, etc. How can I create another column which gives the weekday number of this? I know I need to use Weekday() function, but how can I set it up such that it converts the string to work with Weekday() function? Thanks.

Hi fellow community members, In the Tool I am building to follow-up auctions, i created 2 tables: Table 1: “list of lots in auction” Table 2: “Price obs table” in which i made a link with Table 1 My target is, in table 1, to retrieve info from fields “Max Bid Price”, “Max Bid Calculation” and “No bid” fields from table 2 linked with the concerned record. Lookup field trial has failed. Any suggestions guys? Thanks for your help :winking_face:

Is it possible to do this? I’d like have an Airtable form with an attachment field, requiring someone to submit a CSV file (with info already filled out). The contents are then imported into an existing table with the contents mapped out accordingly? I’d have them fill out the contents with a form, but sometimes entries could be as much as 20+ … I checked MiniExtensions but didn’t find anything that would work for this use case. Help is appreciated.

Hi, I’m looking to solve something that is probably very basic. I have a master table that I’d like to bring in add’l data (size) into from Table 2 using the first column as the key. In this example, here is size data from table 2 that will be going over to the Master Table. In the Master Table, I’d like multi select fields with the data from Table 2. Can anyone please help me figure this out? Thanks, Michael

Hey everyone, quick question: I use a table to organize my various types of tasks and I have the records groups by the single select the shows what task type they belong to. It gets annoying getting to the bottom of the list of tasks for a specific task type and the group going away and having to re-add a record and update the single select to open that group again instead of hitting the plus at the bottom of the group to add a new record to the group. Is there any sort of like automation that can detect that a group is out of records and to add in a new one to just keep the group open? If not is there any sort of solution that you guys happen to know for this besides the kanban view? Thank you for any help!

Hi Anyone have any clever tips for removing special characters from text to make them filename firendly? For example < > { } ) ( etc. I could do it with a massive nested substitute formula but that seems clunky so hoping there is a cleverer way of doing it.

My datafile has a field with multiple tags that are joined like this: TagoneTagtwoTagthree Is there a formula possible, with help of regex, to put a comma between all lowercaseUppercase instances to seperate them?

For a table with organizations I have a partner field that links back to the primary column itself. Suppose an organization has 10 partners and I put them in the Partner field, then all those organizations will get that one organization in their linked partner field. But I would like for them to get all the organizations in their partner field, ideally minus themselves. Thoughts on how to do that?

I would like to create a scoring system for climbing competitions using airbase. I’m having a lot of issues with this in general. And I’m sure that I’m not doing it efficiently. Essentially, I want to create a scoring system that can be inputted by multiple judges using one source of competitior names. But the judges won’t be able to put all of the scores of one competitor in at once. One judge will put one score in. And the next judge will put another score in. So I need the ability to update their records. Let’s say there will be 4 climbs. I would like one judge at each of the 4 climbs. The judge will choose the climbers name from a dropdown box and enter the scores (ie, top, zone, attempts to top, attempts to zone) on an airtable form. The judge on the next climb will also have the same form but will score for the next climb. 1.I created 1 table (named Summary) with all of the climbers and columns for the scores of each of the climbs. 2.I created another table (named Update

" Hello Airtable" need to remove initial white-space from the text in the script.

Not sure if this was covered before. I’m trying to use the datetime_diff function in a formula as a trigger to send out an email 5 minutes before the meeting starts. The problem is that this function is very sluggish to update. In other words it might be 10 or 15 minutes past the moment it should trigger before it refreshes and shows the correct difference in time. But by the time it updates it’s too late to send the email out. Is this a bug? Or is there a workaround? Thanks!

I have managed to create a get request (I’m 90% no code) and then info is coming back but how to then write it to a field?. let table = base.getTable("TARIC Code") let url = "https://www.trade-tariff.service.gov.uk/api/v2/commodities/"; let config = input.config(); let response = await fetch(url + config.commodityCode ); console.log(await response.json()) I want to take the result directly into a field to then sift through it for what I need.

I want to list each linked entry in the “facts copy” column as a separate bullet point in a bulleted list in another column. Here is the table: Here is the formula I tried to use unsuccessfully: REGEX_REPLACE(CONCATENATE({Facts copy}), “, “, “<br>⦁“) I am not a programmer so apologies for my lack of knowledge.

I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number. What I’m trying to accomplish: Average Weight = 10000, Base Rate = 15, Surchage Calc = 20% 10000/2000 X 15 + 20% = 90 I’m getting 75.20 Thanks

Hello, I would like to set up a calculation to allow me to multiply a number according to conditions. IF(), but I don’t know how to go about it. Here is the request: My column: ( hide) Inventaire Composant sortant (Unique) corresponds to a set of products: ex: 1 table. "I could have called this ( hide) Inventaire Produit fini sortant (Unique) → This is what I take out of my stock but as a product as a whole (single). The question is for my column: Inventaire composant sortant ( Calcul pied), I would like according to conditions to be able to say if table with 2 feet, multiplies (( hide) Inventaire Composant sortant (Unique)) x 2 (# (hide)Pieds), if table with 3 feet, multiplies (( hide) Inventaire Composant sortant (Unique)) x 3 (# (hide)Pieds), if 4-foot table, multiplies (( hide) Inventaire Composant sortant (Unique)) x 4 (# (hide)Pieds), idem for if 1 feet and if Blank(), leave the field empty This would then allow me to subtract Inventaire composant sortant ( Calcul pied) from ( hi

Hello, Can someone help me to write a code to extract all the URLs associated with my attachment in a particular record? As you can see here, i have 3 photos where i need to generate “https://dl.airtablexxx1,https://dl.airtablexxx2,https://dl.airtablexxx3” in a field named “joined” Thank you for helping me

Hi folks, Formulas aren’t my strong suit, but I’m hoping there’s a way I can do this. Essentially, I’m helping my school manage teacher assignments, so I’m building a simple database to help me organize and visualize this data. I have two tables: 1 for Courses and 1 for Teachers. I have them linked together such that if in the Courses Table I type in a teacher’s name, then that course will show up on the Teacher’s tab (and vice versa). In the Course tab each course has a numerical value assigned to it based on the number of times per week they meet. What I would like is a column that tabulates the total number of periods assigned to a teacher that is calculated based on the courses assigned to that teacher. Does anyone have any formulas that can do it? I was hoping a lookup field would be a sneaky shortcut, but no luck. See my attached screenshots (I’ve cut off the teacher names field for privacy’s sake):

I’m using IF Statement with return numbers for two conditions: If it’s a car, one value, if it’s a motorcycle, another value. Everything is ok about that, however, when trying to multiply the presented result, it shows #ERROR!, how to solve it?

We use Airtable for Work in Progress at our golf cart repair shop. We have numbered cones that we physically put on customer carts in for repair. My goal is to limit the number of units that come in for service to 20 units. I want to create a field on the service table that corresponds to the numbered cones. So I would match a service ID to a cone number. Ideally, I would like to use a single select and once I assign “1”, I would like that option to be unavailable for the other records on that table. Right now single select will allow me to keep selecting “1” for all of the records on that table. I also tried setting up the cones a separate table and using a linked field. That didn’t work either. Open to any suggestions! Thank you in advance!

I am creating an ordering system to help distribute items between multiple stores. I would like to have the option to attach quantities to individual items in the same order. Here is my order form as it stands. You can add multiple items to the record no problem but the way to attach the quantities to the items is not sustainable. Ideally, I want to be able to attach those quantities to the items themselves. Is this possible? Thanks for any and all help.

Hi guys We have several columns including ‘multiple select’ options within and wish to combine all these columns into one. Is there a way to do this across the entire table, or do we need to manually duplicate the options and then manually go through each record to combine everything? Many thanks in advance Harvey

I have three columns in my table. Lat/Long Combined - Example: 18.194608875237545, -63.08524490907154 Latitude - Example: 18.194608875237545 Longitude - Example: -63.08524490907154 The formula I’m using in the {Latitude} column is: IF( FIND(",", {Lat/Long Combined}), LEFT({Lat/Long Combined}, FIND(",", {Lat/Long Combined})-1 ), {Lat/Long Combined} ) The formula I’m using in the {Longitude} column is: LEFT( RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ), FIND( ",", RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ) & "," )-1 ) When there isn’t a value in the {Lat/Long Combined} column, the {Latitude} fields are blank, but the {Longitude} column is populating #ERROR! Any help would be much appreciated. Thank you

Hello everybody! I was wondering how do I see what a form password is set to. Is there a way to view that?

Hi team! I’ve been using this wonderful formula to set a due date for something, but the issue I have is that it defaults to 12:00AM. How would I append this formula to set it to, say, 4AM? Using a formula to return the date of 1st day of last month Formulas Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As soon as we hit June, that date should change to May 1st 2020. Any idea how I could do this? Thanks all… Thanks!

Hi All, I have multiple schools participating in multiple programs. Each program has its own form. So, we would send school A a form for program A and a different form for program B. In an attempt to make the forms as simple as possible, we are not asking the schools to select the program, rather I want to use automations to update the program name (linked) depending on which form is being submitted. For example, School A has been invited to participating in Program X. They complete the form, then the automation enters “Program X” in the linked program field. I just copied the text from the primary field of the Programs table. I set up an initial automation with the first program we have, and it worked perfectly. Then, I set up a new form for the next program, and I duplicated the automation, retested the trigger using the new form, and updated the program name for the new program. (Again, copied from the primary field.) In this case, the automation fails, indicating and when i review