Forum Discussion

DeanOusterhout's avatar
DeanOusterhout
Qrew Assistant Captain
8 years ago

Rule is not updating date field used in link

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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.