Skip to main content
Question

Related table value with conditional dropdown gets set to 0

  • November 1, 2023
  • 0 replies
  • 88 views

Forum|alt.badge.img+4

Background: Workstation Hardware (child) and Tracking Board Master (parent) are related with a conditional choice. Please see screenshot below.

Issue: We are running into this issue where repeatedly the related table field on many rows is getting set to 0. It seems QuickBase Actions or Pipelines are changing this. But there is no pipeline or QB action that is changing the selection in for the dependent Related field to be nulled. Nor are any of the actions or pipelines changing the Related Tracking Board Master field itself. This one is really stumping us. We have multiple such relationships built in our database, but none of them are behaving this way. Seems like a bug. Any suggestions on how to debug this further? 

Thanks a lot. Uma



------------------------------
Uma Harithsa
Trinity Health
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Registered
  • November 1, 2023

Do you have a form rule that is trying to populate it? Or is there an import that you do/have done previously through Excel that would have provided a null/0 value when you loaded data?



------------------------------
Chayce Duncan
------------------------------

MarceloBenavide
Forum|alt.badge.img+8

Hi, check the USED tab for this field.   And , I'm sure any component did the chenge, check each pipelines and actions.



------------------------------
Marcelo Benavides
------------------------------

MarceloBenavide
Forum|alt.badge.img+8

Hi, ok, so i suggested, create a "log" pipeline, when the field change to 0 save a record in other table with date, user, and all information that you think is important.

Thank you

Marcelo Benavides Torres



------------------------------
Marcelo Benavides
------------------------------