Solved

Hi, first of all new here :grinning: I’ve searched in the comunity and nothing really answers my question I have a formula DATETIME_FORMAT(DATEADD({Data Pagamento 1},{Produção Dias},‘days’),‘DD/MM/YYYY’) When I go to calendar I cannot select that field. Am I doing something wrong? I also thought of the possibility that the fact of being a “formula field” does not let the app recognize it as date, even though it is. So I thought a work around that I don’t know how to apply Create a second “date field” which value is equal to the formula. I thought maybe with … automation? :roll_eyes: I tried but I wasn’t able to find such function. “Date Field” = “Formula Field” Thanks Juan

If I set a field to be required AND only visible under a specific condition and that condition is not met, will it stop the form from submitting because a hidden field is set as required? It sounds stupid, but I literally ran into this only a couple months ago elsewhere with a form builder product that will go unnamed… but it wasn’t smart enough or well engineered enough to know that if a field is hidden, it shouldn’t be required unless it is visible no matter what. So then it would output a validation error telling people “You need to fill in field XXXXX” and they can’t see the field or even know it exists. Super poor UX there. I could probably test this and find out but I figure I’ll ask here in case there’s something functional I may be overlooking or additional info.

I am trying to search for records in Airtable from Integromat and unable to figure out how. I have created a scenario where I get a unique id to be searched for in Airtable via a webhook. After linking the webhook to Airtable, I selected the option “Search records”. There is a field called “Formula” and I am not able to figure out what it means.

Hello, I have an issue which I will try to explain through the following screenshots: THE SET UP I have have a 3 Field (Column) Table with the following fields: (Name, Company and Re-Orientation Status) The AUTOMATION - Trigger Condition The trigger: When Re-Orientation Status is Overdue The PROBLEM When I test the trigger, only 1 record is found; however, the table above clearly shows that more than 1 record meets the trigger condition. Please advise on why this happens. Is there any way to fix this?

This may sound like a silly question but is there a shortcut to enter a new record? I have tables that are sometimes hundreds of records long and don’t want to scroll to the bottom just to click the plus sign to add a new record. Also trying to avoid using the context menu to insert a new row. Is there no quick add button anywhere at the top or did I miss it somewhere?

Hello, I’m trying to init a custom block for my database but i get this following error whenever I launch the command line block init from any github repo. Initializing block using https://github.com/xavdid/airtable-grouped-chart template ❌ Something failed! Cleaning up... ❌ Error: a.isDirectory is not a function Do you have any idea how i can fix it please ? Thanks in advance for your help BR

Hello, I’m a new user and looking to set up a quick questionnaire. I discovered pretty quickly that there are character limits on the Single Select Field option which is causing parts of the options to be cut off. I saw references to using Linked Records to get around the character limits, but I’m struggling to see how exactly to do that. Is there a tutorial that I can follow to see how this is done? Thank you in advance!

Hi there! Is there a formula for isolating the last available single-select from each group? I’m looking to only show the Shows that are marked as On-Air but also only want to see their currently airing season. I have a single-select for On-Air or Off-Air, and a single-select field for Seasons, but let’s say Jersey Shore has 6, and Teen Mom has 10 seasons, I only want to see Season 6 of Jersey Shore and Season 10 of Teen Mom. Is that possible? Thank you in advance!

Hi I have two fields that I am trying to use an IF AND statement on One is a date field {Rollout Date} and one is a checkbox {BU Code Updated} I want to write a statement that returns an “error” message when the date is before today’s date and the checkbox is {BU Code Updated} checkbox is unchecked - nothing needs to be returned if the date is after today and the checkbox is unchecked

We have set up several calendars for various streams. Now we would like to create a new ‘mothership calendar’ to be able to view all the events in the individual calendars in one place. Is there a way to do this without having to link to each event?

I’ve built a formula that shows a Status in my Task field based on how many Sub-Tasks are complete: IF({Sub-Tasks Complete} = 0, “ :radio_button: Not Yet Started”, IF({Sub-Tasks Complete} = {# of Sub-Tasks}, “ :white_check_mark: Complete”, “ :orange_circle: Working On It”)) For some of my Tasks there is only one Sub-Task. When one of my teammates moves the Sub-Task into the “Working On It” status, I would like the status in the Task field to say, “Working On It.” Not sure how to change my formula to do that. Any suggestions? Thanks, Kevin

Hi All, Looking for some guidance as I’m well outside my basic scripting depth. Use case: I have a table of applicants each linked to a group. The groups are listed out in another table and then all the group’s applicants linked in the “group members” field. Each applicant has a field that I would like to compile into a list and email or display with markdown formatting. The goal is that I have a button on the Groups table that allows a user to “generate list” which outputs or emails them the formatted list of the 5-6 group members that can then be copied into an email. Where I’m stuck is I am able to get as far as building an array of the ids for the linked applicants, but don’t know how to then use that array to retrieve the individual field values for each applicant from the applicants table. Script so far is below. Also thanks to those whose scripts I already borrowed/mutilated to get this far. This script is born because the field I’m trying to pull out is a custom hyperlink and w

I can’t seem to figure this one out. I have 3 Writer fields with 3 corresponding Share fields. So far I am only able to combine the WRITER fields with the following formula: {WRITER 1} & IF( AND( {WRITER 1}, OR({WRITER 2}, {WRITER 3} ) ), ', ’ ) & {WRITER 2} & IF( AND( {WRITER 2}, {WRITER 3}), ', ') & {WRITER 3} But I’d like to combine WRITER and corresponding SHARE fields and then combine everything in the ALL NAMES COMBINED formula field. The final combinations should read: John (BMI: 20457, 50%), Michael (BMI: 20691, 50%) John (BMI: 20457, 50%), Michael (BMI: 20691, 25%), Charles (PRS: 30918, 25%) Charles (PRS: 30918, 100%) Yes, the extra “)”, commas, and percentage signs have to be added in the formula, but my question is, can all this be done in one swoop in the ALL NAMES COMBINED formula field, or do I have to create 3 “PRE-COMBINED” fields for the 3 Writers and their percentages and then combine these fields with my original formula? It would be great if it co

Hi, Has anyone used the URL property described here: Vega-Lite Data Vega-Lite - a high-level grammar for statistical graphics. Vega-Lite provides a higher-level grammar for visual analysis, comparable to ggplot or Tableau, that generates complete Vega specifications. Vega-Lite specifications consist of simple... to load data from an external (public) URL into a Vega Lite specification within the Airtable app? This is the kind of syntax that works externally in the Vega Lite editor: "data": {"url": "https://vega.github.io/vega-datasets/data/unemployment-across-industries.json"} I’d like to include some external annotation data in a chart (and join it using a lookup, which also works OK in the Vega Lite editor), but I’m having trouble getting it working. I know the Vega Lite block binds the table data at runtime, but I’m not quite sure whether it’s able to make external requests or not. It doesn’t throw an error when I do it,

I have been trying to figure out how to write this formula: Where Category is any of “macOS” AND checkbox Universal is checked OR checkbox Intel is checked. Here are two of my approaches: IF(Category = "macOS", AND(Universal = 1), OR(Intel = 1), "true") IF(AND(Category = "macOS", OR(Universal = 1, Intel = 1)), "true") Can anyone tell me what I’m doing wrong?

Like the example in the screenshot, I’m trying to organize my formulas for easier viewing. How in the bleep do you get formula onto a new line? Or indented? Is using an external editor the only way?!? I was wholly expecting the “Enter” key to do the trick, but not dice. What am I missing?

Hi everyone, Airtable is experiencing downtime as of approximately 1:20 pm (PT), and our engineering team is investigating the issue. We will keep you informed as our investigation evolves and we sincerely apologize for the inconvenience this has caused. I will be back in touch soon.

This is a big ask, but I just can’t figure out how to setup this formula. I’m trying to determine the Step 1 “Initial Trial Balance”. The initial trial balance is the lowest account balance for any given month in a 12 month period. The amount can change based on the following variables (other cells): First Payment date (Month) School Tax Amount School Tax Disbursement Date Property Tax Amount Summer Property Tax Disbursement Date Winter Property Tax Disbursement Date This example scenario/figures can be found here: https://www.consumerfinance.gov/rules-policy/regulations/1024/E/ I can’t figure out how to create the formula so that it calculates correctly given the variables noted above. Anyone care to take a stab at it?

Hi, I am using a formula to create a slug: SUBSTITUTE({Job Title}," “,”-") However, is it possible to add another item in the formula, such as {location}? Many Thanks, Hannah

Hi, guys! I’m trying to create an automation. Every time I enter a record matching specified conditions, I need an automation to update that same record, inserting values in two other fields. I did the following steps: Trigger: when a record enters a view Action 1: find records where labels is ImportantUrgent Action 2: update record from the Table Tasks, where RecordID is Records (Step 2: find records - List of Record Id, Field Importance is Important and Urgency is Urgent. Yesterday, when I inserted only one record, that automation worked just fine. Today, when I inserted another record, the automation failed. See the screenshots below. Could you please help me fix this? [EDIT] I’ve tried several combinations. Keep receiving the same error message.

We have the limit of 50 000 automation runs in our plan. Does this limit includes API calls?

Hi, I think it´s is a basic issue but I´ll be grateful for any help. When using the “When a Record is Updated” trigger for create a new record, several records are been created when a start to type the changes In this exemple above 4 records were created but I need just 1 new records with all changes made. How can I solve that? Thanks in advance!

So I’m looking to create a simple chart of crypto projects I’m interested in tracking. I’m using a variation of @Nikolay_Tsenkov elegant stock price updater he posted on the Example Script Showcase. I can get it to work with a few securities sites, it pulls stocks in beautifully but when using CoinGecko’s API I keep getting an “Undefined” error. Upon inspection I can see that I’m getting the payload back correctly but no matter how I try to load it, it doesn’t seem to want to go into the table. Is it because the payload is nested within the id? I’m totally stumped on this at this point and could really use some fresh eyes to get me sorted. Here’s an example of the URL string. the `${coin}’ is obvously for pulling the id in from Airtable, in this example I’m using “cardano”: GET: https://api.coingecko.com/api/v3/simple/price?ids=${coin}&vs_currencies=usd RETURNS: { "cardano": { "usd": 1.15 } } All I want is the “1.15” to come into my price field, but NOOOO… A

Howdy, Automation slots are so, so precious. :face_with_raised_eyebrow: In order to ensure we stay under the Automation limit, I’ve had to switch everything away from “When record matches conditions” triggers to “When record updated” triggers, watch a whole bunch of unrelated fields, and combine scripts to be massive & idempotent. All good, but significant work keeping track of everything. :sweat: For some tables, we need the data to always be correct - even immediately after creation. For these tables, it seems like the minimum number of Automations is two: one on the update trigger, and one on the create trigger - just to set something inconsequential to trigger the update. My question is,º is there some non-human, non-Automation trickery that we can use to drop the number of required Automations per table to one? That is, how can I ensure the update event will trigger immediately after creation also - without using another Automation slot? Please and thank you! :pray:

Hi, community! It`s my first time writing a formula and I need your help! I’d like to create a formula to represent a due date ocurring ‘today’, a due data ocurring ‘this week’ and a due date ocurring this month. I tried to create that formula combining an IF function and a DATEADD function. Airtable keeps informing the formula is invalid. What’s is the correct way to write that? I thought the following formula was ok, but Airtable says it’s wrong IF({Due Date} = TODAY (), “Today”, IF ({Due Date} = DATEADD (TODAY() , 7, ‘days’), “This week”, IF({Due Date} = DATEADD (TODAY(), 30, ‘days’), “This month” ) ) ) The formula is wrong and I don’t know how to fix it. I tried several variations and all of them are wrong as well. Could you please help me solve this? P.S: The table is written in Portuguese. I translated some fields into English to help your analysis.