<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Force a field to lower case</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Force-a-field-to-lower-case-81277</link>
        <description></description>
        <pubDate>Mon, 16 Mar 2026 23:03:29 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Force-a-field-to-lower-case-81277" rel="self" type="application/rss+xml" />

                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241887#post2241887</link>
          <description><![CDATA[<p>Hi Gary, </p>
<p>Ok, you may be able to use the CMSB "unique" setting in the field editor for case-insensitive checking on the backend and PHP's strtolower() on the frontend to display the values.  Or maybe a small plugin that adds some jquery code to the footer in the CMS that lowercases that's field content on change (or keyup).   In any case, I'll leave it with you, I know you've got a more advanced setup.</p>
<p>Re: permalinks, it does a lot of the common things automatically so it can be pretty helpful.  But try it out and if the cost doesn't make up for itself in value feel free to use the 90 day refund form: <a href="https://www.interactivetools.com/about/guarantee.php" rel="nofollow">https://www.interactivetools.com/about/guarantee.php</a>  We want it to be safe and easy for you to try any of the plugins you are curious about so it's no problem.</p>
<p>How that helps!</p>


]]></description>
          <pubDate>Sat, 24 Mar 2018 20:39:18 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241887#post2241887</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241886#post2241886</link>
          <description><![CDATA[<p>Hi- to reply to your exact question, I am trying to solve the fact that I use the field seo_page_name to create my navigation scheme in the menus.  If I have a MixedCaseValue, my link becomes //www.sitename.com/MixedCaseValue - I want //www.sitename.com/mixedcasevalue instead, so I thought it would be easiest to convert MixedCaseValue to mixedcasevalue when they first enter it, but not force the field to accept only lowercase letters (and numbers and dashes) because it can become frustrating to to users to have to change the value on their own, so I thought I would convert it when they save the record.</p>
<p>I purchased the permalinks add-on, but, as you know, I use CMSB in a much different manner than the out-of-the-box methodology.  I will probably have to create my own add-on, but the $150 I spent to buy permalinks will be money well spent to give me a starting point.</p>
<p>I think I know where I can do the strtolower call, or a MySql LOWER call with my current seo_page_name field that it will still work OK without having to do a lot of other stuff.  However, I love the history of the permalinks add-on and will add that to mine as soon as I get a chance.</p>
<p>The history will solve the problem of permalinks that are embedded in the content portion of the different pages if/when the permalink changes.  The LOWER and strtolower will solve a few other issues and all should be well.</p>
<p>Thank you for replying.</p>]]></description>
          <pubDate>Sat, 24 Mar 2018 05:52:23 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241886#post2241886</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241879#post2241879</link>
          <description><![CDATA[<p>Hi Gary, </p>
<p>What's the exact issue you are trying to solve? CMS Builders built-in unique field checks are case insensitive.  And if you have some custom MySQL code you can convert to lowercase with the MySQL LOWER() function.</p>]]></description>
          <pubDate>Fri, 23 Mar 2018 15:54:14 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241879#post2241879</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241868#post2241868</link>
          <description><![CDATA[<p>Good luck. It took me a few sites to get the hang of it, but I really love it now. </p>]]></description>
          <pubDate>Wed, 21 Mar 2018 08:04:21 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241868#post2241868</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241867#post2241867</link>
          <description><![CDATA[<p>I opted to buy the permalink add-on - hopefully that will make life a bit easier - I like the history capability in it - something I have not done.  That's worth the cost of it right there.</p>

<p>I'll see how this goes for me.</p>
<p>Gary</p>]]></description>
          <pubDate>Wed, 21 Mar 2018 07:32:11 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241867#post2241867</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241866#post2241866</link>
          <description><![CDATA[<p>Hi - we have about 150-200 sites right now using CMSB, so I would like to put my add-on in place as we have a reason to touch a site.  The permalink add-on is rather costly for doing almost the exact same thing I already do.  I just never thought about the case issue before yesterday when a customer couldn't get their links to work correctly...then we figured out why.</p>
<p>Gary.</p>
]]></description>
          <pubDate>Wed, 21 Mar 2018 06:00:20 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241866#post2241866</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241865#post2241865</link>
          <description><![CDATA[<p>Is there not a way for you to transition to the permalinks plugin for this? It seems like it would address these issues quite well, and provide it's additional benefits? How extensive of a data set are you talking about?</p>]]></description>
          <pubDate>Wed, 21 Mar 2018 05:57:32 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241865#post2241865</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241864#post2241864</link>
          <description><![CDATA[<p>Correct (want this to happen in CMS).  There's another option I could do.  You see, I use this as a permalink.</p>
<p>Deborah - thank you for your response, but that's too late in the process.</p>
<p>What I want to ensure is that <a href="http://www.somesite.com/some-page-name" rel="nofollow">http://www.somesite.com/some-page-name</a> will be found in the database.  If the SEO page name (or permalink) is Some-Page-Name, it will not be found.  I need to ensure it will be.  Maybe there's another way around it when I read from the database, such as doing a case insensitive search for the value. </p>
<p>The other concern that I have is that each page MUST have a unique value and I'm afraid that Some-Page-Name and some-page-name are not identical and will not trigger the "unique" flag.  If I convert the value to lowercase BEFORE this unique comparison is done, they will be the same.</p>
<p>I was looking around the site to see if there was some documentation on writing add-ons.  I could use this approach if nothing else, but I don't know all the hook names for addAction.</p>
<p>I may just go this route if I can figure out how/where to use it.  Does anyone know if there are docs on creation of add-ons?</p>
<p>Thanks in advance.</p>
<p>Gary.</p>]]></description>
          <pubDate>Wed, 21 Mar 2018 04:54:17 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241864#post2241864</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241863#post2241863</link>
          <description><![CDATA[<p>I believe they want this to happen in the CMS as the info is being entered, or after its saved. </p>]]></description>
          <pubDate>Tue, 20 Mar 2018 18:36:13 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241863#post2241863</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241862#post2241862</link>
          <description><![CDATA[<p>Gary, I have this in my snippets library that might be what you're looking for:</p>
<p>&lt;?php echo strtolower($listingsRecord['property_type:label']) ?&gt;</p>
<p>(ref: <a href="http://php.net/manual/en/function.strtolower.php" rel="nofollow">http://php.net/manual/en/function.strtolower.php</a>)</p>
<p>~ Deborah</p>]]></description>
          <pubDate>Tue, 20 Mar 2018 17:06:46 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241862#post2241862</guid>
        </item>
                <item>
          <title>Force a field to lower case</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241861#post2241861</link>
          <description><![CDATA[<p>Is there a way to force a field to lower case?  For example, I have a field called seo_page_name.  (Yes, I've had this long before permalink plug-in existed.)  Sometimes users are not as diligent about making sure they use lower case in these fields.  I would like to force the field to lower case.  I know I can restrict them to using lower case letters, numbers and a dash only, but I would like to take whatever they type into this field and force it to lower case.  Is that possible?</p>

<p>Thanks,</p>
<p>Gary.</p>]]></description>
          <pubDate>Tue, 20 Mar 2018 16:51:14 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241861#post2241861</guid>
        </item>
              </channel>
    </rss>
  