Solved

I am currently working on setting up a time sheet on one of my bases. I am having an issue with a formula to ID my entries. I am trying to Concatenate the date, name of person, and total worked time all in one. I have the date and name figured out but I can’t get the total worked time to format in anything but seconds. CONCATENATE(DATETIME_FORMAT({Start Time},‘l’), " - ", Who, " - ",{Total Hrs}) {Total Hrs} is currently this formula, DATETIME_DIFF({End Time},{Start Time}), which is fine because I can change the field to be a duration. I have explored the community but haven’t been able to find a solution. Thanks in advance for your help!

Hello, here is my formula below IF(DATETIME_DIFF(TODAY(), {Course Joining Date}, ‘months’) > {Course Payment Duration}, ‘Payment Complete’, ‘’) What I need is to ignore the course payment duration field if it is blank, at the minute this is still getting marked as payment complete. Thanks in advance Chris

Hi! Very new to formulas and slogging my way through thanks to all the great advice in this forum! I’m trying to get the formula to return nothing if {days b/w successions} is blank, and to calculate the next date if there is a number in that field. I wrote this, based off what I gleaned from other posts, but it isn’t working. IF({Days b/w successions}=BLANK()," ", DATEADD({Field Date 1},{Days b/w successions}, ‘days’)

Hi there, I’m trying to debug an issue with the Airtable automation, but don’t know how to re-test the trigger as the instructions indicate (see image below). Apparently Airtable cannot email non-collaborators on my current billing plan, but the email recipient is the owner of the base, so I guess it’s a level up of a collaborator. What’s could be wrong with this automation? I’ve tested with other email records and it worked perfectly. Can anybody help? Thanks :slightly_smiling_face:

Hi Community! I’m working on a table that allows my company to easily track and time rental property application processing times. Fields I have are listed below: Unrelated fields are hidden. We want {Hand Over Timer} to start timing once a record gets updated to “Processing”. We don’t want to track time over weekends. For this, we decided to implement the help of the WORKDAY_DIFF() function. The problem is, this works horribly when time is involved. I’ve had to create this monstrosity to make it accurate: IF({Processing Activated (Automation Requirement)}, IF( {Application Tagged As Handed Over}, IF( (WORKDAY_DIFF({Application Started Processing}, DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Australia/Brisbane'), 'M/D/YYYY h:mm') ) >= 1), (((WORKDAY_DIFF( {Application Started Processing}, DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Australia/Brisbane'), 'M/D/YYYY h:mm') ) * 24) * 3600)) - 172800, (((WORKDAY_DIFF( {Application Started Processing}, DATETIME_FORMAT(

I’m building a custom app and need to show an attachment’s thumbnail image as part of an info card. When I enter <div>{record.getCellValue("Attachment field")}</div> to view the cell values, I get the following error: Error: Objects are not valid as a React child (found: object with keys {linkedRecordId, value}). If you meant to render a collection of children, use an array instead. I’ve tried adding record.getCellValue("Attachment field").fields.url but it comes up as undefined. I’ve also tried {record.map(value => {value.url})} to try access the object’s properties but map is not a function of record. How can I access the thumbnail’s URL?

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