kuovonne - profile

kuovonne · Feb 24, 2022

Airtable has just released my latest app: My One Record. I wrote this app because I wanted a quick way to access linked records in a grid view without the distractions of other unrelated records. I have been personally using this app in my own bases ...

kuovonne · Sep 08, 2021

I’m testing out making a few of my scripts available on my Gumroad Store. These scripts currently have a “Pay What You Want” pricing model, so you can get them for free if you like. Duplicate Record including Linked Records: Duplicate records, inclu...

kuovonne · Jun 29, 2021

My new app “Ready-Made Formulas” is now available on the Airtable marketplace. This app includes over a dozen “ready-to-use” formulas for common tasks such as formatting numbers and dates as text strings to include in reportsgenerating urls for prefi...

kuovonne · Dec 07, 2020

I have a new app on the Airtable Marketplace! Have you ever wanted to prefill a form will data that already exists in your base, but found building the url to be difficult? My new marketplace app, Prefilled Forms, creates a formula that calculates a ...

kuovonne · Sep 01, 2020

It looks like free use of Scripting block has been extended another six months! (it was originally going to expire this month.) Will there be a similar extension on free usage of Custom Blocks?

kuovonne · Jan 25, 2023

Thank you for looking up the thread on timezones. I played around a bit more. Note that I am in the USA in "Central" time. Your formula will be slightly different since you use a 24 hour clock instead of am/pm, and you are in a different timezone.

kuovonne · Jan 25, 2023

You can use an interface button that triggers an automation.In the automation, use a "Create Record" action that creates a new record with all the same field values as the original triggering record. You might find that you actually want to set some ...

kuovonne · Jan 25, 2023

Not sure what updates you are looking for.Here are some options:If the user needs only read-only access to a single table/view, you can use a shared view.If the user needs read-only access to multiple tables, you can sync those tables to a new base a...

kuovonne · Jan 25, 2023

It depends on your single select choices.One way is to use a SWITCH formula: SWITCH( {single select field name}, "choice A", 1, "choice B", 2, "choice C", 3)Another option works if the single select value looks like a number:VALUE({single select f...

kuovonne · Jan 25, 2023

No, this formula will not change with daylight savings time. It is a hardcoded timezone offset. Changing the formula at different times of the year also will not help. You would need to have something that can tell based on the date if it is daylight...

User Statistics

User Activity

Kuovonne's latest app: My One Record

Kuovonne's Script Store

New App: Ready-Made Formula

New app in the Airtable Marketplace: Formula for a Prefilled Form

Scripting block free until March 2021

Re: DATETIME_PARSE AND CONCATENATE

Re: Add a Button to an Interface to Duplicate the Current Record

Re: How to give user permission only to tabs within a base

Re: Leveraging Formula Fields - Converting a Single select value to a numeric value for use in a cal

Re: DATETIME_PARSE AND CONCATENATE