How do I enforce input restrictions for external IDs, allowing only numeric values for field resources and letters/alphanumeric characters for buckets/groups?

You can configure restrictions for the users to specify for external IDs.

You can configure restrictions for the users to specify for external IDs, allowing only numeric values for field resources and letters/alphanumeric characters for buckets/groups using the User Types configuration page.

1. Click Configuration > User Types.
2. Select the user type for which you want to provide the access.
3. Go to the Screens tab and click Resources under Main.
4. Click Click to add and select Activate, Deactivate, Delete, Set Collaboration Group, and Unlock.
5. For each button that you just added, click Add new visibility and then click Save.
   You can apply the following visibility rules
   • Visibility Rule for Text Notice: Create a visibility rule that checks if the resource External Id contains numeric data. Apply this rule to the Text notice component to display it only when valid data is present.

   • Visibility Rule for Submit Button: Use the same visibility rule from step 1. Apply it to the Submit button to prevent submission when invalid data is detected.

You can use the following formula that checks the resource type and validates that the external ID is not empty.

resource.external_id <> toNumber(resource.external_id) AND resource.ptype = "<Resource Type Label>" AND NOT empty(resource.external_id)

For more information, refer to the Examples of Validation Rules topic in the Administering Oracle Field Services Guide.