Hey guys I've made an app to bassicaly be a ...

Alvaro_Mascaro · 06-26-2018 05:00 PM

Hey guys

I’ve made an app to bassicaly be a form to input data into a spread sheet and then share the detailed view via WhatsApp

All working good so far however I have 2 issues

I created a couple of virtual columns which are running some expressions. To display a % it seems when I look at the detailed view of the entry these are not computing correctly. But when I go to edit the entry it computes fine in the edit screen.

The other issue is when I share the detailed screen via what’s app it formats it exactly how I want , however the virtual column values I made display as decimals and not % like I have in the app. Can you customise this ?

Aleksi_Alkio

#1 - When you calculate the % value, is your formula reading values from another record or from other table and is it in a normal column? If yes, then your formula is probably working correctly. When you want to calculate something dynamically, you need to do it in the virtual column. The app formula in a normal column will be calculated only, when you edit the record.

Alvaro_Mascaro

Hi Aleksi, thanks for your response. I am having the calculations done in the virtual columns , using data from normal columns to compute (I only have one table of data). I can see in the form section the virtual columns compute correctly. However when I go back in to see the form entry “detail view” they are not computing correctly

Aleksi_Alkio

May I ask what is the formula you are using?

Lynn

Hi, What does your “Detail view” show?

Alvaro_Mascaro

Hi guys

Formula I’m using is [FX]/([cn]+[da]) these are obviously columns in the table .

The detailed view just shows a read only of the form.entry

Aleksi_Alkio

What are these two results? Can you show us what values you are using and results, thanks.

Alvaro_Mascaro

As you can see in how screen shot this is the detailed view and it’s not computing correctly the FX attachment however on the spread sheet it is.

Alvaro_Mascaro

And in the edit screen it is aswell

Aleksi_Alkio

Try 100.0*[FX]/([cn]+[da])