J.Aspect Posted September 7, 2021 Share Posted September 7, 2021 I was wondering if anyone has created a plant schedule that will also include an image of the species. I've been trying to attach an image to the plant data under 'Image Detail'. With both the functions 'Import an External File' or 'Image Resource'(after importing the image into the working VW file. Then I tried inserting column into the schedule with the database header >> ='Plant record'.'Image Detail' << However the result that comes up is <image> and doesn't actually show the image that is attached to that specific plant data set. I've even tried inserting the following functions without any success=IMAGE(='Plant record'.'Image Detail') >> RESULTS: =IMAGE(='Plant record'.'Image Detail')=IMAGE(S='Plant record'.'Image Detail') >> RESULTS: False =IMAGE('Image Detail') >> RESULTS: Custom Image ='Image Detail' Quote Link to comment
Jeff Prince Posted September 7, 2021 Share Posted September 7, 2021 =PLANTIMAGE(2) This will give you the detail image. 2 Quote Link to comment
Jack2022 Posted July 7, 2023 Share Posted July 7, 2023 Hi Jeff, I have tried this and I still get a blank cell. Anything else need doing? I have added a jpeg image to every image field in the plant and tried to make a grid of plants images 1 Quote Link to comment
Pat Stanford Posted July 7, 2023 Share Posted July 7, 2023 Your formula is incorrect. There should not be a left parenthesis after the equals sign. Correct should be =PLANTIMAGE(2) Quote Link to comment
Jack2022 Posted July 9, 2023 Share Posted July 9, 2023 thanks Pat - I noticed this after I posted and have tried without the left parenthesis too. still no luck Quote Link to comment
Jeff Prince Posted July 9, 2023 Share Posted July 9, 2023 3 hours ago, Jack2022 said: thanks Pat - I noticed this after I posted and have tried without the left parenthesis too. still no luck post your file and someone will take a look at your worksheet. Quote Link to comment
Pat Stanford Posted July 9, 2023 Share Posted July 9, 2023 Try PLANTIMAGE(1) PLANTIMAGE(3) PLANTIMAGE(4) (separate formulas not all at once) in case the image is stored in the wrong location? Quote Link to comment
Nico_be Posted July 10, 2023 Share Posted July 10, 2023 I have already tried to modify the PlantRecord fields but without success. I have the impression that it works, but in reality the fields are not modified. I'm interested in this subject. Quote Link to comment
Jack2022 Posted July 11, 2023 Share Posted July 11, 2023 J6470-PLA-ZZ-OO-DR-L-92301-P01.vwxI've attached the file. I tried the alternative PLANTIMAGE (1..etc) and still no luck. I added a photo to the plant styles of two plants only just to test. Ultimately I'm after a grid of photos of the plants in the landscape areas but if we can get one photo to work I can apply to the others. Thanks for any help. Quote Link to comment
Jeff Prince Posted July 11, 2023 Share Posted July 11, 2023 10 hours ago, Jack2022 said: J6470-PLA-ZZ-OO-DR-L-92301-P01.vwxI've attached the file. I tried the alternative PLANTIMAGE (1..etc) and still no luck. I added a photo to the plant styles of two plants only just to test. Ultimately I'm after a grid of photos of the plants in the landscape areas but if we can get one photo to work I can apply to the others. Thanks for any help. @Jack2022 the file you uploaded does not have images associated with the plant object. So, the worksheet is reporting the requested result... no image. However, there was one image resource in the file, so I attached that to one of the plant styles in the files and and voila... fixed4Jack.vwx 1 Quote Link to comment
Jack2022 Posted July 11, 2023 Share Posted July 11, 2023 Wonderful thank you I will try that. I previously chose the below option and I also tried to add a plant photo to the resource library then load from there but no luck. first try: second try: Quote Link to comment
Tom W. Posted July 12, 2023 Share Posted July 12, 2023 When I tried it yesterday I found I could add images to some of the plant styles but not others. For some reason those with the coloured circle graphics I couldn't get the image to display in the worksheet e.g. yet those with the 'normal' graphics I could e.g. Couldn't understand why so left it hoping someone else would explain... 1 Quote Link to comment
Jack2022 Posted July 12, 2023 Share Posted July 12, 2023 Like Tom I can get it to show for the more graphical plant but not the plants represented by circles. Still exploring. On another note auto sizing the images causes the image that does work to disappear. custom size results in it returning. Quote Link to comment
Jack2022 Posted July 12, 2023 Share Posted July 12, 2023 almost there ... it started to work when I drag the plant symbol into the drawing. looks like it doesn't work for mixes applied to landscape areas. You need to insert the individual plant somewhere out the way. Now the challenge is to show multiple plants on a grid not just one column. I applied the same =PLANTIMAGE(2) to the next column and it just repeated the first. Any ideas? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.