I am creating a bid list from which I would like to pull the low bid and corresponding vendor name to have displayed in JOB::VendorBid_WinningBid and JOB::VendorBid_WinningVendor.
The list has JOB::ContactID_VendorBid (repeating field), which uses a value list drop-down to select the vendor ID – this entry supplies the vendor name in JOB::VendorBid_ContactName (repeating field). Manual entries in three currency fields total in JOB::VendorBid_Total (repeating field). I would like JOB::VendorBid_WinningBid to pull the lowest of the JOB::VendorBid_Total values, and JOB::VendorBid_WinningVendor to pull the corresponding entry from JOB::VendorBid_ContactName.
Can this be done using field calculations? Or does it have to be done using a button/script?