How to randomize a font in a field by calc. One of many fonts on the system.

[hartmut]

Hi All,

I am trying to export a filemaker file with many records of people but I want to use it to create a nice video back ground.    

 

for example the final text file needs to look like this. But it can be created in a text field in filemaker and used from there 

Lets say I am using names of basketball teams for the sake of simplicity I am repeating 5 records.....

 

I would like a text field to use the found set I select and turn it into a graphic page in a text field in filemaker

This would be to use different colors and fonts.   

like this

 

 

Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats • Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats • Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •Dallas Baptist University Patriots • Shepherd University Rams • Villanova University Wildcats •  Fresno State Bulldogs • Montana State University Bobcats •

 

 

So I would use all my records in a found set

make a random order.

Export to a field ( each record)  I think to a global field for the text 

Randomize the style and font

Create a large text field layout that could be copied to a graphic document

 

WHAT I AM REALLY CONCERNED WITH IS HOW TO RANDOMIZE THE FONT FROM A LIST. I AM NOT SURE HOW TO DO THIS

I NEED HELP ONLY TO RANDOMIZE A FONT FROM A LIST OF FONT NAMES ON MY SYSTEM

Thanks

 

[comment]

I NEED HELP ONLY TO RANDOMIZE A FONT FROM A LIST OF FONT NAMES ON MY SYSTEM

 

That's not possible to do directly, because the calculation engine has no access to the names of the fonts installed on your system. However, you could define a custom value list of the font names, and select a random value from that list this way =

Let ( [
fontNames = ValueListItems ( Get (FileName) ; "MyFonts" ) ;
fontName = GetValue ( fontNames ; Int ( Random * ValueCount ( fontNames ) ) + 1 )
] ;
TextFont ( "some text" ; fontName )
)

[hartmut]

Thank you so much. That works like a charm and my job is underway and It is good.

YOur incredible.

Thanks