How to create a new reference value on record using Table API

[JordanDR]

Hello community,

We are currently investigating using the Table API to populate some fields on the sys_user table, specifically reference tables. Is it possible for the Table API to create a new value and display it in the field?

For example, if we try to populate those reference fields with a value that is not yet on the reference table, the table API will not return an error for any non-existent value, but it will save the value is the field but display as blank.

Thanks!

[Allen Andreas]

Hi,

You'd have to create the record on the referenced table and then reference that...in the reference field.

Otherwise, as you've mentioned, you'll see it blank, but technically, it has a value "undefined" and when looking at the form in an instance, if you have the "preview" option on and are looking at that field, you'll see the (i) info icon next to it as if it would show you a real record's preview, but the record doesn't exist.