Bulk import images

After hours of reading and testing, I am still no nearer so am forced to ask.

Using the Mac app, I want to import a (local, i.e. on the Mac) folder full of images into a simple table with an image field and a text field. Currently for each record, the image field [image] is empty and the text field [imPath] holds the absolute path to an actual image file. The paths are correct and any way I test this gets to the correct image.

Simple question. Can someone please explain how to coerce Ninox into performing this simple task.

Using 'Bulk Edit' for the table, I've tried setting the image field to the path field (one method I have read that is supposed to work). Nope.

I tried to use 'Bulk Edit' and import file() to place the image in the image field, but Ninox told me that process "cannot modify data", which is rather bizarre as surely this is precisely what 'Bulk Edit' is supposed to do.

I also tried a button that iterates through the table and uses import file():-

for p in select Photos do
    p.(image := importFile(p, p.imPath))
end

In each case text(image) reveals the correct filename, preceded by the folder letters it uses and the Id, i.e. how Ninox normally does it. But the folder it is supposed to be using has not been created. In fact nothing has been created in Ninox's 'files' folder where all images should be stored and no images are displayed in Ninox. So nothing is actually imported.

It does iterate through the table correctly. If I start with the image field empty, the button procedure above sets the image field for each record and a generic icon with question mark is displayed for each record as it is updated - just not with the correct data.

What I cannot determine is the format for the path that Ninox can use. I have tried a straightforward absolute path, beginning with '/' etc ( completely correct to each file) and also a 'file:///…' URL but neither works.

So, would really appreciate some explanation of how to make Ninox bulk import image files into a table. I simply cannot fathom what it needs.