![]() ThisItem and ThisRecord are great, but they only make the innermost record available. ThisRecord can be used with far more than just ForAll, it is available in any function that provides a record scope, include Filter, LookUp, With, Sum, Sort, Concat, and many others. Without ThisRecord, it would be impossible to Collect the whole record at once, instead each field would need to be referenced individually. The key formula in the animation is: ForAll( Filter( Gallery1.AllItems, Checkbox1.Value ), Here we have a gallery of products that we’d like to copy into a collection of products for this order. We didn’t call it ThisItem because we don’t refer to records as items except in the gallery and form controls and we also wanted to make it easy to use record scope functions in a gallery without needing to name them. And that is what we have added with ThisRecord. What is missing is the equivalent of the Gallery control’s ThisItem. Have you tried to use Patch or Collect within a ForAll? You quickly realize that while all the fields of the current record are readily available, the record itself is not and you need the record for Patch and other operations. Full documentation is being reviewed and will be posted shortly. There is a bug fix required to do the chessboard example with galleries that is coming in 3.20072. 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.Īll of this is available with version 3.20065 or later. 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. You can now refer to the whole record in ForAll and other record scope functions with ThisRecord. Happy Monday! It’s a great day for ForAll!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |