Skip to main content
Question

Rule is not updating date field used in link

  • December 9, 2017
  • 0 replies
  • 28 views
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
      This topic has been closed for replies.

      What is the key field in the table RptDaily?
      • DeanOusterhout
      • Author
      • Registered
      • December 9, 2017
      rptDate with a type of Date.
      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.
      Terms & ConditionsAccessibility statement