Solved

Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/21 - that’s 10th September, unless you’re American then it’s 9th October… sorry, I mean October 9th. I know I can use “friendly format” which shows the full length of the day and month (i.e “Friday, 10th September, 2021”) and cuts off half the date unless the column is unnecessarily wide. I’ve looked at this thread but it doesn’t mean much to me: Date format hints and question on localized date formats for users Custom Apps I noticed the date value provided is structured as M/D/YYYY. Is this consistent across all users? Or does this change depending on regions? ie. D/M/YYYY for EMEA Airtable users, M/D/YYYY for US Airtable users, etc. This might be a new Feature Request, but it would be awesome if CellRenderer ca

Can I get a second pair of eyes on my script? Expected behavior is that a user can click a button on any record in the “People” table, and it will create a record in the “Payouts” table, linked to People by a lookup field called “Person” I don’t get any error messages when I run this script, but I also don’t get any new records in the “Payouts” table. And I’m the only user on the license, so I don’t think it would be a permissions error. Can you see anything I’m missing? Thanks in advance! const childTable = base.getTable('Payouts'); const parentTable = base.getTable('People'); const parentRecord = await input.recordAsync('Parent record', parentTable); const linkField = 'Person'; const newRecordValue = parentRecord.getCellValue("Account Balance")*(-1); console.log(newRecordValue); childTable.createRecordAsync({'Amount': newRecordValue, linkField: parentRecord});

Hi. I am using Airtable Desktop app on Macbook Air M1. When I expanded a row to view in details, there were hidden fields that I can’t scroll to the bottom. Below is the example screenshot. Anybody else having the same issue? How can I solve this issue? Thank you.

I have the following options in a multiselect field with: Table sample options: first row: “$5,400” & “10,400” second row: “10,400” & “Promo” How can I extract the first option; for first row would be “$5,400” and for second row should be “$10,400” Thank fo your help. The ‘comma’ is giving me hard time to extract the right record.

In the desktop app, we don’t get the scroll bar anymore… Anyone else has this bug? I already contacted support, but haven’t got an answer yet.

Hello, I don’t have a code and asking for an advice on How to do an action script that change the formula today() inside the column for I am doing a schedule weekly report in the data fetcher app and need to fetch the current date. Is it possible?

I just found the vega-lite block today and am trying to get a stacked bar graph using 2 fields. I stumbled onto the fold example (Fold | Vega-Lite) and was able to convert it to stacked instead of columns… and it looks like exactly what I want inside the vega-lite editor. But inside airtable, it seems that it doesn’t like the return “key” and “value” from the fold command. Gives the error: value is not a valid transform name, inline data name, or field name from the Table1 table: Anyone know if I’m doing something wrong, if this is missing functionality in airtable, or a bug? { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Table1", "width": "container", "height": "container", "transform": [{"fold": ["Field1","Field2"]}], "mark": "bar", "encoding": { "x": { "field": "NAME", "type": "nominal" }, "y": { "type": "quantitative", "field": "value" }, "color": { "field": "key", "type": "nomin

I’m designing a CRM using a series of Airtable Automations when I change the status of a record in company table (or contact table) to “in progress” (a single select field) a new record in the Opportunity table gets created. This is working fine. my problem is that I can’t figure out to do it in reverse: so when the opportunity resolves as “sale” or “no sale” I want the single select fields in the Company/Contact tables to automatically update accordingly (“sale” → “client” / “no sale” - > “not a client”) I first create a “when a record matches conditions” trigger (when stage is “no sale”) I then go on to create an “Update Record” Action but then I can’t find the correct fields. I chose the table where the action should happen but when I hit the “plus” sign I am shown fields in a different table.

Hi everyone, My goal here is to allow my master inventory list to have a dynamic price based on the most recent purchased price of an item. So if an item cost $10.00 in August, but costs $15.00 in September, my inventory will initially show a cost of $10.00, and when the September-priced item is purchased it will update to $15.00 I could get this done with an Automation but i’m looking for a cleaner way to do it without having to add formula columns and update their results to a text field in order to use the Find Records functionality of Automations I’m using a Rollup field to pull the most recent Linked Record by using the MAX(Values) condition shown below: This allows me to grab the most recent record in my purchasing table that’s linked to the inventory item. I would then like to pull the associated price from that Linked Record from my Purchasing table into my Inventory Table I’m trying to use the RIGHT() Function (with and without turning it into a string) but i’m losing the

Ok, I am working on a project and have been staring at my formula for quite a while now. Hoping somebody can help me out! Essentially, I would like to combine several fields into one, but include certain fields only when they are filled. Here is my formula: DATETIME_FORMAT({Clinic Date},‘MM-DD-YY’) &" “&{Clinic Name + Activity}&” - “&{Blue - Allocated}&” Blue"&", “&{Red Allocated}&” Red “&” , “&{Yellow - Allocated}&” Yellow"&" - HL Provider: “&{HL Provider}&” - ( “&{Lead Team}&” )" In this scenario, the following are true: Blue, Red, and Yellow allocations are numeric fields that may or may not be filled in on each row. I’d like them to only appear if they have a number greater than 0 populating that field on a given row (otherwise, I don’t need to see it in the formulated text) HL Provider, Clinic Name, Lead Team are all just other fields that I am interested in seeing in the text, and I’ve tried to format it accordin

Hi! This is my table: https://airtable.com/shr0FiM4g1quNwnpG. It’s a table of our customers’ active licenses. Each license continue to be active until the customer calls us and terminates it. Then we remove the record from the table. Start day = The date the customer signed the license. Notice period (days) = The amount of days in which the customer need to terminate it’s license in advance. Otherwise the license is continued for another Agreement period. Agreement period (months) = The amount of months the customer is tied to it’s license. Tied until = The date the customer is tied to it’s license, I.e. Start day + Agreement period (months). The problem: I want the last field, Current possible termination date, to calculate a future date, that is the last day the customer is allowed to terminate it’s license. This date should be dynamic and based on today’s date and the criteria in the other fields. I’ve included some examples to show how it’s supposed to be calculated. Please let me

Hi everyone, I want to use Airtable to make shopping order for a store. I have 4 tables: List of products (Airtable - Grid view) Supplier list Price list: for each product, I indicate the price at each supplier (Airtable - Grid view) Purchase order Airtable - Grid view The problem is on this last table. I indicate the product I want, the supplier, and I would like to have a column that searches for the price of this product, for this supplier, in the price table. I hope I was clear, I guess this is a fairly simple and classic issue, but I can’t seem to do this search across multiple tables. Thanks in advance to the community, Guillaume S.

Is there a way for a formula to appear only on certain conditions? For example, I have the following situation: I have a # field and a date field I’d like to create a formula that auto calculates three-weeks out from my date field ONLY when the # field is not empty Here is the formula that I currently have: DATETIME_FORMAT(DATEADD({Clinic Date}, 3, ‘week’),“MM-DD-YYYY”) Is there a way to set up that additional condition so I don’t further clutter up my database? Thanks in advance to anyone who can assist!

Hello! I want to have a Formula as the Secondary Field. Now the Formula is: CONCATENATE(“PR-”,Autonumber,"/",YEAR(TODAY())) The “Autonumber” is a Field as Autonumber. How can I achieve, that the “Autonumber” in the CONCATENATE is always 4 digits long, independent of it’s length. Besides that I want only the two second digits of the year. So the values of the Autonumber is “4”, I want: “PR-0004/21” Thank you for your help in advance! Best regards Attila

Hello! I want to update the Status of a Record, depending on a Status of a Record in another Table. Why am I getting the error messages? What am I doing wrong? Best regards Attila

How can I display numbers with 3 digit all the time ? Like 1, 2, 3, 10, 125 → 001, 002, 003, 010, 125 Pierre,

Hi! I want a field to show one of three values (Active, Expires in a week or Expired) depending on if the field “Startdatum” is after today, within a week or before today. How do I solve this? Thanks!

See the attached screenshot for an idea of what I’m trying to accomplish. I’m using a formula to concatenate the names of sellers and buyers. Simple except that if there are two or more names, how can I remove the identical last name, or add an & between names if they are different names?

If I can’t access airtable suddenly, (This morning I couldn’t access airtable for a while), how can I access my data? Can it be deployed locally?

Is it probable?If I am in a table in workbase A, how can I jump to a table in workbase B quickly? Is there any shortcut?

I could use some assistance with extracting a word from a string. Here is an example of the string. 200 East Broadway #Z001 (Jacob to Seymore) This is the formula that almost has what I need but missing something. MID({Transaction Name}, SEARCH("#",{Transaction Name}), SEARCH("#",{Transaction Name}, SEARCH(" “,{Transaction Name})) - SEARCH(” ",{Transaction Name})) I’m trying to extract the apartment number (#Z001) from the string. Thanks in advance to anyone that tries to help with a solution.

I have a list of people and their dates of birth. I’d like to know if that birthday falls in the current month. Right now, I have a column, the formula of which is IS_SAME({55th Birthday},TODAY()), which indicates if that birthday is today, but I’d like to see everyone in the list who turns 55 in the present month. So, in September, the September 55th birthdays are indicated; in October, the October 55th birthdays will be flagged; and so forth.

I need to change this formula to ignore weekends. It is successfully calculating the next day a task should take place on based on frequency, but that frequency should add 1 or 2 days if it is on a Sunday or Saturday. Anyone know how to change my formula to account for this? IF((Frequency = “Monthly”), (DATEADD(Due, 30, ‘days’)), IF((Frequency = “Biweekly”), (DATEADD(Due, 14, ‘days’)), IF((Frequency = “Weekly”), (DATEADD(Due, 7, ‘days’)), IF((Frequency = “Daily”), (DATEADD(Due, 1, ‘days’)), Due))))

Hi so i have a airtable table and it has date and time field. I wanted to use those value for time for calculation condition and date for comparison basically i want if else based on date and time values. How can i use that? i used JavaScript functions for that but still i cannot get my desired output. Please someone help me out here. IT IS VERY URGENT pls.

Hi there! Trying to create a formula that pulls various hourly rate information from another table and calculates the hours x hourly rates into a grand total field. Additionally, rates vary depending on the employee selected, so once a name is selected, the formula will pull their respective rates from the other table and start the calculation. I believe this may require a roll up field as well, but not sure where that falls in the flow. Here’s a screen shot of the other table with various $$$ rates Here’s my main timesheet table where you’ll see a number of hour totals (Reg., OT, and 2xOT). Again, once I choose a name (People) I want to calculate those totals with their respective rates in the Total Compensation field. Really stuck on this one! Thanks!