Can I refer to a field inside the same table?

BP6 · ‎04-14-2022

Weird question but can I create a Reference field that refers to another Field within the same table?

Filipe Cruz · ‎04-14-2022

Hello BP,

Sure!
That is done, for example, in the incident table, where the Parent field is a reference to the incident table.
Same happens in groups: A group record has a reference to the group table.

So what you are asking is perfectly normal!

Hope my answer clarifies your question!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

View solution in original post

OlaN · ‎04-14-2022

Hi,

You can only have one field on a table that is set to display=true
By setting a field to display=true will effectively remove it from any other field that had that value previously.

Optionally you can have a table without a field marked as display=true, but generally it's a bad idea, then the sys_id will be the default display value, and no one(?) wants to see a sys_id in a record picker...

BP6 · ‎04-15-2022

Thank you! That's very good to know.