Discussions

Expand all | Collapse all

auto populate information from another table

QuickBaseCoach Dev./Training10-19-2018 14:47

  • 1.  auto populate information from another table

    Posted 10-17-2018 02:26
    I have seen other users ask this question, but the responses all seem to be specific to their business (which is awesome customer service BTW), but I cant figure out how to translate it to my business needs...  So here we go.  I have a  table that has my customers list... in another table, I need to keep a record of charitable gaming winnings.  So I would like to have their ID number (as the key) auto populate their name and address into the charitable gaming log (2nd table).  I am sure that didn't make any sense... but hopefully you can decipher it!  It is clearly user error on my part, but I can't seem to figure it out!  Thanks!  


  • 2.  RE: auto populate information from another table

    Posted 10-17-2018 12:33
    You will need will set up a Relationship where 1 Customer has many Winnings.  

    Here is some help in Relationships

    https://help.quickbase.com/user-assistance/creating_a_relationship.html


  • 3.  RE: auto populate information from another table

    Bronze
    Contributor
    Posted 10-17-2018 17:41
    To add to Mark's comments, you would add the customer name and address as look up tables on the winnings table. The moment you specify customer ID on the winnings table, the winnings table will automatically bring over the values of the lookup fields.


  • 4.  RE: auto populate information from another table

    Posted 10-17-2018 18:34
    Thank you both very much...  So I have the relationship, and here is the relationship screen.  However, when I go to "add a new game", it doesn't give me the option to put the Id number in...  I have attached a screenshot of that as well.  

    Thank you all so very much for your help!  I promise I am learning!  
     





  • 5.  RE: auto populate information from another table

    Bronze
    Contributor
    Posted 10-17-2018 18:37
    The Id Number field on the winner's log table form should be editable.


  • 6.  RE: auto populate information from another table

    Posted 10-17-2018 18:43
    so how do i fix it so that it is?  


  • 7.  RE: auto populate information from another table

    Bronze
    Contributor
    Posted 10-17-2018 18:47
    By default it would be an editable field. I don't know why it shows as a read-only field on the form. Is the Id Number field shown on the form a formula field by any chance? Also, try to add the child record by clicking on the "Add Winner Log" field on the customer table and see what happens.


  • 8.  RE: auto populate information from another table

    Posted 10-17-2018 18:53
    it says "numeric (reference) on the gaming log form.  
    and if I go from the add winner log from the customer table, it still will not allow me to enter the id number


  • 9.  RE: auto populate information from another table

    Posted 10-17-2018 18:54
    maybe i made the "relationship" wrong?... I have the reference field being the ID number... should it be something different?  When I try to change the type of field for ID number, it will not allow me to change it... it says it will affect the relationship.


  • 10.  RE: auto populate information from another table

    Bronze
    Contributor
    Posted 10-17-2018 19:03
    Can you post the screenshot of the field definition of the ID Number field on the child table?


  • 11.  RE: auto populate information from another table

    Posted 10-17-2018 19:21
    sure.  ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1757244/RackMultipart20181017-9495-1qmrzi4-Screen_Shot_2018-10-17_at_3.20.16_PM_inline.png?1539804078">


  • 12.  RE: auto populate information from another table

    Posted 10-17-2018 20:31
    Melanie, that is weird.  Is there any chance that the ID Number field on the form is set to "Read Only" on  the form properties?


  • 13.  RE: auto populate information from another table

    Posted 10-18-2018 22:07
    it is not... 

    It is now allowing me to somewhat "edit" the field, but it is from a dropdown, not just a keyed in entry...  any thoughts?

    Maybe I need to just delete the relationship and start from scratch... if I was to do that, could you walk me thru exactly how to set up the relationships?  ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1757497/RackMultipart20181018-104670-nae8ie-Screen_Shot_2018-10-18_at_6.04.43_PM_inline.png?1539900450">


  • 14.  RE: auto populate information from another table

    Posted 10-18-2018 22:27
    I think I have figured out the problem... just not sure how to fix it.  

    The ID number box is, by default, a "record picker".  While I have been able to find how to change how the "records" are displayed, I would like to change this from having to pick from a dropdown list, to just manually entering the number.  There will end up being way too many customer ID numbers to scroll thru to find the write one for the game winnings log... if that makes sense.  


  • 15.  RE: auto populate information from another table

    Bronze
    Contributor
    Posted 10-19-2018 14:38
    Reference fields are always a dropdown or a popup. You can't change it to a normal data entry field where you can type in a value.


  • 16.  RE: auto populate information from another table

    Posted 10-19-2018 14:47
    I will post an answer later today.


  • 17.  RE: auto populate information from another table

    Posted 10-19-2018 16:05
    you have two or three choices.
    My best suggestion is to put in a ticket and ask to have your Realm be given access to the Type Ahead Record Picker.  That is a new feature in Early Access which will be pushed out to "GA" (General Availability) in a month or two.

    That improved record picker searches as you type, so the user can just start typing whatever and get a smaller and small list, the more they type.

    If you do want to limit the users to just key in a number, then copy the field for [Related Customer to a new field called [Customer ID entry].  Then change the field type for [Related Customer] to be a formula numeric field  equal to the [Customer ID entry]

    If you have existing data in your app, you may want to practise this in a copy of your app first so as to be sure not to lose data connecting the customers and their winnings.

    But really, just sign up for EA for Type ahead record picker and that will solve your issue.