topic Re: Combine Calculated Value and Text String in AutoCAD Table Cells in AutoCAD Forum

Combine Calculated Value and Text String in AutoCAD Table Cells

petestrycharske — Thu, 15 Jun 2023 15:53:47 GMT

All,

Good morning! Is it possible to combine a calculated value (perhaps from another cell) and a text string in an AutoCAD Table cell? I'm not seeing an obvious way to do this, without going out to Excel and then coming back into AutoCAD. Does anyone know of a way to accomplish this? Thanks in advance for any help that you can throw my way! If you have any questions, please do not hesitate to contact me. Hope all is well and have a most blessed day!

Peace,
Pete

Re: Combine Calculated Value and Text String in AutoCAD Table Cells

pendean — Thu, 15 Jun 2023 16:46:28 GMT

perhaps a FIELD +text combination?

Re: Combine Calculated Value and Text String in AutoCAD Table Cells

petestrycharske — Thu, 15 Jun 2023 17:14:49 GMT

@pendean, thanks for the suggestion and I like it! Unfortunately, I was not successful when I tried to get the field to recognize a particular cell. I tried to use the "Object" field type. Do you know of a different way? Thanks for the help and have a most blessed day!

Re: Combine Calculated Value and Text String in AutoCAD Table Cells

pendean — Thu, 15 Jun 2023 17:34:48 GMT

Can you share a sample DWG file with some notes in it describing your intent?

Re: Combine Calculated Value and Text String in AutoCAD Table Cells

ChicagoLooper — Mon, 19 Jun 2023 02:57:11 GMT

Hi @petestrycharske

You can do it using a formula that contains a FIELD (actually a small part of a field). Here's an example.

I have Table-1 and Table-2. I want to CAPTURE total from Table-1 and Table-2 and insert them into the Summary table. (Image-1)

Image-1

To capture the total from Table-1, click the destination cell in Summary Table, right click and insert a FIELD.. The field comes from a table so select Table-1 as the source then.... (Image-2)

Image-2

....after selecting the table, highlight the object ID from the Field Expression section and copy the ObjID to your clipboard. Then back in the Summary destination cell, enter the formula

=Table('ObjID').cell

<<In this example......=Table(1905947083840).D7 >> where the ObjID is pasted from the clipboard followed by '.' and cell column-row. (Image-3)

Image-3

Use the same procedure to capture the total from Table-2 and Summary Table will look like this. (Image-4)

Image-4

If you want to add additional text to the destination cell, such as a prefix or suffix, you can do it by selecting the destination table and going through the Properties Palette. (Image-5)

Image-5

If any of the values in the source tables change, enter Regen All (REA) on command line so the Summary Table can update and reflect the change.

Re: Combine Calculated Value and Text String in AutoCAD Table Cells

timothy_jacob2021 — Wed, 03 Dec 2025 09:52:26 GMT

dude, this is insane! thank you so much!!!