Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Automation for updating date

Solved
Jump to Solution
774 2
cancel
Showing results for 
Search instead for 
Did you mean: 
FPX
7 - App Architect
7 - App Architect

Hi all

I have an Orders Table and an Order Line Items table.

I have a Date Required field within the Orders Table which is linked to my Order Line Items table.

I want to have an Updated ETD (estimated time of departure) field against each line item so it is separate from affecting the overall order ETD (i.e. each line item with one order can have a different ETD).

Ideally I want to just show the format as mmm-yy (i.e. July-24)

Any ideas on automating this so that the Updated ETD takes the Date Required data but can be editable?

FPX_0-1722225990888.png

 

Thanks!

1 Solution

Accepted Solutions
FPX
7 - App Architect
7 - App Architect

Thanks. Doesnt need to be a formula.

I am just trying to create an automation that will pull the date from master orders table but allow overriding for each line items updated ETD (if required)

See Solution in Thread

2 Replies 2

Hello @FPX ,
The formula field is not editable. but you can use formatting option while creating that formula.
For example

DATETIME_FORMAT({your_field}, "MMM-YY")
FPX
7 - App Architect
7 - App Architect

Thanks. Doesnt need to be a formula.

I am just trying to create an automation that will pull the date from master orders table but allow overriding for each line items updated ETD (if required)