Importing Image Files

https://ninoxdb.de/en/manual/import-and-export/import-attachments

Regards

Leo

I am not a developer, only a user. As far as I know, there is only one way to perform the file import. I suppose you've got it. The pictures are now in Ninox as an attachment.

1. Create a textfed Filename
2. Create a list in Excel (Ninox ID, Filename)
3. Import this list to Ninox, leaving Ninox ID as the key
4. with Update multiple records you can now assign calculate value:

---

Image := Filename

---

Regards

Leo

 I am trying to update an image feel using the parameters from a number field Using logic formula. Here is the formula that I am using but the only thing that it is putting into the image file is a text string. I do know that I have the image file represent it as a text  string  but is the only way that I have been able to put it in that  it does not come back as an error.  Below is the code I have written. If anyone knows how to represent an image correctly so that it’s at places  it in the image Field that would be great. 

if 'Tomatoe Rating' <= 59 then
Image := "A7/Splat.jpg"
else
if 'Tomatoe Rating' >= 60 and 'Tomatoe Rating' <= 79 then
Image := "A7/Fresh.jpg"
else
if 'Tomatoe Rating' >= 80 then
Image := "A7/CertifiedFresh.jpg"
end
end
end

 I forgot to mention a7/is the directory that was returned when I used the raw function. 

 Thanks in advance 

R Michael Walker

Hi Michael,

you can display images only if they are attached to the record. If you attach the three files to all records this would work.

Attached images are displayed in the image field if it contains the file name. This could be done via a trigger and your formula. But it will be only displayed if you have attached the image file.

Another method would be to display the image in a formula. There each record should be linked to another table and record where the images are attached.

Let me know if this helps.

Best regards, Alex

 So another words, I could set up a table named tomatoes ratings images and have and it only the field with images in it  named TImage. It would only have three records in it. One for each of the images that I want to use.  Then all I would have to do as reference the particular record ID  of that particular image I wish to display, in  The formula that are used in the  table that I want the image to display in. I of course would have to say for instance; Image := ‘tomatoes ratings’.

TImage

Sorry about the two different postings, I accidentally hit the post button before I was finished. Anyway Am I understanding your suggestion correctly?

Hi Michael,

Your Images are all attached?
try your formula without "A7", so:

if 'Tomatoe Rating' <= 59 then
Image := "Splat.jpg"
else
if 'Tomatoe Rating' >= 60 and 'Tomatoe Rating' <= 79 then
Image := "Fresh.jpg"
else
if 'Tomatoe Rating' >= 80 then
Image := "CertifiedFresh.jpg"
end
end
end

---

Regards

Leo