Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

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 Transpower Corporation http://www.transpowercorp.com

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

// SetCell ( matrix ; row ; column ; value ) // Substitutes value for element in specified row and column; SetCell is the dual of The Shadow's GetCell Custom Matrix Function // By Ronald W. Satz // 11-02-2004 Let ( [ matrix1d = Substitute ( matrix ; "¶" ; "|" ) ; // replace row end with pipe to change matrix to 1-dimensional matrixvert = Substitute ( matrix1d ; ";" ; "¶" ) ; // make vertical tot_rows = 1 + PatternCount ( matrix ; "¶" ) ; // total rows tot_values = ValueCount ( matrixvert ) ; // total number of elements in matrix tot_cols = tot_values / tot_rows ;// total columns in matrix elementnumber = column + ( row - 1) * tot_cols ; // array element to replace part1 = If (column > 1 or row = 1 ; MiddleValues ( matrixvert ; 1 ; elementnumber - 1 ) ; MiddleValues ( matrixvert ; 1 ; elementnumber - 1 ) & "|") ; // elements before the array element part2 = MiddleValues ( matrixvert ; elementnumber + 1 ; tot_values ) ; // elements after the array element matrixvertnew = part1 & value & ";" & part2 ; // new array matrixnew1 = Substitute ( matrixvertnew ; "¶" ; ";" ) ; // forming the rows again matrixnew2 = Substitute ( matrixnew1 ; "|" ; "¶" ) // getting the matrix back ] ; Case ( row > tot_rows or column > tot_cols or row < 1 or column < 1 ; matrix ; matrixnew2) // results ) // Let Comments, criticism welcome. -------------------- Transpower (www.transpowercorp.com) Click to copy

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, Lombardi 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 20 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: