InfoPath Dev

I am using the qRules DateDiff function to calculate weekdays a form stays open.  If the form gets closed within the same day it is created, the output is blank.  Is there a way I can have it output something, even if it is 1, for situations when the form gets closed within the same day?

I knew it was something silly.  You are correct in that discrepancyDetailTable was not the actual repeating group but the parent folder of the repeating group.  My actual repeating group was discrepancyDetail.  I changed it and now it is working properly.  Thank you as always!

Hi Hilary, I have attached the mapping file to my original post.  Thanks!

I am baffled.  I have used the SubmitToSharePointList command many times before successfully and I just can't seem to figure out what I am doing wrong here.  I have a form that has a repeating table in it.  I have the SubmitToSharePoint List command set up for submit as: SubmitToSharePointList ...

Actually your original assumption is correct Hilary.  I wanted a hyperlink as a column in my list.  Sorry if I confused you, but what you gave me works great!  Thanks!

Great suggestions Den12.  I'll definitely use them!

ah ha..never mind.  I realized that for a hyperlink column, the description field that dispays below it in edit mode will actually override how the hyperlink displays.  So when I typed View Form in the description, that appeared in place of the actual hyperlink, but the hyperlink was still accessible by clicking on View Form.  ...

Currently I don't have the SubmitToSharePointList set up and I was simply testing it by manually pasting the form generated url into the hyperlink field.  when I manually type , View Form at the end, it doesn't work, but I will try it again while actually submitting it with the service and see if it behaves differently.

Fantastic!  I created a hidden field in the form called linkToForm and added this formula to it: concat(SharePointListUrl(), "ARPD-", arpdNum, ".xml")   which concats the link of the list to the assigned form name.  Then submitted it to the hyperlink column in the list and it works great!  I have ...

Hello, I am using the SubmitToSharePointList tool.  I am wondering if it is possible to submit a link to the list that links back to the form so that if someone is looking at the list of items, they can click on one of the fields and open the original form, which will reside in a library in the same site.