I wanted to create a Simple Program in JO that pulls from a Data Designer. My last step of the Data Designer is a Formula Field (string type) that uses a Case statement to grab the Company ID from one field, unless it’s null, in which case it grabs the Company ID from a different field.
When setting up a Simple Program, it tells me that the Data Designer needs a Company ID field. It has one, it’s just that it’s a string-type instead of an ID-type.