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.
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...
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:
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.
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...
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’.
Formatting: Turn off time, don’t need it.
Create a new automation:
Trigger: When a record ...
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.
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...
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...