How to choose field type as email?As I can see email as field type the sys_glide_object but i want to use it i am not able to see the reference of field when creating fields in table?

VandyLearner
Tera Contributor

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'.

1 ACCEPTED SOLUTION

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!

View solution in original post

11 REPLIES 11

Mark Stanger
Giga Sage

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.

I have tried it already . It didn't work.

find_real_file.png

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...

find_real_file.png

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.

find_real_file.png

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.

find_real_file.png

Finally, open up the dictionary entry by clicking on the field name from the related list in the table creator form like this...

find_real_file.png

Once you're in the dictionary you can adjust the 'Type' field from 'String' to 'Email' and save.

find_real_file.png

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!

Hi there,

I did as you shown above but its not getting clicked.

 

find_real_file.png

 

Please help me here.