Setting a date field value that differs dependant on a drop down list selection - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Setting a date field value that differs dependant on a drop down list selection

Last post 07-27-2020 08:16 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-27-2020 05:22 AM

    Setting a date field value that differs dependant on a drop down list selection

    Hello,

     

    Apologies if in wrong area - mods feel free to move to the right place if necessary.

    I have a form which needs to set a date field differently ( + x amount of days) dependant on which of three options is contained in a field.

    This (review by) date field also needs to be able to be  updated over and over - for example if the form need reviewing on a monthly basis, it should update to the month after once it has been reviewed.

    Many thanks in advance for any assistance. 

  • 07-27-2020 08:16 AM In reply to

    Re: Setting a date field value that differs dependant on a drop down list selection

    You'll need to use rules for this. On the field with the three options, add your logic for setting the date for each condition (i.e. field1 = new, do this, field1 = old, do that). You'll also need to add submit logic to update the date for your additional logic. Whatever the button or action in the form that is taken to indicate "reviewed" you can either use substring formulas to increment just the month, or addDays to add a set number of days (realizing, of course, that months are never a set amount of days - you could use a secondary data source for that, but then you run into the leap year issue).
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.