6 Replies Latest reply on Jan 14, 2009 6:27 PM by disabled_menno

    FM8.5 WinXP Get(ActiveFieldName) does not work

    ptxdiez_1

      Title

      FM8.5 WinXP Get(ActiveFieldName) does not work

      Post

      <!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:HyphenationZone>21</w:HyphenationZone>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- [if !mso]><object classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif] --><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} @page Section1      {size:612.0pt 792.0pt;      margin:70.85pt 3.0cm 70.85pt 3.0cm;      mso-header-margin:36.0pt;      mso-footer-margin:36.0pt;      mso-paper-source:0;} div.Section1      {page:Section1;} --> 

      FileMaker Pro 8.5

      Win XP sp3

      I’ve got a table with three fields defined:

      field 1             text

      field 2             calc      = Get ( ActiveFieldName )

      field 3             calc      = Get ( ActiveFieldContents )

      After entering data into field 1(i.e. “xxx”) and being it active, I have nothing in field 2 and field 3 when I shoud get “field 1” and “xxx” respectively.

       

      What I’m doing wrong?

       

      Thanks

        • 1. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
          RSchaub
             Your calculations are unstored .... Correct?
          • 2. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
            raybaudi
              

            Hi ptxdiez

             

            FileMaker ( till 9 ) evaluates on field exit or on committ record.

             

            When you are into field1 no calculation is evaluated.

             

            When you exit field1 there is no more an active field.

             

            So ( and that real matter ) what are you after ?

            • 3. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
              ptxdiez_1
                 <!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:WordDocument&gt;   &lt;w:View&gt;Normal&lt;/w:View&gt;   &lt;w:Zoom&gt;0&lt;/w:Zoom&gt;   &lt;w:HyphenationZone&gt;21&lt;/w:HyphenationZone&gt;   &lt;w:PunctuationKerning/&gt;   &lt;w:ValidateAgainstSchemas/&gt;   &lt;w:SaveIfXMLInvalid&gt;false&lt;/w:SaveIfXMLInvalid&gt;   &lt;w:IgnoreMixedContent&gt;false&lt;/w:IgnoreMixedContent&gt;   &lt;w:AlwaysShowPlaceholderText&gt;false&lt;/w:AlwaysShowPlaceholderText&gt;   &lt;w:Compatibility&gt;    &lt;w:BreakWrappedTables/&gt;    &lt;w:SnapToGridInCell/&gt;    &lt;w:WrapTextWithPunct/&gt;    &lt;w:UseAsianBreakRules/&gt;    &lt;w:DontGrowAutofit/&gt;   &lt;/w:Compatibility&gt;   &lt;w:BrowserLevel&gt;MicrosoftInternetExplorer4&lt;/w:BrowserLevel&gt; &lt;/w:WordDocument&gt; &lt;/xml&gt;&lt;![endif]  --><!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:LatentStyles DefLockedState=&quot;false&quot; LatentStyleCount=&quot;156&quot;&gt; &lt;/w:LatentStyles&gt; &lt;/xml&gt;&lt;![endif]  --><!--  [if !mso]&gt;&lt;object classid=&quot;clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D&quot; id=ieooui&gt;&lt;/object&gt; &lt;style&gt; st1\:*{behavior:url(#ieooui) } &lt;/style&gt; &lt;![endif]  --><!--  /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:&quot;&quot;;      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&quot;Times New Roman&quot;;      mso-fareast-font-family:&quot;Times New Roman&quot;;} @page Section1      {size:595.3pt 841.9pt;      margin:70.85pt 3.0cm 70.85pt 3.0cm;      mso-header-margin:35.4pt;      mso-footer-margin:35.4pt;      mso-paper-source:0;} div.Section1      {page:Section1;}   --><!--  [if gte mso 10]&gt; &lt;style&gt; /* Style Definitions */ table.MsoNormalTable      {mso-style-name:&quot;Tabla normal&quot;;      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:&quot;&quot;;      mso-padding-alt:0cm 5.4pt 0cm 5.4pt;      mso-para-margin:0cm;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:&quot;Times New Roman&quot;;      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} &lt;/style&gt; &lt;![endif]  -->

              Hi, Daniele:

              Thanks for your answer.

               

              That table has a fourth field, calculation, defined as “field 1 & field 2”, global storage, that have the purpose of being a search-chain to tiger a script to do different things depending on the content of that 4th field.

               

              In fact, this field 1 is not a unique field: there are 21 “field 1_n” on each record, so instead of building 21 scripts to be triggered, I tray an if-else script to be launched according to the contents on field 4.

               

              I’m Spanish and I’m sure my English is much worse than yours.

              Anyway, thanks again.

               

              Pachi

              • 4. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
                ptxdiez_1
                  

                Hi Robert:

                They have the checkbox "all" marked.

                 

                Thanks

                pachi

                • 5. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
                  raybaudi
                    

                  > In fact, this field 1 is not a unique field: there are 21 “field 1_n” on each record, so instead of building 21 scripts to be triggered, I tray an if-else script to be launched according to the contents on field 4.

                   

                  Are you saying that field1 is a repeating field with n repetitions ?

                   

                  If so you do not need other fields but only an oculate use of the tool tips, the $var and the script parameter.

                  • 6. Re: FM8.5 WinXP Get(ActiveFieldName) does not work
                      

                    Hi ptxdiez,

                     

                    Get ( ActiveFieldName ) and Get ( ActiveFieldContents ) are not intended to be used in Fieldcalculations ... they would show a global result anyway :) These calculations are intended to be used in scripts:

                    In a script you could loop through fields in a layout without knowing exactly in which field you are .... You could then have a line in you script to check if your cursor is in field "date" by using the formula:

                    Get ( ActiveFieldName )="date"

                    and if that calc is true then you could check for the contents to be a certain date like this:

                    Get ( ActiveFieldContents )=Date ( 1 ; 15 ; 2009 )

                     

                    regards, Menno