Field not updating table

Question

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
------------------------------

markshnier__you · Answer

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

katherinepark · Answer

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
------------------------------

markshnier__you · Answer

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
------------------------------

katherinepark · Answer

No, it's only on the form once.&nbsp;

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

markshnier__you · Answer

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.&nbsp; It has to be something simple.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com-------------------------------------------------------------------------Original Message:Sent: 06-30-2020 13:04From: Mark Shnier (YQC)Subject: Field not updating tableIs it possible that you have the $ amount field on the form twice?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.comOriginal Message:Sent: 06-30-2020 13:02From: Katherine ParkSubject: Field not updating tableThe 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 ParkOriginal Message:Sent: 06-26-2020 04:20From: Mark Shnier (YQC)Subject: Field not updating tableIs the drop down from a relationship?can you tell us what the two tables represent in your app?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.comOriginal Message:Sent: 06-25-2020 16:48From: Katherine ParkSubject: Field not updating tableI 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------------------------------

Forum Discussion

Field not updating table

Related Content

User field not updating

Nesting API Button Help (Add record and update another)

Child Table Field Question

Table is missing

Reference tables quandary