0
Help to figuring out work around for MacOS app
Hi all -
For those with access to the MacOS app and a cloud subscription. Upload the attached DB to your cloud account and as a local DB.
With the MacOS app:
Start with the cloud DB. Open the DB and open the Dashboard table you will see:
Now switch to the local stored DB and you will see:
Here is the code for the formula field:
let step1 := (select Table1);
let step2 := unique(step1.Number);
let step3 := for loop1 in step2 do
{
recId: loop1,
recCnt: count(step1[Number = loop1])
}
end;
let step4 := max(step3.recCnt);
let step5 := step3[recCnt = step4];
step5.recId
I've created a json in a variable to create a mini table. It seems like the cloud version can process the json properly, but the locally stored DB can't.
Since I haven't worked with json before I'm at a lost to how to convert it back into an array of recId.
Thanks in advance.
Reply
Content aside
- 1 yr agoLast active
- 43Views
-
1
Following