<div>
I assume you meant &quot;Set Field&quot; not &quot;Select Field?&quot;<br />
<br />
It sounds like the field is defined as a number rather than a text field. That will cause it to display a zero when you insert a text value into it. Change the field's definition to be a text field.<br />
<br />
Another suggestion:<br />
Instead of using a series of script steps to check the lastmessagechoice and set the field, you can do the whole thing in a single step using the a set field script step to assign the field the value of the Case() function, like this:<br />
<br />
Case ( get(LastMessageChoice) = 1; &quot;Order&quot;; get(LastMessageChoice) = 2; &quot;Second Option&quot;; get(LastMessageChoice) = 3; &quot;Third Option)<br />
&nbsp; <br />

</div>


I assume you meant "Set Field" not "Select Field?"

It sounds like the field is defined as a number rather than a text field. That will cause it to display a zero when you insert a text value into it. Change the field's definition to be a text field.

Another suggestion:
Instead of using a series of script steps to check the lastmessagechoice and set the field, you can do the whole thing in a single step using the a set field script step to assign the field the value of the Case() function, like this:

Case ( get(LastMessageChoice) = 1; "Order"; get(LastMessageChoice) = 2; "Second Option"; get(LastMessageChoice) = 3; "Third Option)
 


<div>
Thanks for the response .... the case function is very neat. &nbsp;Thanks
</div>


Thanks for the response .... the case function is very neat.  Thanks

<div>
indeed, but that's more clicks!
</div>


<div>
<div class="content wysiwyg-content">
I'm running a script which asks the user to select 1 of 3 choices from the custom dialog box. &nbsp;I want to set the field value based on the response. &nbsp;I'm using - If get(lastmessagechoice) = &quot;1&quot; select field = &quot;order&quot;. &nbsp;However the result I get is that a &quot;0&quot; is inserted into the field rather then &quot;order&quot;<br />
<br />
Appreciate any help<br />
<br />
Thanks<br />
<br />

</div>
</div>


I'm running a script which asks the user to select 1 of 3 choices from the custom dialog box.  I want to set the field value based on the response.  I'm using - If get(lastmessagechoice) = "1" select field = "order".  However the result I get is that a "0" is inserted into the field rather then "order"

Appreciate any help

Thanks



Inserting Calculated Result after Get(lastmessagechoice)

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.