Forum Discussion

Zachary's avatar
Zachary
Ideator I
6 years ago

How to Set RelationShip field value result as onFormPopulated ?

I have a itemtype call 'Part' ,  Part has a field call 'part price'  (type is decimal) Part has a relationship call Part_detail Part_detail has a field call 'RP price' (type is int). I nee...
Forms
JavaScript
Relationships
Zachary's avatar
Zachary
Ideator I
6 years ago

HI Angelalp !

This way will change all the fields in ARAS, I only need to change specific fields, I hope there is a more suitable method for me.
thank you!!

  • prafulsh_gurav_gmail_com's avatar
    prafulsh_gurav_gmail_com
    Ideator I
    6 years ago

    Hello Zachary,

    You can try adding one federated property on relationship item type,also on that relationship item type add server event "OnAfterGet" and update that property using this.setProperty(PropertyName, Value);

    this will have all items in relationship so use this.getItemCount() to get all item and update specific item using for loop.

    • Zachary's avatar
      Zachary
      Ideator I
      6 years ago

      Hi, thanks for reply !

      This method will change the data in the database, and because the data type ( decimal & int ) can not use setProperty set the thousand separator in it, so this method is not suitable for me, thank you!

      • prafulsh_gurav_gmail_com's avatar
        prafulsh_gurav_gmail_com
        Ideator I
        6 years ago

        Hi Zachary,

        Data will not saved to database if property is federated.

        Check this out : 

        Also you cannot find that property in database.

        Thanks