Paul1 - profile

Paul1 · Sep 15, 2022

Airtable is measuring emoji length differently under functions LEN and FIND. In the screenshot, the two fx fields have the formula as the field name. With LEN, Airtable is measuring the length of “ :stop_sign: 23” as 3 [as if :stop_sign: =1]. With ...

Paul1 · May 16, 2022

When the Start date field and End date field are the same, records DO NOT appear in the Timeline\Day timescale, but DO appear in views bigger than Timeline\Day. Setting the End at ‘Start + 1 minute’ makes it work- but yuk! Is this by design- to be c...

Paul1 · Jun 29, 2021

I have STARTTIME, DURATION,CALCULATEDENDTIME and ENDTIME fields. After entering values for STARTTIME and DURATION, the CALCULATEDENDTIME adds the two. My automation is setup to trigger when a value is entered into DURATION, and copy CALCULATEDENDTIME...

Paul1 · Feb 28, 2021

A simple DATEADD is changing time. SET_TIMEZONE(DATEADD(date,moredays,'days'),'America/New_York') If it is because of daylight savings, does airtable recognize that and have a ‘fix’?

Paul1 · Jan 04, 2021

I want to get the referral credit and I want them to open my shared base. Is there a way to do that in one link? If not, what process would you suggest?

Paul1 · Aug 26, 2024

the key to prefilling dates is DO NOT encode the date:this won't work- prefill_Date%3D2024-08-26T17%3A00%3A32.802Zthis will work- prefill_Date=2024-08-26T17:00:32.802Z

Paul1 · Apr 28, 2023

this works:https://community.airtable.com/t5/interface-designer/copy-existing-interface-into-interface-page/m-p/47840/highlight/true#M171

Paul1 · Mar 07, 2023

Thanks for the solution @Kamille_Parks - here's how to achieve the data steps for 'Attachments' with the new (since 2021) automation structure/ naming scheme.your first data set:Record (Step 1: Trigger)|Field values|Attachments|Url , appears to now ...

Paul1 · Jan 26, 2023

How about using it kind of like a Lookup- so it simply shows the cell contents (at least in the same table)?Can the URL be used to just show the cells contents?

Paul1 · May 27, 2022

An unresolved issue in an ongoing 3 year old post- when it would have closed with no activity in 15 days!! That’s got to represent some measurable lost profits Airtable!! Please get this popular request done!

User Statistics

User Activity

Data corruption when using LEN and FIND with emoji's

Timeline error: records with same start and end not showing in Timelines 'day' timescale

Automation triggers before data entry is finished

DATEADD changes the time- ERRATICALLY!

Can I send a single link that has my referral AND a base share link together? What is the best way to accomplish this?

Re: Prefill a Specific Date in a Form

Re: Duplicate interface

Re: Attachment automation to add and not replace attachment

Re: New: Deep link a cell

Re: Automatic bidirectional linked records in same table