Level 3

Valueformat - Single reference for all available options

Forum|Forum|2 years ago
February 26, 2024
2 replies
1970 views

I write custom code into text mode all of the time, but I frequently find myself guessing and playing "cat and mouse" with the valueformat. I usually have to try several different possible options to put into that field before the report returns something meaningful. Is there not a singular reference somewhere that lists out all of the different options for valueformat and their respective restrictions/applications? I feel like this should be somewhere in the documentation, or even the community, but I have been unable to find any such resource. Knowing what options and limitations there are would save me a ton of time just trying to get a report up and running.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

skyehansen

If you do a search on AEL, I think the top three results are about the extent of what documentation is available. e.g.

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=valueformat&sort=relevancy&f:@el_contenttype=[Documentation]

C

Cameron_WardAuthor

Level 3

Thank you very much! This is very helpful. However, most of what I work with is hours. This documentation does not show how to handle hours, but I can see in text mode from default fields that such formatting options do exist. For example, minutesToHoursString is a common one. But that does not seem to work with a custom field. Is there anything more than this out there?

skyehansen

I'm not sure if I heard everything you said, correctly.

I think if something isn't working as expected, you should submit a case to the support team.

Having said that, I can definitely see that hours formatting might not work because that's not a type you can assign to a custom field. i.e. if you can only tell your custom field to be a date, currency, numbers, or simple text -- not hours -- then you might of course also not be able to format a specific type of hour formatting. (Other users get around this by recalculating their number manually to be hours rather than minutes.)