2. ASPRunnerPro General questions
  3. Change 'Edit as' settings based on table
This topic is locked

Change 'Edit as' settings based on table

 		7/24/2009 4:26:04 PM
ASPRunnerPro General questions
T
 tjgarza author

Hello,

Is there a way to change "Edit as" settings based on a table. I would like to find a way to make the field formatting work in a similar fashion as a dependent dropdown. For example if a user is looking at a record that has some id variable A, then their Response would be in the form of "Text area". If they are looking at a B record, then their Response would be in the form of a drop down. Any help on this would be greatly appreciated.

Thanks!
J
 		Jane 7/28/2009

Hi,
I'm not sure that I understand your question.

All "edit as" settings are set up separately for each field.
T
 		tjgarza author 7/28/2009

Hi Jane,

Thanks for the reply, I'll try to expand further. I have a dozen different questionnaires, each with different questions and different response types. Rather than carrying along a dozen tables, I'd like to put them in one table, but to do this I need a way to change the field settings based on a questionnaire id variable at the row level. Here is an example:
Questionnaires (What the end user would see):

Questionnaire A

  1. When do you... (Answer is a date field with picker)

    Questionnaire B
  2. Please describe... (Answer would be a text area)
    Response Table (Edit only--user cannot add new rows):

    QuestionnaireID Response_1

    A 2009-07-28

    A 2010-07-29

    B Here is where the users text would go...

    B NULL (questionnaire not filled out yet)
    Field Table:

    QuestionnaireID Response_1_Type

    A Date

    B Text Area
    So the table I would be using for the project would be the response table, but I would like to change the field or "Edit As" settings based on the field table. Is this possible?

    Thanks!

    tj
J
 		Jane 7/29/2009

Unfortunately no.