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.

 new-row-formula01.png

Table definition

 new-row-formula02.png

New row formula

 new-row-formula03.png

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

0 Comments

Article is closed for comments.
Powered by Zendesk