April 2, 201114 yr My situation is: I have blank form, and I need to put each letter from Last Name or other to each cell in a blank form. So, FM11 doesn't have text spacing. How I can do this? Maybe I need to make another fields with calculation and paste spaces between letters? If it's the best way, please say how to this calculation. And another way that I think is make fields for each cell and make calculation for these fields equally each letter of LastName. So and I have dates that i need to put it over cels like -date dd month mm year yyyy. How make it? I really need it. If you have another advices I'll be glad see it. Please, help. P.S. I put blank form, it help you imagine what I need.
April 2, 201114 yr Try a repeating calculation field = Middle ( Extend ( YourField ) ; Get ( CalculationRepetitionNumber ) ; 1 )
April 5, 201114 yr Author Try a repeating calculation field = Middle ( Extend ( YourField ) ; Get ( CalculationRepetitionNumber ) ; 1 ) Thanks, it helps, but I do not like that i need to create a lot of additional fields.
April 5, 201114 yr I believe you could make it all in one field - something like: Let ( [ w = 25 ; pad = Substitute ( 10^w - 1 ; "9" ; " " ) ; text = Left ( Extend ( Name ) & pad ; w ) & Left ( Extend ( StreetAddress ) & pad ; w ) & Left ( Extend ( City ) & pad ; w ) & ... ] ; Middle ( text ; Get ( CalculationRepetitionNumber ) ; 1 ) )
April 6, 201114 yr Author I believe you could make it all in one field - something like: Let ( [ w = 25 ; pad = Substitute ( 10^w - 1 ; "9" ; " " ) ; text = Left ( Extend ( Name ) & pad ; w ) & Left ( Extend ( StreetAddress ) & pad ; w ) & Left ( Extend ( City ) & pad ; w ) & ... ] ; Middle ( text ; Get ( CalculationRepetitionNumber ) ; 1 ) ) Excellent, Thank you, Consultant. You are my hero)
April 6, 201114 yr There is a usability problem with the sender naming on the posts, because the poster name is in the grey "title bar" of the message while the "tag" (for want of a better word) appears prominently under the avatar image where the user name would be expected.
Create an account or sign in to comment