Skip to main content

Can metadata be formatted?

Comments

3 comments

  • Danielle Morley

    Hello Richard,

    The short answer is -- it depends on where you're looking to format it!

    Anywhere you're using DREL (Data Record Expression Language) -- data record naming, document filenaming, folder naming in data destinations, email subject lines and custom body, etc -- you can format dates and times (from either the metadata or a question).   There's more information here on how to do that:  https://support.prontoforms.com/entries/20759356-Data-Record-Expression-Language-DREL-

     

    If you're looking to change the date/time format on PDF/Word/HTML documents, you can also that:  https://support.prontoforms.com/entries/88593086-PDF-Word-and-HTML-Documents#DateTimeFormat

     

    If you're trying to do this somewhere else, please let me know where it is and I'll look into it.

     

     

    0
  • Richard Howell

    Danielle, I'm mostly dealing with this in the timestamp format above. It is being exported to a Google Sheets spreadsheet and my initial approach was to tackle that here and not via a script executed in the spreadsheet (which would potentially only apply to the user executing the script, not to mention the hassle). If there's a quick way to format it in Google Spreadsheets and have it hold that configuration... well then!

    I am now understanding the date format pattern syntax and options in that regard. My problem is that I don't see anywhere in the question settings or the metadata inclusion table (available >> selected boxes) where there is a DREL formatting option like there is on a Folder or Spreadsheet Name entry. 

     

    Richard

    0
  • Danielle Morley

    Ah, I see.  Richard,  you're correct in that these options are not available on the Google Sheets destination.  However, I can see how formatting the dates/times could be useful.   At the moment, it sounds like this will need to be done on the Google Sheets end of things.  

    For the future... I can suggest creating a feature request here:  https://support.prontoforms.com/forums/284828-Feature-Requests .   Please make sure to explain why the date format is important to you.   Our team looks at these when planning future development and considering which features will deliver a lot of value to our customers. 

     

    0

Please sign in to leave a comment.