Bookseller here trying to survive by listing on Amazon. I have lots of books that are so old ISBNs didn’t exist when they were published. For those books, Amazon offers what they call a “GTIN” exemption. So I have two fields: (1) a single line field called {Product ID}, which contains an ISBN if available, but is, otherwise, left blank; and (2) and a formula field called {Product ID Type}, which needs to contain “ISBN” if {Product ID} is NOT blank or “GTIN” if {Product ID} is blank. I have no idea what might work here. Fingers crossed that one of you do. 
Page 1 / 1
Hi again, @Alba_Machado2
IF({Product ID}, "ISBN", "GTIN")
So elegant! Thanks again! I’m feeling significantly less overwhelmed by the prospect of having to create a table that accommodates Amazon’s 200+ fields in order to save my little old book business. 
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.