Adding dropdown functionality to temporary studies

From CCMDB Wiki
Jump to navigation Jump to search

Legacy Content

This page contains Legacy Content.
  • Explanation: This was proposed at some point but since then there have been many tweaks to tmp and we seem to have figured out how to do drop downs. Taking out of potential changes. Can always put it back if still an issue.
  • Successor: No successor was entered

Click Expand to show legacy content.

It would be nice to have multiple dropdown fields for temporary studies. Right now, this can be accomodated only by using differently named "project" lines with the "item" lines the dropdown options. Problem with this is that it becomes non-intuitive to match project data later.

To add this functionality would likely take several days. Required steps:

  • add "dropdown" columns to s_tmp
  • and to L_tmpv2 in ccmdb_data.mdb
  • amend data entry forms to accomodate this new dropdown; the fields are already small, so we would likely have to spread them over two lines to make this fit
  • change the send functionality to accomodate new data structure
  • change the TmpV2_1.mdb to accomodate this new structure
  • Julie would need to update her code to accomodate new structure in TmpV2_1.mdb

Log

<outcome> we are achieving the same by making multiple entries, treating the "project" as field name and "item" as dropdown value. 2013-02-28 emailed Trish and Julie to explain requirements, wrote this article 2013-02-25 received email from Trish/Julie to request this