<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Allow text in formulas en Revit Ideas</title>
    <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idi-p/6322082</link>
    <description>Allow text parameters in formulas.&lt;BR /&gt;e.g Fire Rating = FireRating&lt;BR /&gt;(as in NBS BIM Object standard)</description>
    <pubDate>Thu, 12 May 2016 05:24:51 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-05-12T05:24:51Z</dc:date>
    <item>
      <title>Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idi-p/6322082</link>
      <description>Allow text parameters in formulas.&lt;BR /&gt;e.g Fire Rating = FireRating&lt;BR /&gt;(as in NBS BIM Object standard)</description>
      <pubDate>Thu, 12 May 2016 05:24:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idi-p/6322082</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-05-12T05:24:51Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6322203#M26</link>
      <description>&lt;P&gt;creating strings with formulas would also be good, we could populate the description field by combining the text contents of other fields for example&lt;/P&gt;&lt;P&gt;Formula&lt;/P&gt;&lt;P&gt;="CoreThickness" mm thick "Manufacturer" "Model" "Lay Direction" lay composite cladding "Panel Application" panel, colour"External Material" .&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Would produce&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;80mm thick Kingspan KS1000RW left to right lay composite cladding roof panel, clolour Kingspan Spectrum Baltic Blue.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We currently do something similar with dynamo&lt;/P&gt;</description>
      <pubDate>Thu, 12 May 2016 07:19:37 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6322203#M26</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-05-12T07:19:37Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6661948#M3568</link>
      <description>&lt;P&gt;You could simply follow the Excel syntax of = "some text" &amp;amp; ParamaterValue &amp;amp; "some other text"&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;How ever they choose to do it I hope it happens soon, I would use it in hundreds of models (no exaggeration either!).&lt;/P&gt;</description>
      <pubDate>Wed, 02 Nov 2016 10:53:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6661948#M3568</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-11-02T10:53:52Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6667044#M3647</link>
      <description>&lt;P&gt;Indeed, this would be really nice to have! Instead of comparing numbers in formulas etc.&lt;/P&gt;</description>
      <pubDate>Fri, 04 Nov 2016 08:44:55 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6667044#M3647</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-11-04T08:44:55Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas - Status changed to: Under Review</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6703509#M4073</link>
      <description>&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;Thanks for your submission and votes on this idea! &amp;nbsp;We are evaluating where this request falls into our roadmap and will provide an update when&amp;nbsp;we have made a decision.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The Factory&lt;/P&gt;</description>
      <pubDate>Tue, 22 Nov 2016 19:39:30 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6703509#M4073</guid>
      <dc:creator>sasha.crotty</dc:creator>
      <dc:date>2016-11-22T19:39:30Z</dc:date>
    </item>
    <item>
      <title>Allow additional conditional statements in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748556#M8605</link>
      <description>&lt;P&gt;I would like to be able to reference text based parameters in conditional statements based on if they contain certain text. For example have a statement that says IF(Description=*TEXT*,"DESCRIPTION","NEED INPUT") where the asterisks are wildcards; this would search the parameter Description and if it contains the letter TEXT in that order at any point it would put "DESCRIPTION" as the response. If the Description does not contain the letters TEXT it would return "NEED INPUT". This does have the downside of returning false positives such as if Description contained "CONTEXT REQUIRED" it would return "DESCRIPTION". But it opens up a lot more doors than pit traps in my opinion.&lt;/P&gt;</description>
      <pubDate>Wed, 14 Dec 2016 12:37:17 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748556#M8605</guid>
      <dc:creator>RobertAGlover</dc:creator>
      <dc:date>2016-12-14T12:37:17Z</dc:date>
    </item>
    <item>
      <title>Re: Allow additional conditional statements in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748674#M8606</link>
      <description>&lt;P&gt;you can vote for similar idea here: &lt;A href="https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idi-p/6322082" target="_self"&gt;http://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idi-p/6322082&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 14 Dec 2016 13:26:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748674#M8606</guid>
      <dc:creator>yavork</dc:creator>
      <dc:date>2016-12-14T13:26:57Z</dc:date>
    </item>
    <item>
      <title>Re: Allow additional conditional statements in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748840#M8607</link>
      <description>&lt;P&gt;Good call. I didn't see this older post when I searched. However it is currently under review. and thus ineligible for thumb-up. But hopefully that means it's moving on to the next stage of development.&lt;/P&gt;</description>
      <pubDate>Wed, 14 Dec 2016 14:22:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6748840#M8607</guid>
      <dc:creator>RobertAGlover</dc:creator>
      <dc:date>2016-12-14T14:22:50Z</dc:date>
    </item>
    <item>
      <title>Re: Allow additional conditional statements in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6761518#M8608</link>
      <description>&lt;BLOCKQUOTE&gt;&lt;HR /&gt;@Anonymous&lt;/a&gt; wrote:&lt;BR /&gt;
&lt;P&gt;However it is currently under review. and thus ineligible for thumb-up.&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;Actually that's not the case.&amp;nbsp; I just voted for it myself.&amp;nbsp; If the vote button is greyed out for you, then you must've already voted for it (and likely forgot).&lt;/P&gt;</description>
      <pubDate>Tue, 20 Dec 2016 19:47:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6761518#M8608</guid>
      <dc:creator>doni49</dc:creator>
      <dc:date>2016-12-20T19:47:51Z</dc:date>
    </item>
    <item>
      <title>Re: Allow additional conditional statements in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6761545#M8609</link>
      <description>&lt;P&gt;You are correct. I had realized the issue as to why it was grayed out and neglected to post my findings here. Thank you for reminding me.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 20 Dec 2016 19:58:32 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6761545#M8609</guid>
      <dc:creator>RobertAGlover</dc:creator>
      <dc:date>2016-12-20T19:58:32Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6828819#M5233</link>
      <description>&lt;P&gt;It's surprising that this is still missing, this will be a powerful tools for automating schedules, especially when paired with Key Schedules.&lt;/P&gt;</description>
      <pubDate>Tue, 24 Jan 2017 23:42:10 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/6828819#M5233</guid>
      <dc:creator>SamuelAB</dc:creator>
      <dc:date>2017-01-24T23:42:10Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7101880#M8404</link>
      <description>&lt;P&gt;Any expectation or estimation to which release this will be added?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 23 May 2017 13:25:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7101880#M8404</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-05-23T13:25:50Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7156188#M8920</link>
      <description>&lt;P&gt;I would like to create text strings to poulate the description field as above but include a string conversion for number or unit based parameters. Perhaps string converters to keep the project units and string converters to strip them?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Description = STRINGU(Airflow) + " " + STRING(Capacity) + " direct fired make-up air unit" + IF(Curb, " w/ factory curb", "")&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;for example.&lt;/P&gt;</description>
      <pubDate>Thu, 15 Jun 2017 23:05:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7156188#M8920</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-06-15T23:05:52Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7274556#M9879</link>
      <description>&lt;P&gt;For me, this idea means two things&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;being able to &lt;STRONG&gt;drive&lt;/STRONG&gt;&amp;nbsp;a text parameter based on a formula (for example creating a description field based on&amp;nbsp;actual parameter values like dimensions, materials, yes/no parameters, ...)&lt;/LI&gt;
&lt;LI&gt;being able to use a text parameter&amp;nbsp;&lt;STRONG&gt;inside&lt;/STRONG&gt;&amp;nbsp;a formula (if textfield="this text",...). Additional benefits would be if we have wildcard operators.&lt;/LI&gt;
&lt;/OL&gt;</description>
      <pubDate>Thu, 03 Aug 2017 15:34:45 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7274556#M9879</guid>
      <dc:creator>pieter1</dc:creator>
      <dc:date>2017-08-03T15:34:45Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7314550#M10284</link>
      <description>&lt;P&gt;This idea is also related to my idea of being able to reference parameters pretty much anywhere where one can enter text:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://forums.autodesk.com/t5/revit-ideas/make-substitution-variables-available-everywhere-where-text-can/idi-p/7082910" target="_blank"&gt;https://forums.autodesk.com/t5/revit-ideas/make-substitution-variables-available-everywhere-where-text-can/idi-p/7082910&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;As an aside, syntactically speaking using generic text in formulas is tricky. Text with spaces will have to be quoted. What about text with spaces and quote characters? It's not trivial. Certainly variable names should not be allowed to have spaces or any fruity characters in them. There is a reason why this convention is used by all programming languages that I know (Perl, Python. Ruby, C, C++, Javascript, Java, etc)&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Convenience always has its price. I think that most people who use Revit are intelligent enough to be able to adapt to certain generally accepted conventions for dealing with formulas and code in general. And if they're not then they have no business using those features. They will just shoot themselves in the foot and then start requesting safety features etc.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;-t&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 21 Aug 2017 01:27:33 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7314550#M10284</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-08-21T01:27:33Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7339886#M10482</link>
      <description>&lt;P&gt;It would also be super helpful if we could subtract characters in addition to do concatenations. &amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;For example: I would like to subtract prefixes from my sheet numbers, (not showing the suffix, or only showing the suffix). In theory we could split these up in separate parameters but that's not always feasible (no duplicate sheet numbers allowed).&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If we could subtract characters we would do F1-A-100.00 as sheetnumber, but only show A-100 in the callouts/titleblock as the other stuff is not relevant in those scenarios.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Perhaps Revit could borrow the syntaxis from Excel?&amp;nbsp;&lt;A href="https://www.extendoffice.com/documents/excel/560-excel-remove-character-from-string.html" target="_blank"&gt;https://www.extendoffice.com/documents/excel/560-excel-remove-character-from-string.html&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 30 Aug 2017 17:39:20 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7339886#M10482</guid>
      <dc:creator>pieter1</dc:creator>
      <dc:date>2017-08-30T17:39:20Z</dc:date>
    </item>
    <item>
      <title>Re: Allow text in formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7339997#M10484</link>
      <description>&lt;P&gt;To be honest, I basically expect most of the basic Excel formulas to be present in Revit. Anything else is disappointing.&lt;/P&gt;</description>
      <pubDate>Wed, 30 Aug 2017 18:21:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7339997#M10484</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-08-30T18:21:38Z</dc:date>
    </item>
    <item>
      <title>Add Concatenate Function for Formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478525#M15050</link>
      <description>&lt;P&gt;We &lt;EM&gt;really&lt;/EM&gt; need a way to concatenate string and values in formulas. For example, in HVAC, for diffuser/grille schedules, it is very common to have a column that lists the face dimension of the elements. However, in some cases, the face dimension is a diameter and in other cases it will be a rectangular dimension.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;So we need a calculated field that does something like this:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;if(Face Diameter=0,concatenate(Face Length,"×",Face Width),concatenate(Face Diameter,"Ø"))&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;We need this function everywhere that we can use formulas and not just in schedules.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This function has been requested for years.&amp;nbsp;Other typical text handling functions are also needed, but I don't want to muck up the thread.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Frankly, AutoCAD MEP is superior in this regard because it allows for VBScript in their property set data which makes the data more usable and presentable.&lt;/P&gt;</description>
      <pubDate>Fri, 20 Oct 2017 16:26:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478525#M15050</guid>
      <dc:creator>r.robert.bell</dc:creator>
      <dc:date>2017-10-20T16:26:58Z</dc:date>
    </item>
    <item>
      <title>Re: Add Concatenate Function for Formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478558#M15051</link>
      <description>&lt;P&gt;It is not just the MEP modelers who want this.&amp;nbsp; There are lots of formula options that could be better but this is definitely at the top of the list.&lt;/P&gt;</description>
      <pubDate>Fri, 20 Oct 2017 16:35:54 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478558#M15051</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-10-20T16:35:54Z</dc:date>
    </item>
    <item>
      <title>Re: Add Concatenate Function for Formulas</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478563#M15052</link>
      <description>&lt;P&gt;Inventor had the ability to reverence VBA functions in their parameters to do cals like this. Some of these core concepts should really be leveraged across all the product lines.&lt;/P&gt;</description>
      <pubDate>Fri, 20 Oct 2017 16:37:48 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-text-in-formulas/idc-p/7478563#M15052</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-10-20T16:37:48Z</dc:date>
    </item>
  </channel>
</rss>

