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
- 
  
Hi,
you can put this in the 'trigger after update' of the "Last Worn"-date field:
"Worn Count" := "Worn Count" + 1
Steven
 - 
  
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
 - 
  
Sorry, it should be:
'Worn Count' := 'Worn Count' + 1
with single quotes that is.
Steven
 - 
  
apologies i have sorted it out now as needed to use ' not " thanks for your help :)
 
Content aside
- 5 yrs agoLast active
 - 4Replies
 - 595Views
 
