topic Re: Link fields to table cells in AutoCAD Forum

Link fields to table cells

farzanbayat74 — Sat, 15 Apr 2023 20:54:20 GMT

How can I link a field to a table cell content?

Re: Link fields to table cells

paullimapa — Sun, 16 Apr 2023 00:06:53 GMT

https://help.autodesk.com/view/ACD/2023/ENU/?guid=GUID-B24A017B-66CA-4F24-AC50-7CAEAC737B7A

Re: Link fields to table cells

paullimapa — Sun, 16 Apr 2023 00:14:12 GMT

Re: Link fields to table cells

farzanbayat74 — Sun, 16 Apr 2023 17:46:54 GMT

Hi @paullimapa , thanks for your response.

I want to have a field outside the table and this field shows the value of table cell.

Re: Link fields to table cells

paullimapa — Sun, 16 Apr 2023 18:10:56 GMT

then you'll need this add-on which is not free:

How to link / insert a table cell to AutoCAD fields. - YouTube

Re: Link fields to table cells

TerryDotson — Mon, 17 Apr 2023 17:04:54 GMT

How can I link a field to a table cell content?

Assuming your table cell content is numeric:

Initiate the FIELD command.
Field Category: All
Field Names: Formula
Click [Cell] button.
Click [OK] to begin placement.

AutoCAD fields prevent this from working on non-numeric content. Some might call it a design limitation; some call it a very mature bug.

Re: Link fields to table cells

dbroad — Mon, 17 Apr 2023 19:04:26 GMT

If you're willing to use a LISP command, this might work for you.

;;Basic demonstration of linking a table cell to a field ;;No error checking, no guarantees. Seems to work. Creates a text object. ;;D. C. Broad, Jr. 4/17/2023 (defun c:fieldcell (/ textent textobj oid) (if (and (setq textent (car (nentsel "\nSelect table cell"))) (setq textobj (vlax-ename->vla-object textent)) (setq oid (vla-get-objectid textobj)) ) (command "_.text" pause "" "" (strcat "%<\\AcObjProp Object(%<\\_ObjId " (itoa oid) ">%).TextString>%" ) "" ) ) (princ) )

Re: Link fields to table cells

ChicagoLooper — Mon, 17 Apr 2023 19:55:21 GMT

@farzanbayat74 wrote

<<...I want to have a field outside the table and this field shows the value of table cell....>>

Use MTEXT to display the value of the cell.

Start mtext command=>>Right-click=>>Insert Field=>>then do this:

Re: Link fields to table cells

TerryDotson — Mon, 17 Apr 2023 21:55:51 GMT

If you're willing to use a LISP command, this might work for you.

(nentsel "\nSelect table cell")

This portion does not appear to work when the cell font is truetype, unless the drawings VisualStyle is set to "Realistic". Cells using SHX fonts always seem to work.

Found the same problem in the .NET GetEntity, GetNestedEntity.

Re: Link fields to table cells

dbroad — Mon, 17 Apr 2023 22:30:22 GMT

That seems about right with AutoCAD. It's always something. Just when you think it works right, it doesn't.

Re: Link fields to table cells

dbroad — Mon, 17 Apr 2023 22:53:35 GMT

So some eager beaver could add on by 1)Using hittest to determine which row and column is selected, 2)Get the celltextstyle for that cell, 3)determine whether that style is SHX 4)if so, do fieldcell, 5)otherwise create a temporary text style with an shx font, 6)temporary set the celltextstyle for that cell, 7)do the function fieldcell actions, 8)set the celltextstyle back to whatever it was, 9)delete the temporary text style.

Re: Link fields to table cells

TerryDotson — Tue, 18 Apr 2023 00:43:33 GMT

So some eager beaver could add on by ....

I had a different train of thought, added an option to our ToolPac Table SubSelection tools so the user can simply swipe across the cells they want to create linked mtext from and click a button. It instantly creates all the fields in the current layer so the user can then simply drag them to the desired locations.

Could be used in combination with a linked table from Excel, etc.

Re: Link fields to table cells

farzanbayat74 — Tue, 18 Apr 2023 18:32:23 GMT

Thanks @TerryDotson , It worked. easy and no need for lisps 👍

Re: Link fields to table cells

olov_backlund — Wed, 29 May 2024 09:30:02 GMT

Hi,
Is it possible to get the cell's value without what is before the cell's value?

{\fAptos Narrow|b0|i0|c0;2024-05-29

Would like it to look like this: 2024-05-29

Thanks in advance!
Olov

Re: Link fields to table cells

cadffm — Wed, 29 May 2024 10:20:34 GMT

@olov_backlund schrieb:

the cell's value without what is before the cell's value?

Hi,

don't use internal Mtext formattings (your sample: Overrided Font for example)

but yes, it is also possible to by a change of your fieldcode:

HTH

Re: Link fields to table cells

olov_backlund — Wed, 29 May 2024 10:56:50 GMT

Hi,

Thanks for the help. Is it possible to force the cell value to be in uppercase?

/Olov

Re: Link fields to table cells

cadffm — Wed, 29 May 2024 11:18:59 GMT

Re: Link fields to table cells

HuynhMinhTri — Sun, 17 Aug 2025 15:29:00 GMT

But it can link cell value to text

Re: Link fields to table cells

olov_backlund — Fri, 17 Oct 2025 11:02:50 GMT

Hi,

It is possible to merge two or more cell values with a space between them?

And is it possible to add these fields to a block?

/Olov