GetIncrimentValue ( currentValue ; theList ; operator )

Get the next value in a list based off the current value

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

GetIncrimentValue ( "Banana" ; List ( "Apple" ; "Banana" ; "Orange" ; "+" )

Sample output:

"Orange"

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

/*
 *  CUSTOM FUNCTION
 *    GetIncrimentValue ( currentValue ; theList ; operator )
 *
 *  DESCRIPTION
 *    Get the next value in a list based off the current value
 *
 *  PARAMS
 *    currentValue: one value in the list
 *    theList: The list of objects
 *    operator: + or - to go up or down in the list
 *
 *  RETURNS
 *    Returns a list item
 *
 *  DEPENDENCIES
 *    Custom Function: ValuePosition (https://filemakerhacks.com/2011/06/12/valueposition-the-function-filemaker-forgot/)
 *
 *  CHANGELOG
 *    2020-03-04: Paul McCudden (paul@peak14.solutions): Created
*/

Let (
  [
    ~currentPosition = ValuePosition ( theList ; currentValue );
    ~min = 1;
    ~max = ValueCount ( theList );
    ~newPosition = Case (
      operator = "+" ; ~currentPosition + 1;
      operator = "-" ; ~currentPosition - 1;
      ~currentPosition
    )
  ];

  GetValue ( theList ;
    Case (
      ~newPosition > ~max ; ~min ;
      ~newPosition < ~min ; ~max ;
      ~newPosition
    )
  )

)

Simple and nice CF. Does have a dependency of ValuePosition: https://filemakerhacks.com/2011/06/12/valueposition-the-function-filemaker-forgot/

Comments

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

GetIncrimentValue ( currentValue ; theList ; operator )

Comments

Support this website.

Support this website.