AnsweredAssumed Answered

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

Question asked by Kaorin on Aug 12, 2013
Latest reply on Aug 12, 2013 by philmodjunk

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

Outcomes