locked
Populate Value from List based on 2 Column Selections RRS feed

  • Question

  • I am developing a hangar schedule list that needs to have the square footage of an aircraft populated based on 2 different selections.

    I Have two lists.

    1. The Schedule - Fields are Date arrive, date depart, Platform, Configuration (Folded / Spread), Sq Ft Req

    2. The Look up table - Fields are Platform, SQ Ft Folded, SQ Ft Spread.

    What I want to be able to happen is When the Platform and configuration is selected in the Schedule the Sq Ft Req is populated by pulling it from the look up table. What is the best way to go about this?

    I am a Site Collection Admin, I don't have access to the farm for VS type solutions. Hoping there is a simple way to do this I'm just not grasping.

    Friday, June 15, 2012 2:20 PM

Answers

  • Using SPD, you could build a workflow that populates the info.  It won't happen in real time like you've described, but you could do it in either the OnCreate or OnChange scenario, maybe both. So, it would be at least a two-step process whereas the user enters the base info, then saves the record.  Then the WF fires and populates the desired fields. 

    It's clunky, but it's SharePoint.


    Steve Clark, MCTS | Twin-Soft.com

    Friday, June 15, 2012 3:32 PM