Introducing New Expression Editor Formula: vLookup and weekNum

We're thrilled to announce two powerful new formulas in the Yeeflow expression editor: vLookup and weekNum. These formulas are designed to make data processing even more efficient and flexible, giving you greater control over how you work with data in your forms.

vLookup: Efficient Data Retrieval from Lists

The vLookup formula allows you to search for rows that contain a specified value in a column of an array object, then return either the entire row object or specific data from a chosen column. The result can be a single record or an array of matching records, making it extremely versatile for many use cases.

Syntax:

vLookup(<lookupValue>, <list>, <lookupColumn>, <matchRange>, [<returnColumn>])

lookupValue: The value used for searching. Leave blank to match all records, or set as 'Empty' to match rows where the value is empty.

list: A variable expression for the list type variable (often linked to a Sub list control).

lookupColumn: The column within the list to search.

matchRange: Define whether to match the first, all, or last matching record.

returnColumn: (Optional) Specify a column to return a value from. If not included, the entire matching row object is returned.

The vLookup formula is especially useful when working with Approval forms and Data List forms where you need to dynamically find specific information within a Sub list—for example, locating a particular value within a row or extracting a range of data from a Sub list.

weekNum: Find the Week Number of Any Date

The weekNum formula is a handy addition for working with dates. It allows you to determine the week number for any given date, using either the default or the European ISO 8601 standard for week numbering.

Syntax:

weekNum(<date>, [<useISO>])

date: The date for which you want to determine the week number.

useISO: (Optional) A boolean parameter to indicate the week numbering system. Set to true for ISO 8601, where the week containing the first Thursday is the first week of the year. If false or left blank, the week containing January 1st is considered the first week.

The weekNum formula can simplify workflows involving date calculations, allowing for easy identification of week-specific data, whether you're managing schedules, tracking weekly performance, or organizing activities.

Start Using These New Formulas Today!

These new tools make it easier than ever to extract, process, and use data within Yeeflow. Whether you're trying to match specific records in a Sub list or pinpoint the exact week of a date, vLookup and weekNum are here to streamline your work and boost your efficiency.

Ready to explore these new formulas? Head over to your expression editor in Yeeflow and start experimenting today!

If you have any questions or would like to share how these formulas have helped you, feel free to reach out. We're always excited to hear your feedback!