Api Whastapp: Format Number

Eschiantarelli · 01-05-2023 08:41 AM

How can I give accounting format to the variables [USD] and [PEN] in this code?

"https://api.whatsapp.com/send?phone="&[TELEFONO]&"&text="&ENCODEURL

(

"
"&[_THISROW].[CLIENTE]&"
```No de Operación: "&[_THISROW].[PKID]&"```
```Fecha: "&[_THISROW].[FECHA]&"```
```Hora: "&[_THISROW].[HORA]&"```
```Tipo de Operación: "&[_THISROW].[TIPO DE OPERACION]&"```
Monto USD: *"&[_THISROW].[USD]&"*
Tipo de Cambio: *"&[_THISROW].[FX]&"*
Monto PEN: *"&[_THISROW].[PEN]&"*
"
)

Este es mi resultado:

No de Operación: ad740401
Fecha: 01/05/2023
Hora: 11:33:37
Tipo de Operación: COMPRA
Monto USD: 2050
Tipo de Cambio: 3.825
Monto PEN: 7841.25

I need USD 2,050.00 and S/. 7,841.25

Thanks

dbaum

Consider configuring those columns to use the Price data type in the first place. Beyond or instead of that, you likely need to use Text expressions to accomplish your goal. For example:

CONCATENATE("USD ", [_THISROW].[USD])

dbaum

See also the Use accounting format app-level data format setting.

Eschiantarelli

Dear dbaum,

If I have that option enabled, the issue is that when the message is delivered on WhatsApp, it loses all formatting.