The current options for record fields are integer, boolean, text, and number. I have longed for a record field option that acts like a database header FUNCTION. For example, in a custom record format, you could add a record field, and its type would be FUNCTION. Then, once an object is assigned the custom record field, you could select from a list or type the same functions used in worksheets (COUNT, AREA, PERIMETER, LENGTH, X-VALUE, etc.). The value would then update as objects resize or move.
The real power of this lies in worksheets where you could query the FUNCTION field of a the custom record format and return the value. For cost/quantity estimating, units often differ. We will have SQUARE FOOT (AREA) units right next to LINEAR FOOT (PERIMETER) units and there is currently no way of accomplishing this without separating the unit types into two different database headers in a worksheet.
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.
Question
ericjhberg
The current options for record fields are integer, boolean, text, and number. I have longed for a record field option that acts like a database header FUNCTION. For example, in a custom record format, you could add a record field, and its type would be FUNCTION. Then, once an object is assigned the custom record field, you could select from a list or type the same functions used in worksheets (COUNT, AREA, PERIMETER, LENGTH, X-VALUE, etc.). The value would then update as objects resize or move.
The real power of this lies in worksheets where you could query the FUNCTION field of a the custom record format and return the value. For cost/quantity estimating, units often differ. We will have SQUARE FOOT (AREA) units right next to LINEAR FOOT (PERIMETER) units and there is currently no way of accomplishing this without separating the unit types into two different database headers in a worksheet.
Link to comment
2 answers to this question
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.