The FileMaker Let Function: Introducing Flexibility Within Calculated Narratives On Component Level Data

Use Case Builder is a FileMaker database that allows a business analyst, project manager, subject matter expert (SME) and/or other project team members to create and store use cases. This is an open product, distributed "as is" without support but also open for customization by a FileMaker developer. 

This system allows you to ...

  • create new use case records quickly & easily
  • duplicate and modify existing use cases for emerging needs
  • copy complete use cases for integration into MS Word documentation
  • be customized to adapt to diverse requirement needs of the organization

A Use Case has multiple components and the Use Case Builder allows you to do data entry on a component level. Although it is nice to have the data entry experience accomplished on a component level, ultimately the use case needs to be consolidated into a single piece of text. The Wrap Up does just this by taking all the component information and then delivers a single piece of narrative text that can be used to get approval / feedback, update core project documentation, create test cases and facilitate technical specifications. 

Function allows you to use your own variables within the syntax of the function. It can be used to make complex calculations easier because you can reference just about anything as a variable.

The Let function can make a complex calculation easier to read. This is because you can set variables equal to calculated values and then calculate them. A calculation that is easier to read tends to be easier to troubleshoot. This is an accurate statement for calculations that leverage the Let function as well.

The Let function can also be much faster than a calculation that does not use the Let function. This is because a variable once declared within a Let function can be used within that calculation repeatedly without a recalculation.

s mentioned earlier, the Use Case Builder has multiple components and the Wrap Up feature takes all the component information and delivers a single piece of narrative text. By using the Let function, each component is defined as a variable. That makes it much easier to manage, make changes and troubleshoot (if necessary).