[Calculation] - As a form builder, I would like to perform mathematical operations using values from a data provider, so that I can use external data as part of a mathematical expression in my form.

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Discarded
• Affects Version/s: None
• Fix Version/s: None
• Component/s: Forms
• Labels:
  • boa
  • calculation
  • ux_done
• Epic Link: Form Rules

Goal:

• Perform calculations in a form, using as part of a mathematical expression, values from a data provider.

Users:

• Form Builder

Benefits:

• Updated values from data providers being used as part of mathematical expressions (common example of data that is constantly updated is currency exchange rates), that brings the benefit of the form builder to use only updated values;
• Lower the risk of using outdated values;
• Save time on building formulas that need constant value update.

User Story:

As a form builder, I would like to perform mathematical operations using values from a data provider, so that I can use external data as part of a mathematical expression in my form.

DOD:

1. The form builder should be able to assign a value from a data provider as part of a mathematical expression;
2. Prevent what happens if the data provider is unable to reach.

Use Case:

• As a admin analyst, I would like to use Liferay Forms to build a reimbursement app, so that I can perform calculations, currency conversions and establish expenditure limits.

For this use case, the form builder should implement a mathematical expression that will consider a currency rate that updates according to the day the form is being filled and submitted.

Product Design references:

• Zeplin: https://zpl.io/ZhGYF6
• Invision: https://liferay.invisionapp.com/share/C5AVMQMXQ