How do I...?

← How-to questions

Change a Status field to Active in a table if the Inception Date filled is equal to the Inception Date

Hi Team,

I want to automatically update the drop down Status Field in my table to Active once the Inception date field is equal to the date in the inception date field. Can you please let m eknow if this is doable if yes can you please confirm how?

Thanks!
Bhawana Pandey

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Bhawana Pandey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Caroline Stuhr commented  ·   ·  Flag as inappropriate

    Hi there!

    Thanks for reaching out and I hope you had a nice weekend!

    You are able to do this with an app script, however it sounds like you'd be better off changing the status field to a 'Calculated Text' field with a formula instead (ie if xxx dates are equal, then set to "Active"). Feel free to send an email to Support with additional details (table names, field names, etc.) if you need any further assistance with this.

    Best,

    Caroline

How-to questions: table relationships

Categories

Feedback and Knowledge Base

(thinking…)