GetNthRecord - How to remove "?" from the calculation result in the field
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 " ? ".