I have imported two spreadsheets into two forms (Organizations and Contacts) to get some data into my application.
The Contacts spreadsheet (and form) contains a field with the name of the organization to which the contact belongs.
In the Contacts form I also have a
lookup field for the organization name, and now I need to go through every contact to look up the organization in the Organizations form in order to populate that field.
I've tried to automate this in Deluge but I don't know how to set the lookup value (which is a BIGINT) from Organizations the form.
Thanks
Alex