Newbie Questions

Re: Calculated column question for infopath designer 2013

reymon1122 — Thu, 04 Aug 2016 00:38:47 GMT

Works perfectly. Thanks Hillary!

Re: Calculated column question for infopath designer 2013

Hilary Stoupa — Mon, 01 Aug 2016 18:02:23 GMT

Rules are on form load and field 2. Save the form locally, right click design and preview.

Re: Calculated column question for infopath designer 2013

reymon1122 — Sat, 30 Jul 2016 05:22:15 GMT

Hi Hilary, Please see attached form sample. The certificate status field with have a return value of either Current or Expired, based on the expiration date field. IF the expiration date is less than the today's date the return value in the status field is expired, and current if its equal or more than todays date. I tried the formula that i created in SP10 but im getting a error, Could you please provide the correct formula. So sorry i'm just starting with SP and infopath. I don't know if this is possible, but your help is much appreciated

Re: Calculated column question for infopath designer 2013

Hilary Stoupa — Thu, 28 Jul 2016 21:36:34 GMT

You'll probably need to instead use a rule on the Expiration Date field. So in InfoPath Designer, on the Expiration date, you'd add two rules. One have the condition that if the date is less than today (use a formula, then use the today function) set the field that needs the value to Expire. The other rule, also on the expired field, would be if the date is greater than or equal to today, set the field to Current. HOWEVER - that would only run when the expiration date changes.... So - I'm wondering if what you really need here is SharePoint workflow?

Re: Calculated column question for infopath designer 2013

reymon1122 — Thu, 28 Jul 2016 19:50:25 GMT

Hi Hillary,

This is the formula I used in SP2010. But when I tried to modify form in InfoPath i'm getting a syntax error for the formula below.

Thanks for the reply. Appreciate very much.!!

=IF([expiration date]<Today,"Expire","Current")

Re: Calculated column question for infopath designer 2013

Hilary Stoupa — Thu, 28 Jul 2016 19:41:55 GMT

Did part of your formula cut off? I think you are saying that when you modify the list form in InfoPath, something stops working in your calculated column?

Calculated column question for infopath designer 2013

reymon1122 — Sun, 24 Jul 2016 03:36:52 GMT

Hi, Newbie here and currently working on infopath designer 2013 to customize my sharepoint 2010 list. I have a calculated column name '"status" that will return a value of " Current " or " Expired" based on the data entered on the column name Expiration Date. Formula on the Status column is =IF([expiration date]