Back to zzTakeoff Community Channel LogoQ & A
Ben Stewart
45d 18h

Formula in Name Property

Completed

Is it possible to write a formula in the Name property for a linear takeoff which will include the [Width] in feet and inches plus the [Depth] in feet and inches. I would like the Name to automatically read Continuous Footing 2'0"x1'4"d as an example.




0
Kory Podgaysky 45d 18h

It will be in the update.

Lorin Allred zzTakeoff45d 3h

Hey Ben, you can now do this in the new update with the ":dimension"



As a side note, we also added the ability to directly access the feet and inches of the custom property dimensions (like width/depth) via ".ft" or ".in"


Ben Stewart 44d 19h

Loren, I discovered that the formula as you have written above only works with "Text with Tags" mode. If I select "Formula" mode for the name, I get an "Error evaluating formula".

Lorin Allred zzTakeoff44d 15h

Hey Ben. In the latest update, we switched "Formula" mode to "Text With Tags" so that formula mode could be a true formula. Most users will only need to use Text With Tags, but we added the formula mode for users wanting to round, add, etc.




To use text in the formula mode, it would look something like this:


This example formats the name with the inches rounded up to the nearest 3.

Victor Tengowski 44d 1h

@Lorin is there documentation we could look at to help us build our own naming formulas?


The syntax of using print and $ft\ & $in\ is not intuitive and I wouldn't have guessed that's what would have had to been written to have it print that way.

Lorin Allred zzTakeoff43d 19h

Most of our documentation focuses on quantity formulas for items, but we will hopefully be adding more information about how to use formulas in the name, etc. soon.


Just for interest's sake, in my example, the $ logic is specific to the print() function, and the \ was to string escape the " and ' for inches and feet.


The print currently functions as following: print("Your text with $placeholder", {placeholder: value})

Casey Krueger 35d 23h

It took me way to long to understand how Lorin's example worked, since $ and \ scare me. I did get it to work and it is great since it lets you use the ' & "

I used a different method to get my problem solved (Since I didn't see Lorin's example until I already solved my problem), which uses the concat() & string(), it just doesn't let you use the ' & "



I needed my description with the area SF rounded and include the thickness

04. Demo/remove (E) sidewalk up to 2411 SF x 4in thick

concat("04. Demo/remove (E) sidewalk up to ",string(round([Area:SF]))," SF x ",string([depth:in]), "in thick")



Breakdown:

concat() lets you combine your text -> concat( "Text", "Text", "Text") -> TextTextText

string() converts values into text (Also drops .0s at the end) -> string([Area:SF])

round() rounds the value



Also for those who don't want to type out Lorin's formula

print("Continuous Footing $ft\'-$in\"",{"ft":[depth.ft], "in":roundup([depth.in],3)})

Lorin Allred zzTakeoff35d 23h

Awesome! The concat method is probably more user-friendly, and the approach we will most likely recommend to users. Thanks for sharing @Casey. 🙂

You must be logged in to post replies. If you don't have an account you can signup here.