[Common1]

Hi – In my Purchase Order workflow, I’m trying to ‘set field value’ from the Requisition field, that it was sourced from. How can I do that?

thanks very much,
This is a cached copy. Click here to see the original post.

[michoel]

Choose the “Formula” option in the Value section, and in the formula box, enter {createdfrom.fieldname}, changing fieldname to the internalid of the field in the Requisition you want to source.

[rudler]

Why not just {requisition.fieldname}? There’s only one parent?

On the flip side, I fooled around with trying to set values of childrecords. Could I reference, let’s say the newest or oldest subrecord, or the one with X value in field X?I found sporadic referencing (it seemed to go for the newest record in a Time record sublist, but nothing definitive in a custom subrecord sublist)
It would reference the value in one subrecord, but if another value was null of that same subrecord, it would move to another subrecord and take its value ????!!!
Case statements seem to work, but only in just one subrecord
I couldn’t compare values in subrecords (i.e. try to get the newest record, oldest, or the one with X value, and then get a another field value)

[Author]

Posts