lgoodkind Posted May 18, 2021 Share Posted May 18, 2021 I'm trying to display a plant database image based on the flowering season using the following =IF(('Plant Record'.'Blooms Begin'='*spring*'), PLANTIMAGE(1), ' ') This is not working. I can test that =PLANTIMAGE(1) works on another column Any ideas anybody? Quote Link to comment
0 Pat Stanford Posted May 19, 2021 Share Posted May 19, 2021 I am not certain that the wildcards (*) are working correctly. Try and use the exact string of the Blooms Begin field for one of the plants and see if you get the correct results. Another test. Add another column with a formula of just ='Plant Record'.'Blooms Begin'. Add a second column with a formula of =C3='*spring*' and see if you get a return value of True or false. Could it be a capitalization problem that could be solved by ='*pring*' to ignore the capitalization of the S? Post a file with a few plants and your worksheet and I will take a look. 1 Quote Link to comment
0 lgoodkind Posted May 19, 2021 Author Share Posted May 19, 2021 (edited) Pat, Thanks for your reply. I get the desired results with the wildcards, meaning I get a 'true' in the cell when using.. =IF(('Plant Record'.'Blooms Begin'='*spring*'), 'true', 'false') and the data contain Spring and Winter When I use the following - all I get is a blank cell with no error =IF(('Plant Record'.'Blooms Begin'='*spring*'), PLANTIMAGE(2), 'false') I thought I would try and tackle a Python script to fix this but although I'm versed in Python the VS reference is pretty dense. I can't even find a reasonable way to debug within vectorworks to output print() statements to see what anything is doing. plant worksheet.vwx Edited May 19, 2021 by lgoodkind Quote Link to comment
0 Pat Stanford Posted May 19, 2021 Share Posted May 19, 2021 It appears that what you want is not achievable with the basic worksheet. I think the issue is that the IF function does not support an Image as an output, but I am not certain. It would probably be possible to generate what you want with a Worksheet Script, but I don't have time this week to play with that option. Quote Link to comment
Question
lgoodkind
I'm trying to display a plant database image based on the flowering season using the following
=IF(('Plant Record'.'Blooms Begin'='*spring*'), PLANTIMAGE(1), ' ')
This is not working. I can test that =PLANTIMAGE(1) works on another column
Any ideas anybody?
Link to comment
3 answers to this question
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.