0

Incrementing a field on record creation

I have a field called 'Image Number'  When I create a new record I want this filed to contain the current Image Number incremented by one.

Looking through other questions I tried the following code:

let temp := max((select photos).'Image Number');
'Image Number' := temp + 1

This is for "Trigger after update" .   When I creae a new record, the Image Number field is blank.  I believe I should be doing Trigger on create, but I don't see that option.

Thanks for your help.

5 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    Screen Shot 2019-02-24 at 6.18.49 PM

    • mango_balloon
    • 5 yrs ago
    • Reported - view

    Thank you.  I'll look for that.

    • mango_balloon
    • 5 yrs ago
    • Reported - view

    Thank you.  I updated the Trigger on create field with:

    let myVar := max(select photos).'Image Number';
    'Image Number' := myVar + 1

    Image Number is a number field.  The current value is 2300.  Every time I create a new record, I'm getting an Image Number value of 1.

    • Sean
    • 5 yrs ago
    • Reported - view

    Try changing

    max(select photos).'Image Number'

    to

    max((select photos).'Image Number')

    • mango_balloon
    • 5 yrs ago
    • Reported - view

    That was it.  THANK YOU!

Login to reply

Content aside

  • 5 yrs agoLast active
  • 5Replies
  • 1243Views