InfoPath Dev

I have a form that needs to do some calculations on one of 20 or so columns.  It determines what column it needs each time by comparing a date field on the form (then there needs to be 20 conditional statements to find it ie: date > 1-1-09 or < 1-30-09) .  There are several places on the form where I ...

Sorry I'm still not getting it.  The links to the forms will be dynamic (and the form name itself has the spaces).  How can I use your method to get the absolute url to the forms from within infopath?  Is this easier than inserting a %20 into the title?  I will have the ID of the form, but formserver.aspx does not ...

Thanks for the response.  Maybe I'm missing something.  I'm getting the title by using a data connection to the document library and then filtering by the ID (the user submits this ID).  The only column I can retrieve that has the form name is Title.  I'm not able to get Name or the file name.    

I'm trying to add a hyperlink in a form that references another form.  The form link is based off of the other form title in the document library.  Unfortunately the titles have spaces in them so I need to replace the spaces with a %20.  I've tried doing this: translate(title," ", "%20"), but it only ...

I'm using an information gather workflow on a completed infopath form that writes the gathered info to a column "Ticket".  I see the data in the column, but I can't seem to have this value show up as a field item in the form itself.  I've tried setting up a data connection to the library (selecting only ...