Andy_Lin1 - profile

Andy_Lin1 · Oct 26, 2023

When I am in a base and click the "Share" button in the top right, when I start typing a name under "Email invite", I get a bunch of auto-complete suggestions of people I don't know and aren't in my organization (some are from Gmail, some are from co...

Andy_Lin1 · Sep 20, 2023

What is the proposed idea/solution?When searching within a view, add a toggle to display only matching records / hide non-matching recordsHow does it solve user problems?Quickly surface matching records within a view to see results "at a glance" inst...

Andy_Lin1 · Sep 18, 2023

I'd like to see a formula function for looking up values in linked records, something like:LOOKUP({Linked Record field}, {Field in linked table})Basically, a two-criteria lookup similar to "INDEX MATCH MATCH" in Excel without needing to import all th...

Andy_Lin1 · Aug 25, 2023

Saw a new ARRAYSLICE function pop up in auto-complete today that isn't in the documentation. Anyone know where it came from? I suppose it allows for a less hack-y way to access individual items in a rollup, but I'm not sure what it provides in isolat...

Andy_Lin1 · May 02, 2023

I'm sharing a solution to a problem I had; hopefully this will help others. Note: you will need to be on a plan that includes Automations.When you try to reference information from a linked field in a primary field, Airtable will warn you of a circul...

Andy_Lin1 · Aug 19, 2024

This came up a few years ago and I believe the recommendation was to use emoji/emoticons as a stopgap. (Unfortunately, I can't find the thread, but there wasn't any promise at the time that this was under development.)

Andy_Lin1 · Mar 13, 2024

I can't duplicate the error:https://airtable.com/appvR6hY4ZgTSWVVS/shriIIqar0FGP7sb1However, you can correct it by using using the following formula in your Rollup field:REGEX_REPLACE(ARRAYUNIQUE(values)&"", ",$", "")&"" converts the array to a strin...

Andy_Lin1 · Mar 13, 2024

I've never tried this script, but I think you should be able to adapt it to your needs.https://community.airtable.com/t5/show-tell/scripting-block-detect-scheduling-conflicts/td-p/61659You likely won't be able to sort it out just a formula due to a c...

Andy_Lin1 · Mar 07, 2024

Btw, may I ask why you are using an automation and not a formula?You could in theory have a formula, given checkboxes ABCD:IF( AND(A,B,C,D), 'Completed', IF( OR(A,B,C,D), 'In Progress', 'Not Started' ))

Andy_Lin1 · Feb 07, 2024

The output of the function is always a string, so unfortunately no in the absence of a field that takes a URL and shows a preview (it's been requested since the early days of Airtable, so it's unlikely to be implemented any time soon).

User Statistics

User Activity

Unfamiliar Base Sharing Auto-Complete Suggestions?

Show only matching records when searching (filter instead of highlighting)

LOOKUP function for fetching values from linked records

ARRAYSLICE Function

Circular Reference Error in Primary Field

Re: Custom coloring of table tabs

Re: Lookups, Rollups, and Formulas producing comma after unique values

Re: Formula to look for scheduling conflict

Re: Mutually Exclusive Conditions?

Re: ARRAYSLICE Function