Moving images from one table to another solved

Dear all,

have after reading a lot about this problem in the forum, reached out to support, and done a lot of trial and error. I have now found a solution which works, and I write this post partly to help others and partly to urge Ninox development to create a command which can do this trick, as when I am able to this - it must also be possible within the Ninox environment.

Case was that I had a linked child table with photos, and the parent table with member information and the photo was linked in the main form. For some reason the customer wanted to have the photo field in the parent table and then delete  the child table.

I tried a lot, and primary ended up creating a formula field in the parent which said :

let xCurrRec := Id;
let i := first(select Foto where medlemmer = xCurrRec and 'Primært Foto');
i.Billede

(Foto is the child, and 'Primært Foto' is the new field in the parent)

I tried still a lot but had an aha moment when I dowloaded the archive to my Mac and work with it in the Mac app, and I discovered that I could drag and drop from the formula field to a newly created image field in the parent - which you cannot do in the cloud, so the solution was now :

1) set the picture in to a formula field in the table where the photo must end up (the destination table)

2) create an image field in the destination table

3) download the archive to a mac

4) make an automation with apple script or in my case with Keyboard Maestro where you drag and drop from the formula field to the image field

5) upload the archive to the cloud again - and you are in business

So when this can be done this way, I can imagine that it also could be done via a command in Ninox or perhaps a Global Function.