Set Lookup Field with Deluge
Hi
i want to set the value of a lookup field by deluge and this does not work somehow
- there are two forms: TRANSFER and ENTRY
- when TRANSFER is saved, this workflow should create a correspondig record ENTRY, setting several fields and should set a "back-reference in TRANSFER to the field "Entry_from" (this is a lookup field referencing to ENTRY)
- "rec" is an object-handle for the current TRANSFER document
- "b" is the ID of the newly created ENTRY record (type bigint)
- the last line should set the back reference to the new ENTRY
- everything works (ENTRY is created with correct values), but the back reference appears as empty, or does not show the backlinked record
Documentation says a lookup field should contain the ID of the corresponding record
rec = TRANSFER[ID == input.ID];
b = insert into ENTRY
[
Added_User=zoho.loginuser
Number="TEST " + rec.Transfer_Number.toString()
Booking=rec.Booking
Amount=rec.Amount
Invoice_Type="incoming"
Status="paid"
Account=rec.Account_From
Account_Statement=rec.Account_Statement_From
];
//does not work !!
rec.Entry_From=b;
thank you!
kind regards
Lambert