When a section has Allow add rows option set, new rows can be added to Table section, if so those rows can be bound to Data object.
New row formula is lookup formula that searches Data for an object that matches query criteria.
Scenario of a use: designer wants a user to add products to a products basket, the first column can be set to autocomplete with Id’s of all products and lookup formula with a query on A column. See screenshots below.
Table definition
New row formula
Resulting table
Examples of New row formula:
=LOOKUP(PRODUCT, ID=A) - search for a product with ID equal to new row A column
0 Comments