Edit drop down list without affecting previously submitted forms - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Edit drop down list without affecting previously submitted forms

Last post 06-11-2021 11:18 AM by SeanPRyan. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-17-2020 12:29 PM

    Edit drop down list without affecting previously submitted forms

    At my work we have multiple buildings that often get used in different forms that i create. These buildings are in a list dropdown. We are adding a new building and getting rid of another. I can add the new building to the list easily enough, but how can i keep the old building, but not allow users to select it after a certain date? I don't just want to delete if from the list because it may cause issues with previously submitted forms.
  • 06-11-2021 11:18 AM In reply to

    • SeanPRyan
    • Top 200 Contributor
      Male
    • Joined on 02-02-2012
    • Kansas City area
    • Posts 52

    Re: Edit drop down list without affecting previously submitted forms

    Are you using Get choices from an external data source (If this is a list in SharePoint)?, If so, create a new column like Building Status. Give it values of Active and Inactive (or something similar). Now, on your form, add a filter to this connection and filter by Active.
    Sean
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.