Answered

Automated Change

(0) Share

Report

Posted on by Community Power Pla...

Hey Guys,

I have a drop down column called 'Tour Status' that only shows "Pending or Completed" with a default set to Pending. I would like help setting up some type of command that will check the current date. Any date greater then the current date such as "5/17/2022 or higher" will automatically change the drop down to "Completed" and change the color to red. Appreciate your assistance.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

iltoningui 247 on at

Like (0)

Report
Copy link

Link copied!

Hi! @Anonymous

1. You should update the choices to include one that represents expired (red)

2. Create a recurrence trigger I used 1 hour

3. Get all items that are expired and their status is pending (You may need to include the time, I only used the date)

the formula contains utcNow('yyyy-MM-dd')

4. Use the apply to each to update any record retrieved from the get items

If this help consider marking it as a solution.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

That was what I needed.. .THANK YOU SOO MUCH!!

Was this reply helpful? Yes No