- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2018 08:54 AM
I want to apply validations to email . AS i Can see field type=email in sys_glide_object table but not able to selct from reference in table when creating field 'Email Address'.
Solved! Go to Solution.
- Labels:
-
Best Practices

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2018 09:51 AM
This is a system limitation. Field validations only work within a form view. The best solution to working around this problem is to create a new 'List edit' ACL for your 'Email' field on your 'Persons' table to disable the list editing.
Please mark my response above correct if I've answered your question. Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2018 08:58 AM
Create it as a string field, then go into the dictionary entry for that field after it's created and you can change the field type there to the specific type of 'Email' field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2018 09:08 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2018 09:31 AM
Okay, it looks like you'll need to do a couple of additional steps to get this going the first time. Create your new field like this in your table creator...
Next, you'll need to update the 'write' ACL for the 'sys_glide_object' table to allow you to make the 'Email' value visible and selectable when changing field types. You can do this by navigating to 'System Security -> ACLs' in your left nav and finding the 'sys_glide_object' ACL for the 'write' operation. Once it's open you'll want to check the 'Admin overrides' checkbox and update the ACL.
Once that's done you should be able to navigate to 'sys_glide_object.list' using the search bar at the top of your left nav to open the 'Field class' table and find the 'Email' object. Open that record and check the 'Visible' checkbox.
Finally, open up the dictionary entry by clicking on the field name from the related list in the table creator form like this...
Once you're in the dictionary you can adjust the 'Type' field from 'String' to 'Email' and save.
Also note that once you've enabled the 'Email' option, this will be selectable for any new fields created from that point on. You don't have to go into the dictionary as a separate step, just select it as you're creating the field.
Please mark this answer as correct if I've answered your question. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-17-2019 11:34 AM