Skip to main content

Formulas: ThisRecord, As, and Sequence

Headshot of article author Greg Lindhorst

You can now refer to the whole record in ForAll and other record scope functions with ThisRecord.  You can even name that record with the As operator, allowing you to clarify formulas and work with all the records in nested ForAll and Gallery controls.  And finally, we’ve added Excel’s Sequence function to generate a table containing a sequence of numbers, perfect for iterating a specific number of times with ForAll.

» 阅读更多内容

Faster data entry with the SetFocus function

Headshot of article author Greg Lindhorst

Welcome the SetFocus function to Canvas apps!  You’ve got data to enter.  Get it done fast by having the app position the cursor in the input field where we should begin.  And when you go to validate, the app can take you directly to the offending entry, even if it scrolled off screen.

» 阅读更多内容

Simplify formulas with the With function

Headshot of article author Greg Lindhorst

Welcome the With function to Canvas apps!  You can now simplify large formulas by dividing them into named sub-formulas, eliminate redundant sub-formulas, and easily work with functions that return records.  All while staying declarative and automatically responding to dependency changes.

» 阅读更多内容