Discussions

 View Only
  • 1.  Field not updating table

    Posted 06-25-2020 16:49
    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 06-26-2020 04:20
    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 06-30-2020 13:02
    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 06-30-2020 13:05
    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 07-07-2020 17:27
    Edited by Katherine Park 07-08-2020 14:33
    No, it's only on the form once. 


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



  • 6.  RE: Field not updating table

    Posted 07-07-2020 20:01
    Edited by Mark Shnier (Your Quickbase Coach) 07-08-2020 15:15
    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 07-08-2020 14:23
    Edited by Katherine Park 07-08-2020 14:58
    Thank you for the offer. I don't believe my company would allow me to zoom.

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