Brian Dunning's FileMaker Custom Functions

SetCell ( matrix ; row ; column ; value )

Sets matrix element at row, column to value

  Average rating: 3.9 (37 votes) Log in to vote

Ronald W. Satz   Ronald W. Satz
Transpower Corporation
http://www.transpowercorp.com

Share on Facebook Share on Twitter

  Sample input:
SetCell ( A ; 1 ; 3 ; 100)
  Sample output:
first row, third column of matrix A now has 100

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

This is the dual function to The Shadow's GetCell custom matrix function. FileMaker does not have built-in matrix functions, so have to make our own custom functions.

 

Comments

Antonio   Antonio, Brazil
Aug 23, 2013
Hi,
I am newbie to Fm.
I a table of values to use in a Profit Loss statement.
This tables has category, value and month.
I would like to meke PL report with Category as rows and month as colum, and values as slots.
I tried to make a Script, but it was too big, with more than 600 slots.
A Matrix report would be great.
Does this function do the job?
Thanks
Antonio
Altsouza@terra.com.br
 

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.