Inserting Calculated Result after Get(lastmessagechoice)

Posted on 2006-06-01
Last Modified: 2010-04-27
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


Question by:Metius
    LVL 19

    Expert Comment

    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)
    LVL 28

    Accepted Solution

    why do you use a custom dialog box to define a field? why don't you make that field displayed directly as a radio button?

    Author Comment

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

    Expert Comment

    indeed, but that's more clicks!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now