AnsweredAssumed Answered

Prevent data from being deleted when linked to another field

Question asked by danek on Sep 25, 2018
Latest reply on Sep 25, 2018 by philmodjunk

Hello, i have two fields linked together: A ""Parser" field and a "output" field. What I am doing is scanning in a barcode with text data attached to it. I want to populated the "output" field with part of the text data, so I created a "parser" field and told the "output" field to perform this calculation:

 

Left ( Parser ; Position ( Parser ; "-" ; 1 ; 1 ) -1 )

 

Which parses the text in the "parser" field by the "-", and returns the first part of the field. The problem with this is I have multiple barcodes I need to scan, so I want to delete the data in the "parser" field. This deletes the data in the "output" field.

 

What calculations step can I add to the "output" field's calculation to prevent the field from being deleted?

 

thanks!

Outcomes