Answered

Calculation and Edit the fields

(0) Share

Report

Posted on by DBTS7

Hi,

I'm developing a Cost estimation application in which after clicking on edit icon user able to navigate next calculate screen for edit and calculate the items.

the below is the edit screen:

on OnSelect of edit icon i'm giving a varialble : (Set, varEdit, true); Set(isSelected, thisItem);

Then after navigating to next screen (as given below):

All data from edit screen will be visible here for this I'm using: If(varEdit, isSelected.SafetyTotal) => for calling safety total data.

So here while editng it is working fine.

The problem is I'm not getting how to show calculations which user do on Calculation page?

like I'm setting this on label text "If(varEdit, isSelected.SafetyTotal)" so it'll only show the edit gallery data.

But while clicking on calculation button how I'll show the SafetyTotal?

Kindly reply if know the solution.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

This is a bit confusing. You say it works fine while editing but you can't show the result of your edits? Are you saving your changes back to the datasource?

Maybe including some additional screenshots and details about your data model will help understant your issue.

Was this reply helpful? Yes No
Sumaira_Noor 18 on at

Like (0)

Report

@DBTS7 Use GalleryName.Selected.SafetyTotal to calculate formula and please share if it worked or not

Was this reply helpful? Yes No
DBTS7 on at

Like (0)

Report

Hi @jcfDaniel , thanks for replying,
So I'm using save button for patching the data into DB and Calculate button for the calculation on same page like above.
but in total field how I'll show the data from a gallery and also the calculated data after clicking on calculate button? Like only one can be possible, right? whether I can show the edited data or the calculated data(after click on calculate button).

Was this reply helpful? Yes No
Verified answer

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

I guess you can use a condition in the total's label default property. Set a variable when pressing calculate Set(varCalc, true) and then do an If in the label If( varCalc = true, Calculation, ValueInDB ) but it may not be the best solution.

If your calculate button does also the patch your total value should get updated, otherwise it may be best to include another label to show the calculated value, so you would have one for the stored value and another for the one being calculated. You could even manipulate the display property of the Save button to allow pacthing only if stored value <> new value.

Was this reply helpful? Yes No