BUG. Different mobile and desktop behaviors. App Formula

[eangelc]

I think this could be a bug, I don't understand how it is possible.

The "Subtotal" field is calculated using the following formula:
SUM(
SELECT(PVPagoAdicionalesDetallesServ[ValorUnitarioServicio],[IDPagoAdicional]=[_THISROW].[IDPagoAdicional])
)

Every time I add an item, the subtotal should increase.

If the formula is set to "App Formula" there is no problem, it actually works on both devices.

The strange thing is that when the formula is set as the initial value, it only works for the desktop version. It does not work for the mobile version.

It is somewhat worrying to think that the behavior in the mobile version is not exactly the same as in the desktop version.

Mobile appDesktop app

[Aurelien]

Hi @eangelc 

This is an unusual situation indeed, looks like a bug.

You may want to fill a ticket here: https://support.google.com/appsheet/gethelp

Another thing, if I may:

If [IDPagoAdicional] is a Ref column from table PVPagoAdicionalesDetallesServ that refers to your current table, I would suggest a slight improvement to your expression, to make it more efficient:

SUM([Related PVPagoAdicionalesDetallesServs][ValorUnitarioServicio])

[eangelc]

Hi @Aurelien 

I didn't know I could use that expression you suggested. It's excellent. Thank you very much.

I have been in communication with the support team, however, there is still no clear solution.

They tell me "The app formula is calculated right before saving the record and will appear as expected, but the initial value might not always be visible on the form. " I'm really not at ease with the answer. It sounds like something random.

[Steve]

---

@eangelc wrote:

"The app formula is calculated right before saving the record and will appear as expected, but the initial value might not always be visible on the form. " 

---

Be advised that most of the Support techs I've dealt with are woefully ignorant about AppSheet. Their statement above is entirely bogus.

That said, nested forms are broken and always have been. Best to avoid them.

[Aurelien]

Hi @eangelc 

---

@eangelc wrote:

They tell me "The app formula is calculated right before saving the record and will appear as expected, but the initial value might not always be visible on the form. " I'm really not at ease with the answer. It sounds like something random.

---

There can't be no "might" in the AppSheet behavior. It works, or it doesn't, and more specifically the behavior needs to be the same when it's come to comparing mobile and desktop versions.

You may want to insist that it's a bug that needs to be solved 🙂