Rule is not updating date field used in link

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Acknowledged
I have a rule that is not working.

"When PaymentDate-RptLink is not equal to the value in PaymentDate, change PaymentDate-RptLink to the value in PaymentDate "

The PaymentDate-RptLink is a Date type, and used in a reference to a RptDaily table that has the id also defined as Date.

When I am in edit mode on the Payment table and change the PaymentDate, I am expecting the PaymentDate-RptLink to also change.  It is not changing.

After creating or adding a record to the payment table, if I go back in to edit, the PaymentDate-RptLink is a dropdown, showing records from the rptDaily table.  The problem is that it shows fields like this:

Unknown RptDaily (-9223...)

If I click the dropdown, it shows not date fields, but "12-09-2017 - 0 - 0"


Any ideas?

Thanks in advance,
Dean
Photo of Dean

Dean

  • 532 Points 500 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
What is the key field in the table RptDaily?
Photo of Dean

Dean

  • 532 Points 500 badge 2x thumb
rptDate with a type of Date.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
If you always want the [PaymentDate-RptLink] field to always equal the value in the field [PaymentDate], you could make it a formula field.  I suggest tryng that in a copy of your app.

As for the display showing '12-09-2017 - 0 - 0"

Those are the record picker fields showing.  They are set in the Advanced Properties for the  RptDaily table.  They help users "pick records from a drop down.