Support merge syntax for date and datetime fields in AF Update a field on row

  • 3
  • Idea
  • Updated 1 month ago
Currently, when using the action framework "Update a field on row(s)", the value for date and datetime fields are restricted to built-in functions.

Would like to see the ability to be able to specify merge syntax so that values from other models/rows can be used to update the field in the target model.  Merge syntax is supported with other data types (e.g. text) but not date and datetime.
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,076 Points 10k badge 2x thumb

Posted 3 years ago

  • 3
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
This has been previously identiifed as a good idea.  Wherever we show a date field in conditions or selection we should allow merge syntax. 
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Barry--

Had this issue before myself. You can work around it by writing the merge syntax directly into the XML.
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,076 Points 10k badge 2x thumb
Thanks Matt!
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Another, easier workaround on this since it's been two years...

Before you select you date field, fill in the merge syntax for the "single specified value." Then if you select your date field and don't touch the date selection options, you'll be good to go.
Photo of Greg Jarrett

Greg Jarrett

  • 3,496 Points 3k badge 2x thumb
that comment just came in very handy for me Matt. Thanks.
Photo of Bill Fox

Bill Fox

  • 7,874 Points 5k badge 2x thumb
Yes. It does work.  Since its been 3 years and I am sure we are not the only ones with this issue.  Can we get this on road map?
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb