Forum Discussion

ChristopherBins's avatar
ChristopherBins
Qrew Member
4 years ago

Using HTML and javascript to display information

Hello,  I was selected to design a quickbase for my team.  The only thing it is required to do is track certain data points on contacts the team receives.  Anything beyond that is at my discretion, b...
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
Quickbase is intended to be a low code - no code platform.  Just that we dumb this way way down?

Can you say in plain words what you were trying to do and we can probably just do it without any fancy code, just native Native Quickbase.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
ChristopherBins's avatar
ChristopherBins
Qrew Member
4 years ago

I want the user to be able to select an option in a dropdown.  Once the option is selected I would like the home page to display information based on their selection. 

I can't give specifics examples due to there being internal only information, so I'll try to use soccer as an analogy.  I would want the user to be able to select a soccer team using a dropdown.  Once selected, the quickbase would display the manager of the team, the owner of the team, and some interesting facts about the team.  Seeing all that information would be a secondary purpose for the quickbase.  The primary purpose would be for the user to be able to enter information about a contact with a person who is a fan of the team.  

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    So this is easy.  You will have a table called Teams info about the Teams.
    Then you will have a Table for Fan Registrations.

    Set up a Relationship where One Team has many Fan Registrations.   Look up all the fields you like down to Fan Registrations, such as Team Name, Owner, and fact 1, fact 2, fact, 3.

    In field Properties for [Related Team] set the Proxy field to be Team Name.  Put Team name on the form along with all the lookup fields.

    So user enters a record, and as soon as they select Team "Real Madrid" form the drop down list,  they will see all the lookup fields on the form.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------