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

null

Content aside

  • 10 mths agoLast active
  • 36Views
  • 1 Following