virtual column image in a form view

[Cannone_Cannone]

Hello everyone little problem,
I need to add a static image in a form view, as it was suggested I wanted to create a virtual column.
The image is not found in the form table, but in another table so structured.
"id" column "Controls" column "IMAGE" column.
My Form view has four submenus for control check maintenance.
When I am in the "Check Tires" form, I would like you to show me the static example image.
The table as I said where the image is is another,
id 1 \ Pneumatic Controls \ and in the image column I have the address where the image resides - Checklist_image \ tires.png
Thank you all

[TeeSee1]

Try below

For each subsection of your form, create a virtual column with the formula

LOOKUP("CONTROL NAME for the submenu", "Table name containing the images", [Controls],[IMAGE])

This formula should set the type of your virtual columns to image automatically and show the images attached in the image table in your Check Tires form.

I hope this helps!

[Cannone_Cannone]

Thanks a lot!  i tried but doesnt work

[TeeSee1]

Hi I believe this is what you looking for.

I have an "images" table where you maintain your control field and image

A "main" table where you enter data with one page per your control showing the associated image stored/maintained in the image table.

I have created a snippet app with two controls - C1 and C2.

Hope this helps in some way...

[Cannone_Cannone]

thank a lot was what im looking foor

[Cannone_Cannone]

Excuse me just one last thing.
In the Form view of images, I would like to show more images for the medium.
Having a table with column "image1," image2 ", etc. do I have to create a column for each image ?.
A thousand thanks

[TeeSee1]

My quick attempts to use an enum and a child images table both failed...

So no immediate idea but as you say, you need to create more cols, which I do not like very much.

Maybe others can suggest something better.

[Cannone_Cannone]

Thanks a lot ,I hope that someone help me!!

[TeeSee1 · Accepted solution]

Do not know what I wad doing wrong exactly before but after I went thru this Q&A I was able to do it...

I used a child image table with the control table as its parent.

Just a few comments here.

1) Since this seems to have to be a physical column of ENUMLIST type, it is clickable and a big check mark is displayed when you do so.

2) The images are smaller

Something you should consider.

Good luck.

[Cannone_Cannone]

Hello!!! I tried but I didn't understand how you did it !!!🙄

[TeeSee1]

I had updated the previous snippet so you can take a look at inside it.

Instead of paging I used the show if the setting of the fields.

The images field is exactly what was in the q&a post that I attached. But you need to filter it in the valid if setting tied with the control field mentioned above.

[Cannone_Cannone]

Thanks a lot!!! i will try