Solved

Hello,    Hope someone will be able to help me, I am trying to create a formula field for my employee to auto calculate his work hours for a day. He fills out the form and I am tired to calculate his hours per day.So, I've got one field "IN" with multiple select options "8:00am" "8:30am" and "9:00am" and another field "OUT" with multiple select hours "3:00pm", "3:30pm" and "4:00pm" (I have more options, but it does not matter here), so ones IN and OUT are filled, I want to have a formula field calculating how many hours my employee worked today. I thing it should be done as logical formula, like if IN is *8:00am" and OUT is "3:00pm" then HOURS result is 7, something like this, but I can not make it right, anybody could help?

Hello Everyone , I am new to airtable scripting.I have a Pretty Basic Question - I am trying to capture records of 1 row using input variables.here is my code below.let inputConfig = input.config();/*my table name*/let Sourcetable = base.getTable("Facebook")/*Airtable Id of row*/let aid = inputConfig.AirtableID/*This is a linked record*/let cname = inputConfig.client console.log(cname)Cname is a linked record from another table.When i run cosole.log(cname) it gives me a empty array.My Question is How do I get the airtable ID of linked records via input config? Thanks in advance.   

Hi all,I'm a complete beginner and have never worked with API's before. So I'm really sorry, but I'm hoping someone could help me, as I've been googling for days and don't know what is what anymore!I am trying to link my shipping solution (Shipstation) to my Airtable database.So far, I've managed to successfully set up a webhook, so when an order is shipped, Shipstation sends a webhook to Airtable. However the webhook is just a "resource_url", not actual useful data (like an order number). I've gone to the "resource_url" (which needs a username and password) and it has all the data I need.So I guess I need to "run a script" and write an API to go and fetch the data from the "resource_url", so I can then use the order number to "update record".I've added the "resource_url" from the webhook as a variable / input config.So what I need the script to do is;Go to "resource_url" (which is the input config called SHIPSTATION)Login with Username and passwordOutput the dataCan anyone h

I am working on Zoho 's cliq communication platform and I am developing an Airtable extension for that platform. When I tried to create connection with Airtable (actually the platform has a internal frame work kind of thing ) through which oauth connections can be made by providing the client id, secret and other credentials and the rest of the things are taken care of by the backend. And when I tried to create the connection. The authentication tab tried to load and closes automatically without any sign. I have provided below the url sent from the Zoho cliq platform to establish connection. I have intentionally provided the redirect uri wrong to catch the req formatRequest:http://airtable.com/oauth2/v1/authorize?client_id=<clientId>&redirect_uri=https%3A%2F%2Fdeluge.zoho.com%2Fdelugeauth%2Fcallback&response_type=code&scope=data.records%3Aread+data.records%3Awrite&state=fbfa4c39db9a4a9cd58b66b4126468dcda979b338eb5cb3ebefd4d7fe88403ad47b0683e85a

Hi there, I know how to get things off the end of a string but not the start!!! I have recipes that look like this  Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)Greek salad with crispy chickpeas and potatoesMiso eggplant with broccolini and edamameTM Pan-fried salmon with creamy pumpkin milletTM Moroccan spiced beef and lentils with carrot couscous I want to create a field that has all the recipe names - but without the TM at the start.  TIA

Hi,Am using a formula I've used in bases before, but it's behaving strangely.  It's subtracting a day off of the returned value.  I have two fields with dates.  Only one of the two will ever have a date in it.  I want the formula to grab the date from whichever field has a date already populated in it (from another table)Here is the formula.  IF({Shoot Date Rollup (From Scenes)}="", {Shoot Date Rollup (from Set List)}, {Shoot Date Rollup (From Scenes)})Example:Shoot Date Rollup (From Scenes) = 7/25/23The formula Returns 7/24/23Same if it's the other field that has data Shoot Date Rollup (from Set List) = 8/10/23Formula field returns 8/9/23Thanks for any help.

Hey Everyone, Quick explanation of what I'm trying to do is: I created a couple fields to look at the number of items in a particular category, count those items, add 1 to the count, merge a few string fields together to create a unique identifier "YP Internal Code" (see 'write to cell' image) when a record is created via form.I'm passing an input variable to the script shown (see 'push to table' image), but can't figure out what the next step is to push the changes in the script to the table itself after the assignment of the new internal code to the old one. Thanks for the help, Peter

I see I can input the record ID of the modified record and any specific field of that record into my script, but what if I don’t know which field will be changed and I want to get that record’s field’s value? My early testing found script automation to be kinda slow, so I want to try and be as optimized as I can be from the start. My goal is to monitor >200 fields of a particular record type, then if any are changed, add those records together, create a running total per time period with that summed array, then update a separate record for running totals with that array. I found that addition and subtraction for this many fields at once took almost 30 seconds to update, so I want to only update the fields necessary. EDIT: Updated to give more details about my intentions

I am trying to follow this video tutorial: https://www.youtube.com/watch?v=BkAY7OHEgdcThe formula: 'https://airtable.com/shr12G6XKocbeGi0H'&'?prefill_Doll%20ID='&RECORD_ID()&'&prefill_Doll%20Name='&ENCODE_URL_COMPONENT({Doll Sculpt})&'hide_Doll%20ID=true' However, the part to hide the record ID is not working. This is what happened to the form:As you can see, the "Doll Name" area has the formula to hide the record ID in it. 🤔 🤔 I tried doing it exactly like the video and only having "(Doll Sculpt)", but it said there was an error with the formula and I was forced to use "({Doll Sculpt})". Could this be the issue?I haven't even tested the functionality (I haven't set up the automation) of this yet because I have hit the snag listed above. 😥Thanks for reading!

Hi there smart people!I'm looking to show the percentage of improvement since the implementation of our new Figma redlining process from our team survey. Right now, 5/8 people say the process has either improved or greatly improved! Is it possible to show this in Airtable's Interface? Either as 5/8 or 63%? Participants will continue to add to this survey in the coming weeks. So, I need a create a formula that will update the Interface accordingly. Please, let me know if anyone has an answer!

Hi there,I would like to calculate the extra hours I've worked each day by implementing a formula field. I've currently listed records with "Date", "Start" (date, time, timezone), "End" (date, time, timezone).How do I make sure the formula only lists the extra working hours? Can I implement a formula where weekend days are calculated differently then weekdays?Thanks for your help! 

Hello! I am importing thousands of records from an excel sheet and there is a long text field that contains data that I would like to organize in a single select field. For example, a record may contain "L4_S2" in the long text and I would like to create a single select for "L4_S2" and update every record that has that condition in the long text. I'm trying to do it with automation, but I can only get it to update one specific record and not each record that has the same condition.

I noticed that running a script as part of an automation flow has some limitations in place, which are outlined here. I want to know if the same limitations apply when I am using the Scripting extension.Thanks!

I'm building a table with many due date columns and they all need to be automatically calculated based off of one "publication date." For example one due date might be 21 days before publication. BUT, I always want the due date to fall on a work day. How do I make that happen? And a second, related question: I'd like to have the same sort of setup for one of the tasks but instead of an auto-populated single date, I'd like the formula to return an auto populated 3 week time range. (The weekdays are not important for that one.) 

Is there any way to access the extension APIs outside of an airtable extension? The view metadata provided by the extensions resources Airtable Blocks SDK includes visible fields and other view metadata that the public view metadata API does not have Airtable Web API

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'month'), 'DD/MM/YYYY'),'Quarterly', DATETIME_FORMAT(DATEADD({Task Due}, 3, 'month'), 'DD/MM/YYYY')) However,  to set up views and automations I need to be able to use the conditional properties of a date value, and I can not seem to filter on any of the normal date values. Is there a way to filter Next Due Date to be 'within' and 'the past week'? Thank you! 

hi friends! we are an organization that provides online trainings. i have a base with registrations in one table and a unique attendance list in another table. the other table has a list of all the trainings.so the registrations table is all the registrations we received for each training, so that we can see things like: 100 people registered for training X, 80 were approved to attend (either because they were members or they paid), and 70 actually attended. because people attend multiple trainings, this list contains different registrations for the same person.the attendance table is a list of each person who ever attended a training with a related record field that contains all the trainings they attended, linked from the list. that way we can see things like: 300 people attended our trainings last year, person X attended 4 trainings, Y organization sent 4 people to trainings last year.i have an automation set up that after a training happens & we record the attendance, it takes

Hello! Apologies for the potentially basic question, but I was having trouble sorting through the existing documentation and I couldn't find a simple explanation. I'm trying to pass the output variable newCode into a new script, however I'm not sure how to define the variable before I pass it to the oldCode variable (see screenshot). Any suggestions would be appreciated!Thanks,Peter

Hi everyone, I just would like to know if it is possible that I can hide fields with empty value in gallery view. Airtable Gallery - Airtable Explore the "Gallery" view on Airtable. For example, I would like to hide “Attachments” in row “Test1”, “Notes” in row “Test2”, and “status” in row “Test3”. Is it possible? Thank you!

Hey there!I have two tables. One contains projects, and the other contains tasks. I want to update the status of a project (from pre-production to production) when a certain task is checked off. How would I go about doing this? 

HiI'm reading my Airtable data using the API which is working fine, I'm now trying to write back to Airtable but I am having issues.I can write to Airtable successfully if the field is a string or a number but I can't when it's a currency. Any ideas how I do this?This is how I am currently doing it: Request.headers['Authorization'] = 'Bearer API here'const obj = Noodl.Object.get(Inputs.ObjectId)  Request.content = {    records: [      {        fields: {          "Overhead": obj["Overhead"],          "Amount": obj["Amount"]        }      }  ]} Amount is currently a number although it doesn't matter if it's a string or a number as they both work but currency does not.

Hello, I am pretty new to airtable and have a slight issue with fetching info from a record within a record. With an automation i create a number of records within a record to be able to choose multiple products for the same order number. (Not a lot of context here, but it would be a way to long post if I provide all the context)All I want to do is separate the info, in the following case, for the two elements.Looks kind of like this:Amount & product (linked records)Weight (lookup)Weight, first element(help here)Weight, second element(help here)120 Coarse,100 Fine4.5, 3.04.53.0 Is there any way to fetch certain info depending on the position of the lookup element?  Thank you! 

Hi All,I need some help with extracting specific text. I've looked through the community and tried to apply the examples offered...but I am not getting it quite right.I need to extract the suburb, state and post code from a (text) address field. Some suburbs are made up of two names. Below is an example of how the addresses are formatted/written.  Whilst the addresses are made up, these are real suburbs in Australia 😀.Address Examples:305 Smith St, COCKBURN SA 544012 Lincoln Cres, WOOLLOOMOOLOO NSW 201112/65 Johnston Lane, DOG SWAMP WA 6060Wanted Outcome:COCKBURN SA 5440WOOLLOOMOOLOO NSW 2011DOG SWAMP WA 6060I appreciate the help. I don't expect an explanation but I am trying to learn so any info alongside the solution will be helpful.Thank You!!

Hi, I'm looking to just get some sort of identifier of the button pressed.  I would like to have several buttons run a single script and just identify which button is pressed in the script.I was following this code from the tutorial for getting the button working, but not sure what to access to get the label of the button pressed.  Just the record.      // Change these to match your base. let table = base.getTable('Tasks'); // When run from a button field, the script skips the prompt // and automatically uses the button's record. let record = await input.recordAsync('Choose a record', table);     

I am using the field, "Total Days Open" to count the days between the date something is submitted and the date that work is completed. The formula is: IF(AND({Work Completed} = BLANK(), {Submission Date} = BLANK()), "",IF({Work Completed} = BLANK(), DATETIME_DIFF(TODAY(), {Submission Date}, "d"), DATETIME_DIFF({Work Completed}, {Submission Date}, "d")))On a separate tab, I want to calculate the average total of days based on the Health Plan link to the records I want to average. I have been trying to use the Rollup field but it is returning a value of "NaN"