If(Value(DataCardValue5.Text) > Value(DataCardValue13.Text),0,Value(DataCardValue13.Text) - Value(DataCardValue5.Text))
Sum(
DataCardValue36.Text,
DataCardValue37.Text,
DataCardValue38.Text,
DataCardValue39.Text,
DataCardValue40.Text)
If(Value(DataCardValue5.Text) > Value(DataCardValue13.Text),0,Value(DataCardValue13.Text) - Value(DataCardValue5.Text))
Sum(
DataCardValue36.Text,
DataCardValue37.Text,
DataCardValue38.Text,
DataCardValue39.Text,
DataCardValue40.Text)
SubmitForm(FormInspection);
Notify ("Please make sure all fields are filled in correctly ",NotificationType.Error,3000)
If(
IsBlank(DataCardValue5.Text),
Set(gblvar_Sum,
Sum(
DataCardValue36.Text,
DataCardValue37.Text,
DataCardValue38.Text,
DataCardValue39.Text,
DataCardValue40.Text));
.....Logic to Save using gblvar_Sum.....,
.....Logic to Save without using gblvar_Sum.....
)
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.