Cady_Smith1 - profile

Cady_Smith1 · May 25, 2022

When you’re using apps, you can click on a bar on a chart and it’ll pop up a window that shows all the records in that particular bar. How do I do this in interfaces? Am I missing a setting? Right now charts aren’t interactive at all.

Cady_Smith1 · May 17, 2022

Is it possible to extract the color name or hex code of an option in a select field? I have this select field and I want to create a filter view that we won’t need to continuously update as we are constantly adding new categories. Everything for Mar...

Cady_Smith1 · May 04, 2022

I have a field called: Branch Name I need to extract text from it using a formula field. I’m just not sure how. Examples of data in the field: #2828 - Clarksville Branch - Clarksville, TN #4109 - Aiken Branch - Aiken, SC What I need to extract: Clark...

Cady_Smith1 · Apr 07, 2022

I have a project schedule. When I change the end date on Task 1, I want it to automatically adjust the start date for Task 2. Is this possible via an automation somehow? In the example I added, the highlighted field would become 5/5/2022.

Cady_Smith1 · Nov 05, 2020

Is it possible to have an ‘Update Record’ action add to a field instead of overwriting whatever is in there? IE: We have a request base. If the department is Training then Jane Doe needs to be tagged in the Collaborator field on the record.But if the...

Cady_Smith1 · Jul 15, 2022

Here’s how you can do it! It’s a little weird, but it should work and it’s really simple to set up. Create a new formula field called ‘Today’. Formula: TODAY() Formatting: Turn off time, don’t need it. Create a new automation: Trigger: When a record ...

Cady_Smith1 · Jul 15, 2022

Do you have an actual record where the Release Date is in the next day? The two records you’re showing aren’t. If you don’t have a record that matches the conditions of your trigger then it has nothing to test with and will throw an error.

Cady_Smith1 · May 19, 2022

That was my first thought, but the problem is the naming conventions aren’t consistent–just the color coding. This seems to be working really well so far! I just told it to filter and only show records where ‘Category Color’ is ‘pinkBright’ and as we...

Cady_Smith1 · May 17, 2022

Update: I figured this out (sort of). I created a field called ‘Category Color’. I then set up an automation to monitory the ‘Category Select Field’. Any time it changes, it will go in and update the ‘Category Color’ with the name of the color from t...

Cady_Smith1 · Apr 21, 2021

Will the box feature eventually have the ability to pull images from box into an attachment field in Airtable? I can pull everything about the image except the image itself at the moment.

User Statistics

User Activity

Click on chart to show record list in Interface

Extract Color from Select Field

What formula do I need to extract this text?

Automatically Set Start Date

Add To/Update Field instead of overwriting

Re: Reset a field in a table once a day for each records

Re: Creating a record to a base from a different base

Re: Extract Color from Select Field

Re: Extract Color from Select Field

Re: Sync multiple sources to a single table