Form is changing emails to have capital letters

I made a form that uses special values for grabbing the user email, but when it sends the data to its tab, it capitalizes the G in gmail. That causes problems in my lookup that uses the email address to lookup name and image, because it doesn’t recognize the email with a capital in it. Any ideas why this is happening?

Did the user sign in with a capital ‘G’ in the email?

Not sure the problem lies with the user or Glide, but for a temporary workaround you can use an arrayformula with Lower function and use that for your lookup.

1 Like