-
try using the round() function in the formula:
round(100*substring-after(field, ":") div 60)
or use ToString("#.##") in the C# code:
(int.Parse(Temp[0]) + (double.Parse(Temp[1]) / 60)).ToString("#.##")
-
Hi,
I have a form where a user can pick multiple items from a repeating section drop down box, I am using the repeating selection because a multi-selection-dropdown doesnt work on web-enabled forms. What I cant figure out is how to merge the results of all repeated sections into a single (comma delimted) textbox or variable for later use.
The ...
-
The formula is working, but for some calculations it is adding 2 decimal points for calculations that go to infinity. I tried changing the field with the formula from Text to Decimal, but I get validation errors. Here is an example of what is occurring:
1:59 gets converted to 1.98.33333333333333
12:11 gets ...
-
Hi Jimmy,
You're absolutely right! Oh well, I guess I have to brush up on my SQL then. :)
Thank you so much.
- Ric
-
http://technet.microsoft.com/en-us/library/ms189499.aspx
Looks like that's happening because you're trying to insert the WHERE clause after the ORDER BY clause. That's not correct syntax, as far as I know.
-
Hi Hilary, Sorry to be back so soon! Guess what? :)
Yeah, I'm running into a problem. Since I'm using C#, I referred to this thread instead of the one with Microsoft. I studied the discussion and followed all your instructions including the use of first and second half substring manipulation. However, I'm ...
-
Yep, you're right. Sorry. I thought if I did that it would hide the table not the row. Thanks!
-
I have created a form library in SharePoint and instead of having them go to library to create a new doc I want the link to just open the form template.
So I have that setup and when they click the link, I have users getting this error when they try to open certain forms.
Insufficient Security Privelage:
This form cannot be opened ...
-
Hi all,
I am trying to create infopath form (using InfoPath 2003) based on several DB tables and I face the problem with optional sections. I don't know how to properly implement "one to zero or more" relationship in InfoPath. Please help. The problem is described below.
Example:
One table holds main data, e.g. Person. ...
-
Thank you so much Hilary. I really don't know how I would ever survive without you. You've been a great help to me and I'm very grateful for this.
Thanks again.
- Ric