Nigel, appreciate your intervention on the weekend.
When I make a call, here is the response, with a string (ācountā: ā3ā) instead of an ideal number (ācountā: 3):
{
"id": 1,
"order": "1.00000000000000000000",
"category": "Stay",
"price": "149",
"currency": "EUR",
"country": "Germany",
"count": "3"
}
Iām using two no code tools: Flutter Flow and AppGyver and two DBs: Firebase and yours, depending on the data I want to fetch.
I use these types of formulas to process the data:
"("+SUM_BY_KEY(data.getCounters[0].stay, "count") + " options)"
GROUP(SORT_BY_KEY(FLATTEN(MAP(SELECT(data.ProvidersDB, item.currency == appVars.userCurrency), item.services)),"price"), item.price, {price: key +" ("+ COUNT(items)+")"})
For example, Firebase returns the desired array of objects with number types in the value, like:
[{"price":"149eur", "count": 1},{"price":"129eur", "count": 3},{...}]
Whereas Baserow returns:
[{"price":"149eur", "count": "1"},{"price":"129eur", "count": "3"},{...}]]
Iām simplifying here for the sake of quick understanding. Iām not asking you to figure out the right mapping function, itās not going to work and I donāt want an overly complexe formula when fetching data from Baserow, when a similar fetch needs a short formula for Firebase.
Not sure what field type per se I need, I know the result I want from the API call response, this: ācountā: 3 instead of that: ācountā: ā3ā
Thanks