I would like to create a GS1 datamatrix in Excel with multiple identifiers and pieces of data. To do so I need to add application identifiers and in the case of a field with variable length a separator. How can I do that in quickchart. I tried:
=IMAGE(“https://quickchart.io/barcode?type=gs1datamatrix&text=”&B2)
B2 = 01Material1234567810Batch123 Which should read: (01)Material12345678(10)Batch123
In this case, I get a #connect! issue.
The only value that did generate a GS1 datamatrix was for
B2 = (93)123456
B2 = (10)Batch123 does not work. I am getting a #connect! error message