Can the Layout Field's formats be transferred in the calculated message of a email sending script

[Pierre Bergeron]

Forgive me for my poor english language.  Also, so that I'm used to the french version of the software there are somme functions that I don't know the english name in the english versions.

I have several global fields in a specific layout called "Calculation" where I put all the fields containing datas that change year after year.  They act as variables to manage the results of multiple runs for a season ranking of the participating runners.  I need to send a personalized email to every runners at the end of the season to invite them to a celebration party.  The fields of the "Calculation" layout (all customized) have their own specific format such as date mm/dd/yyyy presented as complete date style as "Wednesday november 13 2024" or numbers with the "$" sign or other signs after the number for the rewards and other uses and hours format hh:mm that are presented as 14h30 where I replaced the ":" by "h".

So, my issue is that when I use those fields in the calculated message script, the message that is produced has  lost the field format of the original layout and become "as entered".  So the date become 11-13-2024, the rewards are single numbers (so the same for other numbers styles needed in the message)  and the hours become 14:30:00.

I'm looking for a function that allow the transfer of the original layout field's format that I put in the message without having to programming every of these one by one.  It's a long task that I want to avoid.  I tried different things, but nothing was the one for the moment.  If a newer version of FileMaker can do it (options available), I'd like to know how with the new versions.  I'm thinking about updating my old "friend".

Hope someone will be helpful.

 

Thanks !

 

[Ocean West]

I am sure someone will assist you but if you like https://lepointdarret.com/public/ you may converse in French. 

[comment]

10 hours ago, Pierre Bergeron said:

allow the transfer of the original layout field's format that I put in the message

There are several ways you could approach this. The simplest one would probably be to give your formatted fields object names and then refer to them using the GetLayoutObjectAttribute() function:

GetLayoutObjectAttribute ( "yourField" ; "content" )

Of course you need to be on the layout where these field objects are present when evaluating the calculation.

 

10 hours ago, Pierre Bergeron said:

there are somme functions that I don't know the english name in the english versions.

You can find the function in the help and then switch the language. For example, go to https://help.claris.com/en/pro-help/content/getlayoutobjectattribute.html and change the /en/ in the URL to /fr/ so that it becomes https://help.claris.com/fr/pro-help/content/getlayoutobjectattribute.html.

 

Edited November 13, 2024 by comment

[Pierre Bergeron]

Thanks for the answers.

I wrote a message at Le point d'arrêt and I got no answer for now.  Maybe the french community doesn't consider my issue as a problem needed to be solved.

I will try the getlayoutobjectattribute to see how it works.

Your help is very appreciated.

Have a good Christmas time every body.