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