Discussions

Expand all | Collapse all

Field not updating table

  • 1.  Field not updating table

    Posted 18 days ago
    I am a new to QB. I have a form which has two fields. One is a drop down box that based on the selection an amount populates into the other field. The amount shows on the form like I want but it is not updating the table the form is linked to. Why?

    ------------------------------
    Katherine Park
    ------------------------------


  • 2.  RE: Field not updating table

    Posted 18 days ago
    Is the drop down from a relationship?

    can you tell us what the two tables represent in your app?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Field not updating table

    Posted 13 days ago
    The drop down is not from a relationship. I have a field called Current Medal that is a is an input field with a list of medals to choose from. In the table there are fields that are those medals that have $ amounts associated with them. In the dynamic form rules I state that if you choose a particular medal in the Current Medal field to populate the Award field with the associated $ amount. It works correctly on the form but in the underlying table it doesn't update even when you hit save.

    ------------------------------
    Katherine Park
    ------------------------------



  • 4.  RE: Field not updating table

    Posted 13 days ago
    Is it possible that you have the $ amount field on the form twice?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Field not updating table

    Posted 6 days ago
    Edited by Katherine Park 5 days ago
    No, it's only on the form once. 


    ------------------------------
    Katherine Park
    ------------------------------



  • 6.  RE: Field not updating table

    Posted 6 days ago
    Edited by Mark Shnier (YQC) 5 days ago
    If you like you can contact me directly by email and I will do a quick zoom session to sort you out at no cost.  It has to be something simple.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Field not updating table

    Posted 5 days ago
    Edited by Katherine Park 5 days ago
    Thank you for the offer. I don't believe my company would allow me to zoom.

    ------------------------------
    Katherine Park
    ------------------------------