Is it possible to use strings in a configuration table?
A usecase would be to create a configuration table in which a column of data have metric sizes (i.e. M5, M6, M8, etc) to be used with the Hole feature of the PartDesign WB. For the moment the Hole feature in the Size drop-down list don't accept Expressions, but if it does it could retrieve the "Mx" string and update the bore, thread, countersink sizes accordingly.
PR#2862: Configuration Table using Spreadsheet
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
Be nice to others! Respect the FreeCAD code of conduct!
-
- Veteran
- Posts: 2190
- Joined: Tue Jan 03, 2017 10:55 am
Re: PR#2862: Configuration Table using Spreadsheet
Yes sure. Almost all properties can be bound by expression. It's just that not all of them are exposed to the editing task panel. Use property editor to find the 'ThreadSize' property of the hole, right click the property name and choose 'Expression...'.hasecilu wrote: ↑Wed Jul 06, 2022 10:09 pm Is it possible to use strings in a configuration table?
A usecase would be to create a configuration table in which a column of data have metric sizes (i.e. M5, M6, M8, etc) to be used with the Hole feature of the PartDesign WB. For the moment the Hole feature in the Size drop-down list don't accept Expressions, but if it does it could retrieve the "Mx" string and update the bore, thread, countersink sizes accordingly.
Re: PR#2862: Configuration Table using Spreadsheet
Thanks for your answer and sorry for the late response, afk.
I have follow the steps and it worked, I didn't know about this feature. Last days I have been modelling some parts for the FreeCAD library and this is very helpful. Also now I remember that is possible to attach Expressions to Body names...
I have follow the steps and it worked, I didn't know about this feature. Last days I have been modelling some parts for the FreeCAD library and this is very helpful. Also now I remember that is possible to attach Expressions to Body names...
Re: PR#2862: Configuration Table using Spreadsheet
Code: Select all
OS: openSUSE Tumbleweed (KDE//usr/share/xsessions/plasma5)
Word size of FreeCAD: 64-bit
Version: 0.20.1.29410 (Git) AppImage
Build type: Release
Branch: (HEAD detached at 0.20.1)
Hash: f5d13554ecc7a456fb6e970568ae5c74ba727563
Python 3.10.5, Qt 5.15.4, Coin 4.0.0, Vtk 9.1.0, OCC 7.6.2
Locale: English/United States (en_US)
Installed mods:
* Assembly4 0.12.5
* offline-documentation 1.0.0-alpha
* Help 1.0.3
* symbols_library
* CubeMenu
I am very confused and have many questions. Is there perhaps a tutorial or video aimed at users for Variant Links?
What I am attempting to model is a tool chest system. It has 9 variants of drawer sizes and 4 variants of drop front doors. Here is my working concept drawing:
What I would like to do is create one complete drawer from five parts then vary the dimensions (i.e. drawer_width and drawer_height) to create the the parts needed for the different drawer sizes.
Parts List :
- front
- back
- bottom
- left_side
- right_side (mirror of left)
- drawer_width (left to right)
- drawer_height (top to bottom)
- drawer_depth (front to rear - constant at 535 mm)
- material_thickness (constant at 13 mm for all parts)
The drop front doors present a similar problem, 4 doors all of the same width but varying in height. Each made of the same 3 parts: rail x 2, stile x 2, and a panel. All the rails will be identical, but the stile and panels vary in height as the door varies. Modeling the parts gives me 4 different assembly models when I am only allowed 1 per file.
The trivial answer is to simply create a file for every assembly variation, but I was hoping for a "more elegant and efficient" method by using Variant Link, and a great deal fewer redundant parts.
Thank you all so much for your precious time and help.
Last edited by MSOlsen65 on Mon Mar 20, 2023 12:12 pm, edited 1 time in total.
Sincerely,
Michael S. Olsen
Electrical Engineer & Joiner
Michael S. Olsen
Electrical Engineer & Joiner
-
- Posts: 125
- Joined: Fri Sep 13, 2019 12:15 pm
Re: PR#2862: Configuration Table using Spreadsheet
The `Configuration Table` feature is fantastic. I'd like to use this feature with full parameters, e.g. in headless modehttps://wiki.freecad.org/Embedding_FreeCAD, assign a value('config3') to the table B3 cell via python code, and then the cell(C3~F3) of data can be switched like a Configuration Table
Thank you!
Thank you!
Re: PR#2862: Configuration Table using Spreadsheet
I got it.hotqin888 wrote: ↑Thu Mar 21, 2024 9:30 am The `Configuration Table` feature is fantastic. I'd like to use this feature with full parameters, e.g. in headless modehttps://wiki.freecad.org/Embedding_FreeCAD, assign a value('config3') to the table B3 cell via python code, and then the cell(C3~F3) of data can be switched like a Configuration Table
Thank you!
Input "=dbind(Body.Configuration.All)" in B3,then right click on the B3,click edit mode——combobox,select persistent.
Last edited by hotqin888 on Tue Apr 09, 2024 2:37 pm, edited 1 time in total.
Can the configuration table support column direction parameters?
For example, if I have multiple sets of parameters, and I want to use the configuration table function to switch column data groups. At the moment, it seems to be switching by row. Because the amount of data exceeds a dozen, it is difficult to organize the data in rows, so you need to use the mouse to click and hold the scroll bar below to move left and right, and scrolling up and down with the scroll wheel can be convenient to view multiple data. Thank you very much.