This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
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...
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...
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...
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...
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...
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' ))
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).
I'm very, very late to the party, but you could use REGEX_REPLACE, something like this for your "Missing Items" field. It'll be text though, and not record links.REGEXREPLACE(ARRAYJOIN({Items Needed},", "),ARRAYJOIN("(?:"&{Items Owned}&"(?:, )?)","|"...
