I exported my schedule to be able to modify from excel and read back to Revit. But I am not sure which node I have to use there to read yes/no value. Any suggestions? Thank you [111111111]

As Steven mentioned in the beginning, you can set a Yes/No parameter with either integer (0 1) or boolean (true false). So the goal is to replace the strings("Yes" "No") with either integers or boolean and use that value to set your parameters. [dynamo-yes-no] I think this extended way might mak…

Replace yes with 1 and no with 0 (zero) or yes with true and no with false

Its worked for me… [Yes or No] Yes or No.dyn (9.7 KB)

[image] The Values “Yes” or “No” cannot be converted to number, as I see it. [image]

See this thread for some idea to create dictionaries. [image] Compare Space Name in Revit lookup excel add adjacent properties from Excel to Revit Revit Dear Dynamo Users, Is it possible to find the use the space name from revit model and lookup for the same name in excel…

val == “Yes” ? 1 : 0; This bit of design script should swap the yes for a 1 and the no for a 0.

Yes, I need a node that can replace String.ToNumber; for example, sth like material.byname for material parameter. I just cant figure out which.

Its not a string its a number… remove the double quotation marks( " "). I think for you best approach follow as @jacob.small mentioned.

[image] jacob.small: val == “Yes” ? 1 : 0; Try replacing the String.ToNumber to to the DesingScript code Jacob Proposed:

This was it! Yes, I need better understanding of using codeblocks. Thank you! [yesno_parameter]

Excel to Revit Yes/No value

Revit

Arun_Prakash September 24, 2020, 6:16am 6

See this thread for some idea to create dictionaries.

Topic		Replies	Views
Reading Yes/No values in Excel and writing in Revit Revit	3	970	July 17, 2018
Bringing a Result from Excel back to a shared Yes/No Parameter Revit	2	868	August 8, 2017
Link Excel to Revit Revit	1	908	December 20, 2016
List consisting of both values and booleans from excel to revit Revit revit , excel , dynamo	12	1491	January 25, 2018
Replacing Yes/No parameter value with a text String Packages	4	1521	March 12, 2018

Excel to Revit Yes/No value

Related topics