[SOLVED] Help with Creating a Query Field

I already read through it. Its a little confusing for me, so that's why I am here asking.

I understand about the raw data VS formatted. I get that.

The RAW data works for what I wanted to do however, with the email, I didn't really want it to display the actual e-mail address, but to display the "Send EMail" link for it to go to the page for the website to send out as a PHP email

So, is there an additional command I can add to [FIELD_NAME] that will display that RAW data as a link to PHP email page? Basically, to display like it does on the profile, if that field was public.

You can not get the Send Email with raw substitution. The Send Email is the formatted display of the Email field. If you want formatted display then you need to use the formatted display substitution then you need to make sure the field access is properly configured. This includes a tab the user can reach and the field being set to display on profile (the tab it self can be in a not shown on profile position). The email form also is not publicly visible by default, you need to enable public usage of the email form within CB > Configuration > General if you want public users to use it.

Ok, this is how I ended up solving the issue. I had to think a little bit outside of the box. So, I moved the original "email" field to my new public hidden tab. I set the parameters to not display on profile, but to show up on edit and registration like it already has.

I took the new CustomHTML field and used the [cb:userfield field="FIELD_NAME" /] coding to display the e-mail with the formatting and placed it in the protected Contact tab to display only to registered users. I then changed the list fields to the original "email" field that was now in the public hidden tab and uvula! It works! Probably not the best option, but it works!