Grid ( layoutWidth )

Helps with selecting the major grid spacing and minor grid steps for a given Filemaker layout and the number of columns to use.

Be the first to rate this function Log in to vote

Lazarus Sismanis - Show more from this author
Decision Group
http://www.decisiongroup.net

Sample input:

Grid ( 1200 )

Sample output:

2 600
3 400
4 300
5 240
6 200
8 150
10 120
12 100
15 80
16 75
20 60
24 50
25 48
30 40
40 30
48 25
50 24
60 20
75 16
80 15
100 12

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
* =====================================
*	Grid (  layoutWidth )
*
* PURPOSE:
*	Helps with selecting the major grid spacing and minor grid steps for a given Filemaker layout and the number of columns to use.
* 
* RETURNS: 
*	(string) value list
*
* PARAMETERS:
*	layoutWidth = The width of the layout in points
*
* EXAMPLE: 
* 	Grid ( 1200 ) =
* 
*	2	600
*	3	400
*	4	300
*	5	240
*	6	200
*	8	150
*	10	120
*	12	100
*	15	80
*	16	75
*	20	60
*	24	50
*	25	48
*	30	40
*	40	30
*	48	25
*	50	24
*	60	20
*	75	16
*	80	15
*	100	12
*
*
* DEPENDENCIES:
*	none
*
* NOTES:
*	This custom function returns all the whole values for a given layout width when divided by any number of between 2 and 120, which serves as the number of columns for the layout. Helps with selecting the major grid spacing and minor grid steps for a given Filemaker layout and the number of columns to use.
*	The first column defines the number of columns in the layout. The second column indicates the major grid that should be used in order to have that certain number of columns.
*	Inspired by Matt Petrowsky and FilemakerMagazine video 'Using FileMaker's Grid'
*
*	
* HISTORY:
*	CREATED: 2018-09-19: by Lazarus Sismanis ( lazarus@decisiongroup.net )
*	MODIFIED: 2020-06-18: By Lazarus Sismanis ( lazarus@decisiongroup.net ) - Clean up before posting to Brian Dunning's Filemaker Custom Functions
* =====================================
*/

Case (

    // Set the loop count $i

    not $i    ;
	Let ( [

			$div = "";

			//Start loop at $i and end it at $endpoint

			$i = 1;

			$endpoint = 120 

     ];
        // This is the first recursion -- the function just calls itself,
        // with the same parameter(s) that the user entered

       		 Grid ( layoutWidth )

     );

    // On the second cycle through the loop, the counter will be set to 1
    // the third cycle the counter will be set to 2, then 3 and so forth   
 
			$i < $endpoint    ;

	Let ( [

			$theWidth = Case ( 
	//	Check if we have a decimal or not value

			Int( Round( layoutWidth /$i ; 2)) =  Round( layoutWidth /$i ; 2) and  Round( layoutWidth /$i ; 2) > 0 and $i > 1 ;  $i & Char(9) & Round(layoutWidth /$i ; 2)  & "¶"; 

	//	If it's a decimal value, return nothing

			"" );

        	$div = $div & $theWidth    ;

        // The last line increments the loop counter

			$i = $i + 1

    	 ];

        // After finishing each step, we recurse again

       		 Grid ( layoutWidth )

     );

    // We have now completed the last cycle through the loop
    
			$i ≥ $endpoint    ;

	Let ( [

	// before exiting the last step, we will release all variables, so we keep memory clean)

        	$i=""

     ];

        // The last line is the value the function returns

     	   $div
     )
)

This custom function returns all the whole values for a given layout width when divided by any number of between 2 and 120, which serves as the number of columns for the layout. Helps with selecting the major grid spacing and minor grid steps for a given Filemaker layout and the number of columns to use.

The first column defines the number of columns in the layout. The second column indicates the major grid that should be used in order to have that certain number of columns.

Inspired by Matt Petrowsky and FilemakerMagazine video 'Using FileMaker's Grid'

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Grid ( layoutWidth )

Comments

Support this website.

Support this website.