Field dropdown blank in Record Producer

kurtbell1 · ‎01-30-2017

I am creating a record producer for a table I created in a scoped app, but when I click "Map to Field" in my first variable, I look in the drop down for the list of fields it's completely empty.

Any idea what I'm doing wrong? The form is working just fine; this is an issue with the record producer.

kurtbell1 · ‎01-31-2017

I actually believe this might be a defect in ServiceNow. The table name in this example was quite long. I created a new table with the same columns, but with a shorter table name, and I did not run into this problem.

View solution in original post

rajeevlochan82 · ‎01-30-2017

which table you creating Record Producer and whats the field type of Variable in Record Producer. Can you give screenshot as well.

kurtbell1 · ‎01-30-2017

It's a new table, so I'm guessing this has something to do with ACLs or access but I can't figure out what. In this example, the field is a date.

Thanks!

ramak · ‎01-30-2017

If you are able to see the table name in the 'Record Producer Table' field, you must be able to see all the fields available on that table in the 'Field' drop down irrespective of the data-type of the new variable. Also if this is a new table, are there any ACLs ? If not, always better to create one...

Just try re-caching the instance, check/un-check the 'Map to Field' variable to see if the fields get populated. Also, are you in the right application scope ?

Cheers

rajeevlochan82 · ‎01-31-2017

Apart from ACL. Does your main table have any field of Type 'Date' ? What if you change 'Type' of variable from 'Date' to some other Type