3 Replies Latest reply on Aug 12, 2013 8:14 AM by philmodjunk

    GetNthRecord - How to remove "?" from the calculation result in the field

    Kaorin

      Title

      GetNthRecord - How to remove "?" from the calculation result in the field

      Post

           I have the script to transfer the result of COLOURS belongs to specific Fabric Code.

           The script is:

           Set Field [GetNthRecord(test_spec_test_fabric_info_colours::Colourway Body; 1)]

           ...and then I have 6 of these to transfer up to 6 colouways.

           Some Fabric Codes only have , say 2 colourways.  In that case when I run the script it enters "?" for the last 4 fields.

           What do I need to add to the calculation (or any otherway?)  in order to keep the blank records as blank in the field rather than having displaying " ? ".

           Thank you.

            

      Screen_Shot_2013-08-12_at_15.20.14.png