Solved

Hello - I am trying to utilize a formula to view a date that is formatted like this Tue Aug 23, 2022 3pm - 3:30pm as 08/23/2022. (I do not need the time range in the final view) I was trying to do a formula like this: DATETIME_FORMAT(DATETIME_PARSE({Formula},“DDD MMM DD, YYYY”), “MMM-DD-YYYY”) but I am just getting an error in return Am I wildly off? Any help would be greatly appreciated! I am super new to formulas.

I am creating a table where our team enters LinkedIn social media analytics. I have only dabbled with formulas, so I went to my friend for help, and he gave me a good formula, but I think it needs tweaking. Here is my dilemma: First, I want the “Click-Through Rate” to display “Not Available” for future posts. For current posts (as well as past posts); I would like to display a number, even if it’s zero. If you notice in my screenshot, there were certain past posts with data entered, but it doesn’t display anything in the Click-Through Rate cells. :woman_shrugging:t5: Second, I would like to display the Click-Through Rate as a decimal that moves the decimal point. For example, instead of displaying 0.0198, I would like for it to display, 1.98% Here is the formula: IF({clicks} > 0, ROUND({Clicks}/{Impressions},2), if({Impressions} >0, ROUND({Clicks}/{Impressions},2), “Not Available”)) I appreciate any and all help.

I have a table with employees I have a table with courses I have a table with course attendance I have a table with training days I have a table with skills Courses have linked Skills Course Attendance has linked Courses & linked Employees (who attended) I can use Lookup to show Skills next to Course Attendance Training Days have linked Skills & linked Employees (who attended, lets call this LE1) I can list Linked Skills next to Employee using a Lookup for Training and a Lookup for Course Attendance. I’ve got this working up to this point using “Link to another record” type fields. Training Days and Courses expire after a period of time (no longer competent). I want the Employee to show only linked Skills from Courses and Training that haven’t expired. I can do this using “Link to another record” type fields with “Limit record selection to a view” and limiting the view to records that haven’t expired. PROBLEM: using “Limit record selection to a view” on “Link to another record”

Banging my head on the table here - I cannot seem to figure how to link tables that I have imported from another database, having converted them to Excel. I have something basically like this: Table1 Table1_Key | Table1_Field1 | Table1_Field2... Table_2 Table2_Key | Table1_Key | Table2_Field1 | Table2_Field2... Data imports fine, but when I create the link, it just doesn’t work. I’m sure I’m overthinking something here, I just cannot seem to figure what it is. Matt

I’d like to insert an image in my base guide. I think I’m using the proper Markdown syntax, but it’s simply not working. I get the impression from this page that this should be possible. It says You can also use Markdown within the base guide to add headers, links, emojis and images. It works here in the Community. Here’s the exact Markdown I’m using, followed by the result here. Can I get the same result in the Base Guide? 

Hi everyone, So I am working on an automation that can help me do progress tracking, and I want the automation to help me find records that are based on the day of the week, and change the progress by +1. The current solution I have is: Scheduled Trigger Once a week Mondays Find Records with Mondays. Conditional Actions: if Progress is exactly 1 Update to 2 if Progress is exactly 2 Update to 3 And I would multiply this by 7 for the 7 days of the week But I realize, it does not update the entire batch but only one entry? Any potential solutions?

I have a table where I need to mark when flights take off between 22:00 - 07:00. I would like an If statement where it marks the record with an X when this is true. I have date fields for the departure time but I just cant quite find how to have a general standing marker based on times rather that a specific time AND date.

Maybe I’m just not looking in the right places but I cannot figure this out. I have a rollup field which is outputting ARRAYUNIQUE(values) so I end up with “Product1, Product2, Product3” I now want to have three other formula fields which are: “Has Product 1” “Has Product 2” “Has Product 3” that will equal “True”, “False” if the the product is found in the rollup string. How can I go about this?

Hello! I hope this is a simple question for you all, I need to be able to update any field with a certain value. is there a way for me to make the field name that I want to update into a variable so I can change which field I want to edit? var varField = 'fieldnameOrID' base(TableHere).update(RecordHere, { varField: "done", }, function(err, record) { if (err) { console.error(err); return; } }); this is something like what I would want to do. any help?

Hi all! I work at an university and I’m trying to figure out how to change Airtable Forms’ font so it can align with our branding policies. Right now we can only use it internally because the font is out of compliance. Please help and cheers to Airtable! Best, Marisol

I need help figuring out an issue I’m having when filtering a view using a lookup field. I have a project tab and a task tab set up. For the tasks, I have task owners set up. The tasks work in a chronological order. The first task needs to be completed before task 2 can start, and so on. For the projects, I have a formula set up that automatically updates the project status when someone completes their task using a checkbox. I want to have a view for each person in the task tab – where they can see all tasks they have to do, but I want them to ONLY be able to see the tasks where they are up to complete the task (aka the task(s) before them are all completed and the status of the project aligns with their task). I have it set up where it currently filters for the task owner, the project status (through a lookup field from the project tab), and if the task has been marked complete through the checkbox. However, for some reason it is not filtering correctly and is showing all of the task

I have a table with 500 students. 400 of them I have the photo ID. For all of them, I have the email address to contact the parents. I have a form designed with mini extension allowing a parent to log in with the student ID and the last name, in order to upload the student’s photo ID. I would like to generate to all parents of a student with no photo a personalized email allowing them to upload the photo ID. What will be the way to do it?

I have a Learning Course table that tracks courses with either a single session or dual sessions via checkbox fields. I have links to fields in this table that identify whether an enrollee has completed the relevant sessions(s). From there I have a checkbox field that indicates whether, based on the attendance, whether an enroll has effectively completed the course. I tested a formula field that runs the checkbox field for the dual session completion, but I’m struggling to create a formula that accounts for the single session field. I initially thought it was an IF(OR(AND())) type of configuration but nothing seems to work. Here’s what I tried: Works: IF(AND({Session 000 Output}>0,{Session 001 Output}>0),{<TRIGGER> Completed Course}=1,{<TRIGGER> Completed Course}=0) Doesn’t Work: IF(AND({Single Session}=1,{Session 000 Output}>0),IF(AND({Dual Sessions}=1,{Session 000 Output}>0,{Session 001 Output}>0)),<{<TRIGGER> Completed Course}=1,<{<TRIGGER&

This seems simple but I am not sure how to accomplish this. I have my educators complete a form that requires them to enter their course start dates in ISO. This format is important for some concatenate fields and dropdown menus in other tables and forms, and thus I cannot change the format when the forms are completed. Currently, I am asking my instructors to enter the date twice: Once as ISO and once as friendly. In order to avoid entry mistakes and disgruntlement amongst the ranks, I would love to be able to do this with a formula. In short, I would my like instructors to enter the date as ISO and then in a second field the friendly date format populates magically. This: 2021-06-11 becomes June 6, 2021 in a second field. Thank you for your help.

Hi, I am trying to prefill a form using the following formula: CONCATENATE({Applications URL}, ‘?prefill_Which+role+are+you+applying+for?=’, {Name of opportunity}) The ‘Name of opportunity’ field contains more than one word, but the formula is only pulling the first word. Here is an example of one form’s URL: Airtable Apply to our roles today! - Airtable Fill out the "Apply to our roles today!" form quickly and securely on Airtable. When the ‘Name of Opportunity’ is actually ‘Logistics, Freight and Warehousing - DSV’. How do I ensure that the form populates with all the words? Thanks!

Hi Airtable Community, We are using the “enable rich text formatting” on a “long text” field, using bullet points to indicate points of attention or statuses. Is there any way to use this rich text and do the following: Filter out first / last 3 bullet points by using a formula? Filter out items under a bullet point matching a certain category, eg. text in bold - by using a formula? Screen shot attached where I’m looking if I can filter out basis eg. “Week 13” or filter on bold. Many thanks!

Hello all, I’m working through the parent-child relationships of a self-linked table. I need to build a hierarchy or path which traverses a multi-level hierarchy using a “child” relationship. Some other solutions in these forums are focused on a “parent” relationship column, such as the excellent solution by @Justin_Barrett here: https://community.airtable.com/t/parent-child-tree-hierarchy/44094 Using the above solution as an example, I would like to build the following hierarchy: I’m open to other feedback on how construct this, even if it isn’t a scripting solution. I’ve just used the above example as a starting point. I’m also aware of the parent vs child tradeoffs of self-linking tables. I’ve gone through multiple iterations of this project already, trying both approaches. Thanks for the help!

Hi, I would like to ask what is wrong with this script below. What I’m trying to achieve is search a particular word on a given string and make sure that the word is not misspelled by not having any additional letter or numbers at the beginning or end of the word (Special characters are allowed. Case sensitive search). What happens with this script is, it fails to search for the given word even if nothing is added before or after the word. I have tried my RegEx on online testing tools and it actually works fine. If you guys know any alternative for my scenario please do let me know! Thank you very much. let subcategoryName = currentSubcategoryRecord.name; let keyword = new RegExp(`[^a-zA-Z0-9]${subcategoryName}[^a-zA-Z0-9]`); isProductTypeExists = checkRecord.search(keyword); if (isProductTypeExists == 0) { //Product exists! } // -1 is returned for no match found.

Hello Can someone give me an advice? Sorry, but my english is not great to explain everything as I want. For a restaurant, I have recipes, with ingredients, and they came for vendors. What is best? 3 bases linked, or just 1 base with everyting? The 3 bases, that look logical to me, are: recipes, inventory, and vendors. recipes, with photo and calcs to estimate costs inventory, to track ingredients costs from different vendors, quantities in stock, and reorders vendors, where I can see their ingredients, with their contacts, and track the payments Ingredients is the only thing that must equal in all the 3 bases. But I never did any base, so maybe I’m thinking wrong. Thanks in advance

Hello, I made a script to query a API and update current rankings of records. I have a test table with 5 records and 1 is a empty record. See screenshot for my test table: code: //set the variables let api_key = '{apikey}'; let table = base.getTable('tesdata'); let query = await table.selectRecordsAsync({fields: table.fields}); for (let record of query.records) { let domain = record.getCellValueAsString('Website'); let zoekterm = record.getCellValue('Zoekterm'); let country = record.getCellValue('Land'); let gl=country; let hl=gl; if(gl=='co.uk'){ gl='uk'; hl='en'; } else if (gl=='com'){ gl = 'us'; hl = 'en'; } //build the api call variables var url = 'https://serpapi.com/search?q='+encodeURIComponent(zoekterm)+ '&gl='+gl+'&hl='+hl+'&output=rank:'+domain+'&google_domain=google.'+country+'&num=100' + '&api_key=' + api_key; console.log(url); var requestOptions = { method: 'GET', }; //build the api call variables //m

Hello, I have a problem with data manipulation when grouping records on a date range. Each record has a date and a time, (they are cash receipts linked to a cash register). Of course I have multiple records per day. I want to group these records by day and verify the data via another table (the cash register verification table). To group my records on a date range I have no problem (I used formulas of type DATETIME_FORMAT(Date, "DD/MM/YYYY ")). On the other hand I want to use the sum of each day and link this sum in another table of my database and I can’t do it with the rollup because it considers the records unique and not grouped. In short, on the one hand I have customers who buy, and on the other hand I want to do a data validation on the totals of several columns per day and this without having to link via a rollup each record of each customer. Thanks for your help.

Hello, My name is Teddy, I’ve been using Airtable for 3 months (I’m a beginner). I read community topics and it helps me regularly. But today I need help please. I want to use a trigger for a junction script. The script works when I run it manually (with the settings) but I cannot configure it directly in the tool. Can anyone help me?

Hi everyone, I have a fairly complex base tracking financials, burn rate, and runway. I have run into a snag trying to come up with a formula that will automatically update based on what month of the FY we are in (for burn rate). For example, I have a table specifically for burn rate. If I want to see our burn rate YTD, I have to manually update the formula with the current month (burn rate = (starting balance-ending balance/# of months)). Starting balance - ending balance is an easy part but currently I need to manually update the divisor (our FY is from Jan to Dec, so right now I am dividing it by 8.5). How can I get it to update automatically? Can anyone help?

Here’s my scenario: Every day I make a plan, I screenshot the plan and put it in a ‘plan’ table Every day I might make 3 trades, each of which are stored in another ‘trades’ table I have an interface where I review my daily ‘daily review’ table I would like to include in my ‘daily review’ interface, a grid showing all the trades for the day (so the daily review’ interface would need to list trades with the same date as is on the daily review table/interface. Each day could have many trades. But a specific trade can only belong to one date. I am not sure how I can do this. Can anyone help?

Hey all, I’ve been happy with my JavaScript progress but have hit a bit of a roadblock this morning, hopefully it’s an easy one. I’m parsing records with a matching string Name field - in this example “Tropical :palm_tree: ”. Then, from each returned record, I’m then filtering out any records where “myLinkedField” field is null. From the four records found, we return the three with Colours. What I’m now trying to achieve is to grab the array of linked “Colours” Record Ids found in the remaining filtered records (3 in total) - which I can do, but not in the desired return structure. My filter/map code returns the correct data, but I’m needing help to massage it into a simple array that I can then use to stamp into the original record after deleting the duplicates. //Tropical 🌴 De-dupe let table = base.getTable("Themes"); let themeQuery = await table.getView("Amazing Themes").selectRecordsAsync({ fields: ["Theme Name","Created","Colours"], sorts: [ {field: "Created