Can we change the behavior of the reference field to single line text when the name is not found
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2024 01:30 AM
HI All,
having a requirement that,
On the catalog form we have a reference field and referring to user table.
Can we make that reference field to single line text if the entered name is not there in the system.
And with that we can create a new record in the user table.
is there any possibility. Need suggestions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2024 01:47 AM
Hi @Community Alums ,
Instead of converting an existing reference variable to "Single Line Text", create a new "Single Line Text" variable from scratch.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2024 01:50 AM
HI,
No, You cant use the same variable/field to work as Reference as well as single line text.
What I would recommend is to add a checkbox which says 'cant find a value' next to the reference field, if the user clicks that flag you can make the Reference field not mandatory and show a single line text field (which is mandatory).
You should add a validation to ensure that one of the 2 fields (reference OR checkbox & Single Line Text) have a value before submission.