Q & AFormula Error
if([Separate Neutrals] = "Yes", 4, 3) I have this formula with a custom property I created, its serving 2 purposes, first is to create and add to my condition name a Yes or No, second is to determine wire count based on the answer, I got this to work but had to use value and name, with that, I was able to use if([Separate Neutrals] == 1 , 4, 3) and get my wire count to work, however, when I pull [Separate Neutrals] for the name, I get the value of 1 or 2, how do I pull the name part to say Yes or No?
I set it up as name only
Then used this formula.
"[prop]"=="yes"? 1:3
or it you want it to say yes no, "[prop]"=="yes"? "Yes":"No"
One more, If you need both parts of the formula to show up, you could do this"
That wont let me use it to calculate another formula:
The yes/no only name option will not work in a formula:
So there are 2 thing happening with this one custom property, I am using it for a name for my item and I am using it for a formula to calculate and change my wire count based on the response.
???
Will that work as a formula for a custom property? I have the formula to change in another custom property, Where is that additional info tab? Or is that a custom property?
And how do you do these GIF images, I tried and cannot get it to work
Snipping tool
Select Record then +New
You choose and area then click start at the top of that screen. After you are done, press stop and it brings up another window
Click the 3 dots and select "Create GIF"
Export it and give it a name, then use the picture icon below and pick the file.
additional info is a custom property
I created it as an alternate to Description because Description is used by the program itself.
Hi Guys, If we could use the Q and A section for formula questions that would help us out and our users.
The email notifications are being sent out to everyone that wants to know about feature requests.
I have gotten over ten on this one...
Jeffrey, if you email me at todd@zztakeoff.com I can try and help you in a zoom mtg
sorry... can you move this?
done, thanks! again Jeff if you need assistance email me and I will try to help you
Got here handled using yes /no and a math.js text formula with the " "
Similar to how I showed?
YUP!
thank you Shawn for pitching in on this
You're welcome. I was just asking to make sure I didn't give him the wrong info.
It would be nice if we had a way to chat with other users somehow within the software. Don't know if that is even possible.
@Shawn, you're asking for a way to chat with other users ...
I mean so we aren't bugging everyone else with pings. 🤣
I agree a community chat would be awesome but for now maybe ask the person if the ZZ team can share emails through our system and get you guys connected.....
This will keep it private from our community members.
Pings are good because we all learn, it was originally posted in the Feature Request section and probably should have been in the Q and A section.
But always continue to answer what you can, it makes the community stronger, so again thanks for your participation.