0

How to make a field count upwards when another is changed automatically?

I have a "Last Worn" field date that i change, I then want the "Worn Count" number field to automatically increase by +1 every time i change the "Last Worn" date field. Is this possible?

4 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Hi,

    you can put this in the 'trigger after update' of the "Last Worn"-date field:

    "Worn Count" := "Worn Count" + 1

    Steven

    • Mark_Morris
    • 3 yrs ago
    • Reported - view

    Hi thank you for the quick reply. When i enter that into the trigger after update i get this message at the top of the screen. 

    End Expected: :=at line 1, coloumn 15

    I copied it as you wrote it;

    "Worn Count" := "Worn Count" + 1

    Thanks

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Sorry, it should be:

    'Worn Count' := 'Worn Count' + 1

    with single quotes that is.

    Steven

    • Mark_Morris
    • 3 yrs ago
    • Reported - view

    apologies i have sorted it out now as needed to use ' not " thanks for your help :)

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 593Views