Skip to main content

We have a Custom Field in Rental Transaction that is pulling Group ID from Serial Object. As Serial Objects gets update it then recalculates and updates the Custom Field in Rental Transactions.

 

We want to know what the Serial Object Group ID was at the point the Rental Transaction is created NOT the current Group ID.

 

How do we prevent the Custom Field from Updating if Serial Object is changed?

 

Thanks in advance,

Lisa

Could you make it a persistent field, that only allows insert perhaps?

Hi @anmise Thanks for responding.

 

Can I use Persistent Fields to pull the value at creation? Would I do this via a Custom Event? I cannot see an option to create a Persistent Field that pulls a value using SQL?

 

Thanks, 

@lisa.gilesAB what you would need to do is as follows:

  • create a persisted CF
  • create a custom event + SQL action to fetch the group id from SN and write into the CF. You also need to define the triggering point of the event → insert on rental transactions table or something else that would fit your business scenario.

@Marcel.Ausan Thank you so much for responding! That makes perfect sense! I will give it a go and see how I get on :-)

 

Thanks, Lisa

Hi @anmise Thanks for responding.

 

Can I use Persistent Fields to pull the value at creation? Would I do this via a Custom Event? I cannot see an option to create a Persistent Field that pulls a value using SQL?

 

Thanks, 

I see that @Marcel.Ausan already came to the rescue, but yes, a custom event was what I was thinking. Just need to avoid triggering and inserting on the same table, to avoid mutation errors, but you could possibly trigger based on event history or something.

Reply


Terms & ConditionsCookie settings