WhoCanDo Posted June 12 Share Posted June 12 Hi, When I insert =IMAGE(N='Logo') into a spreadsheet cell, it shows me a picture of a logo. Good. However, if I make that line a Database, it displays "False", not the picture. Note: the named item is a 2D symbol. The following link says I can do it for spreadsheet and database cells, but how .. https://app-help.vectorworks.net/2023/eng/VW2023_Guide/Worksheets/Inserting_images_in_worksheet_cells.htm Quote Link to comment
0 Pat Stanford Posted June 12 Share Posted June 12 In a database row, the criteria is defined by the criteria of the database. You can not use custom criteria in the header row formulas of a database. For IMAGE to work in a database, the criteria has to specify an object that it can display an image of. It would be really useful to be able to do something like attach a record to an object and then return an image based on the data in that record, but that is not currently possible. Sorry. Quote Link to comment
0 WhoCanDo Posted June 12 Author Share Posted June 12 Thanks Pat, I feared that would be the answer. Thanks Quote Link to comment
0 WhoCanDo Posted June 13 Author Share Posted June 13 So, finding a work around wasn't that difficult. This is how I solved it for those interested. The reason for making a Database line was to get the Record Value from an object, with a record attached, and list it on the same row as the Logo. The row must be of Spreadsheet type, and then the cell value =IMAGE(N='Logo') works. I wrote this macro and the added this formula to a cell to the right of the Logo =RUNSCRIPT('Name of script') Many of you will recognize the method. procedure Fab_List_Value; procedure Get_Value (h : handle); var V : string; begin V := Concat (GetRField (h, 'Value', 'GrWeight'), ' ', GetRField (h, 'Value', 'NtWeight')); WSScript_SetResStr (V); end; begin ForEachObject (Get_Value, ((L = 'Objects') & (C = 'Object1'))); end; run (Fab_List_Value); 1 Quote Link to comment
Question
WhoCanDo
Hi,
When I insert =IMAGE(N='Logo') into a spreadsheet cell, it shows me a picture of a logo. Good.
However, if I make that line a Database, it displays "False", not the picture.
Note: the named item is a 2D symbol.
The following link says I can do it for spreadsheet and database cells, but how ..
https://app-help.vectorworks.net/2023/eng/VW2023_Guide/Worksheets/Inserting_images_in_worksheet_cells.htm
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.