Jump to content

Combining multiple record fields into a single Worksheet cell


Recommended Posts

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. 
 Screenshot2024-10-25at10_58_55.png.95be91784aef0befb4ed033066740c82.pngScreenshot2024-10-25at10_44_24.png.3be34bea8742fbcf4efd8f46ecb89195.png

Screenshot2024-10-25at10_44_36.png.59435c6ba973522c403c84630a40c644.png


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?
Screenshot2024-10-25at10_50_20.png.40f53408a44e92fe25c6ab18a528814e.png

 

Screenshot2024-10-25at11_04_13.png.20b82f97dd84b7931d824ef45d7908b3.png

 

 

 

 

Link to comment

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.

Link to comment

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. 

Link to comment

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 by nbakovic
  • Like 1
Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...