Solved

Is it possible to only have a month and year in the date field. Ex: 07/2021. One step further, a range of only MM/YYYY-MM/YYYY. Ex: 07/2020-06/2021

Hello, i need help with integrating with asana. I have set it up using integromat successfully to update a task, mark it as complete/incomplete or create a new task. Now, i would like to create a option whereby, i could delete an asana task when the record that created it in the first place is deleted in the airtable. The flow would that i created a record, which in turn created a task in asana. Now, for any reason, if a delete the record, i would like the task to be deleted as well. I need help with the filter specifically how could integromat recognize the task that should be deleted. Kindly guide.

I am trying to write multiple new records to a table. The docs suggest doing this like so: table.createRecordsAsync([{'My field name': '1'}, {'My field name': '2'}, {'My field name': '3'}]); In my code I have the following test: table.createRecordsAsync([{ 'Name': "Dave"}, { 'Name': "Sam"}]) But I get the below error: invalid record format. please define field mappings using 'fields' key for each record definition object As a check, I also attempted to write a single row, like so: table.createRecordAsync({ 'Name': "Dave"}) And this worked fine. I also attempted this: table.createRecordsAsync([{ 'Name': "Dave"}]) And I got the same error as before. So it seems to be something about the createRecordsAsync method and passing an array. Any ideas?

Hi all, Hope you’re doing well. I’m asking the community about a strategic choice I’m about to make. We are handeling Client Missions through Airtable. We did automate most of our process with Zapier, like sending e-mails. Right now, we only have 1 Client Langage, and 2 differents type of products. Each product and lang will result in a quiet different mail template. For now, I was using Paths in Zapier. However, we’re going to scale to 3 langages, and maybe up to 4 or 5 products, therefore I may have up to 15 differents mail templates. Zapier Paths seem not appropriate at all, without considering maintenance costs… I’m about to change the strategy to conditionally format e-mails templates directly in Airtable in a Formula Field. This formula with look like : SWITCH ( Product , “Classic”, SWITCH ( Lang , “FR”, ‘Mail template…” “NL”, ‘Mail template…” “EN”, ‘Mail template…” ), “Copro”, SWITCH ( Lang , “FR”, ‘Mail template…” “NL”, ‘Mail template…” “EN”, ‘Mail template…” ), “Office”, SWIT

Hi, Couldn’t find the bug posting forum so I am posting here. If there is a better place, please let me know. When adding a record by clicking on “+ Link to a record from …” defaults are not applied to columns in the added record. Is this behaviour by design? David

As far as I can tell, the Batch Update app uses the React Select library to handle input components for single-select and multi-select fields (both “regular” and “collaborator” types). Can the source code for the Batch Update app be made public so other developers can replicate the appearance already used in a “standard” Airtable app? As it stands, the Select component provided in the Airtable SDK isn’t quite sufficient for multiselect fields.

hello, I am using a field with multiple select (or single select) and I would like in a form to have the capability and select Other and then have a text in order to add a new option Do you know if this is possible ? Thanks

Hello all, I’m a no-code programmer (if that’s even possible) so for everything I do I look for a similar example and I copy and adapt. I’m trying to make a script where after pressing a button the user is asked for a couple of values to be updated in that record. I’m not able to find any script example where it automatically selects the record which button was pressed, and I always see something like this: const record = await input.recordAsync(“Pick a record”, table); Where user has to find and choose again the record to be updated. How can I do that? Is it possible? Thank you!!! Angel

Kia ora! I’m setting up an automation that watches one table for new records, and updates records in a second table with the information from the first. The specific use case is clients being able to update their personal information. This is done via a form in the first table with a range of optional fields - with the aim being that clients can only fill out what needs updating and leave the rest. However, when updating records in the second table based on these entries in the first, any empty fields in a record in the first table wipes the data from those fields in the second. Is there a way to leave fields alone if the fields in the new record are empty?

Hi all, I’m literally just starting out, but trying to make my primary field choose the correct investor (either personal or corporate). Is there a way to make this work in something like this format: IF( {Company Name}!=BLANK(), {Company Name}) ELSE( {Last Name}) The first part of the string works, but I can’t get the second part to work. Any suggestions would be greatly appreciated.

Connected typeform to airtable through a zapier integration. Text data, single select options work and is moved. Problem is the uploaded image / attachment from typeform comes up empty in my airtable. Anybody with the same problem? Screenshot of attachment being uploaded in typeform: Screenshot of table with missing attachment data:

Hi all, This is my first time posting, hope the formatting of this is okay. I’m trying to create an automation where when a cell is filled in with a link to an action plan, an email with that action plan is sent to a contractor, whose contact information is connected by a look up field to another table. The layout I currently have in Table 1: A1 is the Link to Contractor Record in Table 2. B1 is the Trigger cell, in this Case a cell containing a URL to the action plan. The goal is that when cell B1 is filled in, the contractor in A1 is notified. The contractor’s information is already inputted way ahead of time, the only information needed is the URL that is entered into 1B. The contractor is not a collaborator, which I saw could be problematic on the plus plan, but I have the Pro plan so I should be able to send outside emails. I tested this by setting up an automation purely within that other table and it worked fine. I tried bringing in an additional lookup field, a C1 that would

Hello, I am in the EST timezone and my boss is in the PST timezone. We are working on a shared Airtable base. Is the timezone displayed locally for each of us? For example, if she enters 6am, should I see 6am or 9am when I view the record? Thanks for any tips/guidance! Jena

My current formula works. IF({Post Date}<{Today’s Date},‘READY’) But if {Post Date} is empty it is also saying ‘READY’ What should I add to the formula that ignores a field if it is empty.

We have to deliver our assets to our agency 4 business prior to a launch so I’m curious to know what kind of formula I put in to create these dates.

Hi all, I would like to filter my records inside the vega-lite app to be independent from various views. Therefore I’m looking for a way to filter strings: record: “ABCD” record: “ABKF” record: “APFK” I want to visualise only records where the string starts with “AB”. As far as I read the documentation, it is possible to filter numbers and complete strings. But is it possible to truncate strings? Or maybe there is another workaround? I expect to use it inside the transform statement. Blockquote{ “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “transform”: [ “filter”:{truncate(“field”:“PL reference”, 4)}, //something here is fishy… “equal”:“AB” ], “title”: “Shipment”, “width”: “container”, “height”: “container”, “mark”: “bar”, “encoding”: { “x”: { “type”: “nominal”, “aggregate”:“count” }, “y”:{ “type”: “quantitative”, “field”: “PL reference”, “aggregate”:“count” } } }

This is handled in two tables Items to order (here I manage the status of whether the product can be shipped or not) Orders What I am looking for is to be able to have the sum of the total amount only of what is going to be shipped. Currently I have a Rolllup type field in the orders table that brings the data of the items to order that makes me the sum of everything (shipment + pending to be shipped). Is there a way to get the calculation only for those products that are marked to be shipped?

Is there a way to drag and drop fields and/or records from one table to another?

Excel has the IFERROR function to elegantly catch when a formula fails. Airtable doesn’t seem to have an equivalent. Is there a way to emulate this functionality? I have an airtable with a list of books that I’m reading. They have a start date and an end date, but I don’t write the end date until I’ve finished the book. I group books by end date and would like the group to be named “Currently reading” instead “#ERROR!”. Thank you

Using the formula for date add as found in AT, I can get the date to SUBTRACT days but not to ADD days. I have a date column {datereqsent} and I want {duedate} to calculated to 30 days from datereqsent. I have tried changing the minus sign to a plus sign and that is not working. TIA

HEY, I don’t know why air table don’t save this formula Do have a problem with the formula?or it’s a little long. I don’t really know where the problem seems to be is. Please help Me !!! IF({RECEPTION},IF(IS_AFTER(TODAY(),“DATE ECHEANCE”),“NON PAYEE”,“ENCOURS DE PAIEMENT”,IF({ENCAISSEMENT},“PAYEE”,"")))

I’m trying to create HTML code for each record based on a common HTML with placeholders between [ brackets ] that will then be replaced with record data from the corresponding fields, so I have in a long text field something like this: < h2 style=“text-align: center;”>[ESTADO]< /h2> < p> < /p> < table style=“width: 100%; border-collapse: collapse; border-style: none; margin-left: auto; margin-right: auto;” border=“0”> < tbody> < tr> < td style=“width: 25%;”> < h4>Cliente: < /td> < td style=“width: 25%;”> < p>[NCLIENTE] And then in a formula field I have SUBSTITUTE(HTML,"[NCLIENTE]",NCLIENTE) (that last one is the field name) Works fine with the [ESTADO] placeholder, but then when I use the [NCLIENTE], either by itself or as a second nested substitute formula I get #ERROR! message. I have tried changing the placeholder name and/or the field name, I can’t figure out what it is that is causing this, has anyone se

I have a formula field that includes a linked record field {Supplier}. The result is the text in the linked record field has quotation marks. Is there a way to remove the quotation marks from my results? DATETIME_FORMAT({Purchase Date},‘YYYY-MM-DD’) & “-” & {Supplier} 2018-03-31-“Supplier ABC - Your Town, WA - Unknown Address” Many thanks :pray:

Said formula: AND({FORMULA1}!="", {FORMULA 2}!="", {FORMULA 3}!="") no matter what combination of those 3 fields are empty or populated it always returns 1. i only want it to return 1 once all those fields have returned a value. conditional automations using ‘and’ also return true even if not all of the options are true when using formula fields. are we seriously not able to check if several formulas did or didnt populate? am i missing something? seems to me that AND() is behaving more like OR() but i have no idea what im talking about

Hello, I have two coworkers who have recently left the organization. Since we pay by user I will be deleting their accounts. Will their activity history and entries into shared workspaces and bases still be viewable by other paid users/collaborators in our organization? Thanks! Lisa