Another crazy idea to try and make work...

[spettitt]

So I have a requirement to make some icons show/hide against revisions in our title block based on the data of that revision.

We'll use the Recipient field as we don't use that for anything.
 

Our current revision box in our TBB looks like this. I will add an extra column for 'Departments' - effectively showing which departments had changes in that revision.

 

If Recipient contains the string 'PA' I'll have our PA department logo show, and/or if it contains the string 'LX' it will show the LX department logo as well. These will be just 4 static PNG images.

My current best idea is to have a custom PIO on top of the TBB that can get the revision data from the five latest revisions and render the logos in the right places.

 

But if there's a smarter way to do this without a custom object then I'd be curious how others would attack it.

 

Thanks! 

 

[twk]

Interesting Idea. You can place the temp images on a layer somewhere and reference in with the Image function.

[spettitt]

1 hour ago, twk said:

Interesting Idea. You can place the temp images on a layer somewhere and reference in with the Image function.

 

Nice, thank you.

 

I've gotten this far, where I can search for the required substrings, but when I replace the 'PA' yes value with the IMAGE function in a database row, it won't return the image, presumably as using the IMAGE function in a database row will always try and return the image of that object row in the database.

 

 

I think what I need to do now is either find a way for a spreadsheet row to reference the database results (i.e. Cell E8 references D4.1) which I'm not sure is possible, or avoid database rows completely. To do it entirely in spreadsheet cells, I'll need to try and find a way to access the Revision records from sheet number L1, as I'm currently doing this.
 

 

Will have another go tomorrow. Cheers!