Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Unanswered

How to let user enter manually input from lookup field

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

I currently need help with how to let the user can manually input from a lookup field with a many-to-one relationship from the contact_form table to Contact table. If we established this relationship by using a look up column, then the user can only select the email has been created in the Contact table. Much appreciated

 

Kind Regards

LinhHoang

Categories:
  • oliver.rodrigues Profile Picture
    9,315 Most Valuable Professional on at
    Re: How to let user enter manually input from lookup field

    I don't think I understood the problem really

    Once you click on the Search, does it bring the lookup modal? 

    Would you be looking at an autocomplete dropdown? 

    http://oliverrodrigues365.com/2022/08/04/power-pages-autocomplete-dropdown/

     

  • Fubar Profile Picture
    7,955 Super User 2025 Season 1 on at
    Re: How to let user enter manually input from lookup field

    You cannot type directly in to a lookup field.

    You user would need a Table Permission that provides enough privileges to read, create, and append/append to (I can never remember which one it should be for append/append to).

    On the basic form add a metadata record for the lookup attribute, set the Basic Form for Create field. to a basic form that will let them create the email address record  When they open the Lookup control on the portal they should then get the list and also a 'New' button.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >