Changing a fields value to specific text - InfoPath Dev
in

InfoPath Dev

Changing a fields value to specific text

Last post 03-06-2013 01:32 AM by sicky. 10 replies.
Page 1 of 1 (11 items)
Sort Posts: Previous Next
  • 03-01-2013 02:29 AM

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Changing a fields value to specific text

    Hi peeps,
    Im fairly new for infopath.
    Ive been tasked with creating a signup form, for our buisness.
    Untill now i havent realy had that many issues in relation to infopath.....untill now.
    Basicly, we have 3 dropdown fields, APP_SECTOR, APP_LEVEL, and APP_TYPE and QUALIFICATION-dataentry.
    These contain this data:

    QUALIFICATION-dataentry this is the field which data id need changing

    APP_SECTOR::
    Health & Social Care
    Childcare
    Functional Skills,

    APP_LEVEL::
    1
    2
    3
    5

    APP_TYPE::
    Framework
    QCF Only
    Functional Skills

    What im trying to achive is have some rules set up so that a Fields Value is changed to a specific text, when certain fields of the dropdown boxes are met.
    For example,

    I have this Rule so far

    APP_SECTOR = "Health & Social Care" and
    APP_LEVEL = "2" and
    APP_TYPE = "Framework"

    Change Field Value QUALIFICATION-dataentry = "Health & Social Care"

    I think the ruling is correct and seems straight forward, but when the dropdowns are change to the above no data is displayed?
    am i doing something wrong here?
  • 03-04-2013 04:27 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    Hi Guys,
    I was wondering if someone could help me with this?
    Or explain another way to do this?
  • 03-04-2013 11:49 AM In reply to

    Re: Changing a fields value to specific text

    Are your dropdowns using different fields for Value and Display? If the dropdown is using an ID for the value, it would need to be set to the correct ID for "Health & Social Care" rather than the text.

    Hilary Stoupa

  • 03-05-2013 01:10 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    Hi Hillary, The dropdowns are as the default. so health and social would have a display of health and social, are you saying to change the Value to something shorter? ie Value= health Display=Health & Social Care, then use
    APP_SECTOR is equal to health, rather than Health & Social care? If so ive tried this and still the field remains unchanged, ive tried adding the rule to the "Data to be changed" field, and to the drop down box aswell.

    Does it matter what control the rule is on? as the outcomes the same?
  • 03-05-2013 07:04 AM In reply to

    Re: Changing a fields value to specific text

    Can you just attach a copy of your form? Under the Options tab ...
    Hilary Stoupa

  • 03-05-2013 07:36 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    Hi Hilary,
    My forms to big to upload,

    so ive put it in my googledrive for you,
    https://docs.google.com/file/d/0BywYL7Z47ObARjh3QXdBU0NXclE/edit
  • 03-05-2013 08:30 AM In reply to

    Re: Changing a fields value to specific text

    Great - can you give me access? I don't have a Google account.
    Hilary Stoupa

  • 03-05-2013 08:35 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    https://dl.dropbox.com/s/tzttejh7e5uokj3/Form4.xsn?token_hash=AAEUr2w1x5VGZ1FmhLHhQWzedDCH_1DsDnoSx_ox0VM5iA&dl=1 try my dropbox instead
  • 03-05-2013 03:06 PM In reply to

    Re: Changing a fields value to specific text

     Okay - you want your rule on the control that changes, not the target field. Remove the rule you have on QUALITIFCATION-dataentry - you don't want the field resetting itself.

    Based on your conditions, you need the same rule on three fields:

    APP_SECTOR
    APP_LEVEL
    APP_TYPE

    Rules fire when the field the rule is on changes. So, right now, your rule is only on APP_SECTOR. If you set it to "health" but APP_LEVEL and APP_TYPE are blank, your rule won't fire because the conditions won't be met. That's why you'll need the same rule on all three of those fields so that QUALITIFCATION-dataentry is set correctly when any of them change. You'll probably want to first add an action to clear the field as well - so that if the APP_LEVEL changes from 2 to 1 you don't leave the previous value in QUALITIFCATION-dataentry. Hope that makes sense!

    Hilary Stoupa

  • 03-06-2013 01:11 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    Hi Hilary
    Its still not applying the change to the data entry field, I have applied the following conditions to all 3 of the fields (APP_SECTOR,APP_LEVEL and APP_TYPE)

    APP_SECTOR "is equal to" health ( this is the actual value of the displayed item )
    and
    APP_LEVEL "is equal to" 2 ( again the value )
    and
    APP_TYPE "is equal to" frame ( again the value of the displayed item )
    Set fields Value: QUALIFICATION-dataentry = "Health & Social Care"

  • 03-06-2013 01:32 AM In reply to

    • sicky
    • Not Ranked
    • Joined on 03-01-2013
    • Posts 22

    Re: Changing a fields value to specific text

    Hi Hilary,
    Ive managed to do it, instead of tryin to set the field with a specific text,
    I changed the control to dropdown, and added the values that were required.

    Thank you so much for your help hilary, its very much appretiated
Page 1 of 1 (11 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.