SharePoint Integration

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Tue, 12 May 2009 19:50:59 GMT

Hilary,

It worked! Thanks. Still trying to compare a field that is already in the list. I'll ask that in a new post. Check it out if you have time. Thanks again.

Mike

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Mon, 11 May 2009 15:30:51 GMT

Did you miss my post on the browser compatibility issue earlier in this thread? It turns out that with a browser form, you can't display date and time in the same control, so if browser compatibility is required for your form, you'll need to display the date and time field in an expression box to show both.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Mon, 11 May 2009 15:20:57 GMT

Hilary,

I still can't make the date and time appear in the date picker or text box control.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Mon, 11 May 2009 13:58:47 GMT

Hilary,

I tried to formatt the Date and time into a Date Picker and a text box. I can not get this to work, you have any ideas what can be causing this?

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 23:40:20 GMT

Your options are limited with SharePoint and repeating data, that's for sure. I suppose there may be a work around to get the maximum (or minimum) of the repeating date fields -- if that were a desireable data point to push to SharePoint....

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Fri, 08 May 2009 22:22:42 GMT

I have a question. If I have repeating doors that are upgraded or changed and I promote the date they changed for each door. Is it anyway to filter on this data or date once they are in the Library. I don't think so because repeating data only give you the option to merge one on top of the other or show the first repeating door. The user wants to be able to sort and filter on doors that has been upgraded and when. That's right I can just filter on a non repeating item, but maybe it's not feasible to show all those dates in the library and have the user to open the form to view that information. Let me know your thoughts please.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 21:33:53 GMT

Here's another version, with an expression box to hold the date time. I set it to browser compatible, and don't get any warnings. I used some formula magic to pretty up the date time (took out that silly 't').

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 21:28:56 GMT

You know what? I just realized you are using a browser form. Date and Time cannot be displayed in the same control in a browser form (which is what you've basically been saying, isn't it!)

Best I can think of is two text boxes right next to each other... no, wait! put in an expression box bound to your date time field and format it as text...

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Fri, 08 May 2009 21:28:47 GMT

Thank you Hillary,

I'll have to wait until I get home. Unable to down load at work.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 21:25:21 GMT

Attached to this post is a sample. Right click the link in the header, select Save As and save locally. Right click the saved file and select design to open in design mode. Preview and enter some text in the text field and enter or tab from the field. Rules will set the values in two date pickers. The top is just date, the bottom displays date and time.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Fri, 08 May 2009 21:03:16 GMT

The control was a text box, I deleted the text box and added a Date Picker. It still will not work.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 20:44:03 GMT

Yes, you can. What kind of control is it? Is it a date picker? When I add a date picker to a new blank form and it is bound to a date time field, I have the option to display both. Perhaps delete the date picker and add it to your form again.

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Fri, 08 May 2009 20:35:14 GMT

Under Date and Time Format it says:

Date and time cannot be displayed in the same control. When I click a time format, the the Date format goes to Do not display date automatically; Vice versa) Is it that you can't store Date and time in the same control?

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Hilary Stoupa — Fri, 08 May 2009 20:28:00 GMT

Right click the control and look in the properties. You should see a format button on the first tab. Click it to see different formatting options....

Re: Inserting a Date into a text box when a user changes data in a control and saves the form to SharePoint again

Michael71 — Fri, 08 May 2009 20:22:05 GMT

That's what I meant. Sorry. It just shows the time. How can I make it show Date and the Time in the target field?