wjb - profile

wjb · Apr 22, 2021

Hey all. I’ve searched a handful of times but can’t seem to find another example of what I’m trying to accomplish. I’m looking for some help with an automation or script that can automatically add the correct inquiry number. We do this manually and i...

wjb · Nov 09, 2020

Hey all. I’ve got an Automation script seemingly close to get the Youtube Video ID from a full URL which I found here. Script from link above <script type="text/javascript"> function youtube_parser(url){ var regExp = /^.*((youtu.be\/)|(v\/)|(\/...

wjb · Nov 08, 2020

Hey all. I have been building a Video Tracker Base for my Youtube content. It’s honestly one of the most enjoyable things I’ve worked on in Airtable so far. Anyway, I’ve used this post to make an awesome clipper to pull in my existing videos (with th...

wjb · Nov 05, 2020

I’d love to be able to see a visual style of graph in a cell. For example, if there are 3/5 items related to one linked field “DONE” I’d love to see a field I may call “PROGRESS” which has a cell for that record that is filled by 60%. Your competitor...

wjb · Nov 04, 2020

Hello. I have a series of actions in an Automation set up to create records (tasks) when a new project is created. Sometimes there’s a snafu and the project is created accidentally or there’s a mistake. Meaning I need to re-run the steps in the Autom...

wjb · Nov 22, 2021

It’s an interesting start. My top two desires as of now are: Cross-Base Interface, a true dashboard. (I know, I know this will be a sharing nightmare) Embeddable Interfaces - allow sharing control like you do other shared views

wjb · Apr 28, 2021

Kamille_Parks: const allNumbers = records.map(x => Number(!x.getCellValue("Suffix") || isNaN(x.getCellValue("Suffix")) ? 0 : x.getCellValue("Suffix"))) You are marvelous. This works perfectly! Thank you so much for your effort on this!

wjb · Apr 26, 2021

Hi Kamille. I’m sorry I misread your last post. I really appreciate your help with this. I did attempt this as you suggested but I’m getting a 21-NaN as the result instead of 21-847 as expected. This is what I have in the Code field of the script for...

wjb · Apr 23, 2021

Ah, that makes sense. We don’t actually number inquiries like that, however. They are a continual list of unique numbers disconnected from the year.

wjb · Apr 23, 2021

Hi Kamille. I really appreciate you digging into this! It seems to be close to working but it’s not finding the greatest existing inquiry number available (21-846) and instead generated 21-108. I would expect the next number to be 21-847

User Statistics

User Activity

Auto-Number New Records with Prefix

Get Youtube V=ID Script

Scrape YouTube Views at 24 hours after Publish

Filled Cell Graph-style Field

Run Automation by Script

Re: Introducing Interface Designer 🎉

Re: Auto-Number New Records with Prefix

Re: Auto-Number New Records with Prefix

Re: Auto-Number New Records with Prefix

Re: Auto-Number New Records with Prefix