Hi :)
I just tried to create a unique index in 8.1 and I failed to do so in some cases.
On a custom form I can create unique (or not unique) indexes simply using the list which is in "unique index" column in the form "Definitions" tab, "Indexes" part.
Though if I want to do so on a "base" form (let's say "HPD:Help Desk") I can't.
I overlay the form.
I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index, I can choose fields, works ok, BUT I can't choose if the index is unique or not, it seems it's set to "No" and you don't have the "list" to choose "yes".
As a test I created a simple regular form and tried to define an index, I could see the "list" in "Unique" column so I can choose "yes" or "no" (03.png):
I don't actually create the index and I converted my custom form to "base" and I tried to create the same index on the overlay, so:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index and this time no way to get the list so I can't select "yes" (04.png):
The workaround I found is to:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive",
-> I save the form,
-> I switch to "base development",
-> I open the form,
-> I go to "Definitions" tab, the "Indexes" part, I add the index there (I can choose "yes" or "no" there) ,
-> I save the form,
-> I switch back to "best practice" mode,
-> I open the overlay form,
-> I can see my index,
Do you have the same behavior?
Best regards.
Laurent.
_ARSlist: "Where the Answers Are" and have been for 20 years_
I just tried to create a unique index in 8.1 and I failed to do so in some cases.
On a custom form I can create unique (or not unique) indexes simply using the list which is in "unique index" column in the form "Definitions" tab, "Indexes" part.
Though if I want to do so on a "base" form (let's say "HPD:Help Desk") I can't.
I overlay the form.
I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index, I can choose fields, works ok, BUT I can't choose if the index is unique or not, it seems it's set to "No" and you don't have the "list" to choose "yes".
As a test I created a simple regular form and tried to define an index, I could see the "list" in "Unique" column so I can choose "yes" or "no" (03.png):
I don't actually create the index and I converted my custom form to "base" and I tried to create the same index on the overlay, so:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index and this time no way to get the list so I can't select "yes" (04.png):
The workaround I found is to:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive",
-> I save the form,
-> I switch to "base development",
-> I open the form,
-> I go to "Definitions" tab, the "Indexes" part, I add the index there (I can choose "yes" or "no" there) ,
-> I save the form,
-> I switch back to "best practice" mode,
-> I open the overlay form,
-> I can see my index,
Do you have the same behavior?
Best regards.
Laurent.