New row formula (Table only)

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

Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk