nbakovic Posted October 25, 2024 Share Posted October 25, 2024 I'm stuck again and really don't know how to get this to work. I have hybrid objects with attached records for graphic panels inside of a museum. I created Data Tags that pull the information from 3 separate fields and combined them into a single ID (with the generous help of Pat Stanford). For example, I have a graphic in area 1, that is a Section Graphic (GSE), and it's the 4th graphic of this type in that area, so the ID ends up being 1-GSE-04. I'm able to get the ID to show up correctly in the Data Tag field, but that's about it. I am unable to get it to show up in a worksheet. I'm using the Data Manager to populate some of the fields so that the dimensions of the graphics are updated as I adjust them. I tried doing the same thing for the ID field but it results in just showing whatever the first field if and then nothing after that. I must be missing something but I have no idea where to start looking for a solution. Does anyone have any ideas? Quote Link to comment
Pat Stanford Posted October 25, 2024 Share Posted October 25, 2024 The easiest way may be to "recreate" the ID in the worksheet as well. Try =Concat('GFX-Marker'.'exhibit area', '-', VLookup('GFX_Marker'.'graphic type',2, 'NA', 'Graphic Type Codes':A1:B31), '-','GFX_Marker'.'graphic number') You may also be able to pull it from the Data Tag using the DataTagField worksheet function, but since your database does not seem to be based on the tags, that will likely not work well. Quote Link to comment
nbakovic Posted October 25, 2024 Author Share Posted October 25, 2024 Thanks for the help Pat! Recreating the ID inside of the workshop works, however the VLookup function isn't working. I was able to get the rest of it to work by replacing it with 'GFX_Marker'.'graphic type' but this means that it displays the full type instead of the three letter code. Quote Link to comment
Pat Stanford Posted October 25, 2024 Share Posted October 25, 2024 Copy the VLookup part from the working Data Tag. They should be identical. I think maybe the WS name needs to be in all caps that I missed when I typed it in. Quote Link to comment
nbakovic Posted October 25, 2024 Author Share Posted October 25, 2024 (edited) Getting closer! I missed the all caps name as well and the cell range for the worksheet was written as A1:B31. After I changed the it to A1..B31 it's executing but apply "NA" instead of the code. I had this happen before and I think there is another typo in my names somewhere if memory serves. =CONCAT('GFX-Marker'.'exhibit area', '-', VLOOKUP('GFX_Marker'.'graphic type', 2, 'NA', 'GRAPHIC_TYPE_CODES':A1..B31), '-', 'GFX_Marker'.'graphic number') Updated: Yup, where was an underscore missing between graphic and type. Thank you so much for your help. Edited October 25, 2024 by nbakovic 1 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.