Discussions

 View Only
Expand all | Collapse all

Rule is not updating date field used in link

  • 1.  Rule is not updating date field used in link

    Posted 12-09-2017 14:06
    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


  • 2.  RE: Rule is not updating date field used in link

    Posted 12-09-2017 14:52
    What is the key field in the table RptDaily?


  • 3.  RE: Rule is not updating date field used in link

    Posted 12-09-2017 15:07
    rptDate with a type of Date.


  • 4.  RE: Rule is not updating date field used in link

    Posted 12-09-2017 18:24
    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.