I have a lookup field on a form. With that lookup field there are several secondary fields that I want to have autopopulate some read only textboxes when an item is selected. I KNOW that I have done this in the past, but I am at a loss with how to recreate it now! TIA for your help!
You can add a Calculated Value control to the form and configure the Formula to use the Lookup runtime function. This allows you to use the value of the lookup field in the Lookup runtime function pull and display data from a list.
Here's the format for the Lookup runtime function:
lookup(list title, column to filter on, value to filter on, output column)
Just to be clear, I want to reference additional columns from the lookup I've already established in SharePoint (example below).
Then I would have thought I could populate another field by setting the default value to one of the other fields already in the lookup (example below), but the values are not populating to the fields.
This combination is not going to work...
these 'additional fields' are not available in NEW form since nothing is yet stored in sharepoint so they do not have a source where they could be populated from.
on the other hand, default value is only evaluated and populated in NEW mode, not in EDIT mode.