SharePoint Integration

Re: how to setup a car request form

donstephen — Tue, 06 Aug 2013 14:34:55 GMT

Hello again ravichandra. I'm adding Qdabra's YouTube channel and an InfoPath 2010 training video for you to indulge in. Our YouTube channel contains a lot of InfoPath techniques and tricks applicable to various scenarios.

Hope you could find these videos useful. Cheers!

Re: how to setup a car request form

donstephen — Tue, 30 Jul 2013 08:07:48 GMT

Hi ravichandra,

We have tutorials for InfoPath forms using qRules and DBXL. Both guides, qRules Training and DBXL Training, have videos, modules, starting templates, and end result forms for your reference. It's a good guide for starters and should be able to help you out.

Let us know if you need more links or if there is anything else we can assist you with.

-Don

Re: how to setup a car request form

ravichandra — Tue, 30 Jul 2013 07:02:30 GMT

Hi Patrick,

Hope you are doing well,you helped me last few months back and i hope you will continue to help me,

my request to you is can you provide me some useful video links to learn infopath 2010,with example scenarios

Re: how to setup a car request form

Patrick Halstead — Sun, 28 Jul 2013 19:33:27 GMT

I would have the form query a separate custom list.

The list has one row for every day a car is booked. So the list has columns for car, date, person who booked, and parent booking form ID.

When the user opens the InfoPath form to book a car from a date to another date, it automatically inserts number of rows in the form for the difference in dates and then the form uses CAML to insert those rows into the list with the parent ID. The form submits itself with a unique ID to the form library.

After the form loads you use a rule-action to query list with a filter for start and end date. This can be done using REST (2010+) or using FilterOwssvr.

Our qRules common library will make integration much less work since it's easy to create a mapping and call the SubmitToSharePointList command then to filter as well using the FilterOwssvr command. Should be 1-2 hours of work to accomplish with qRules.

Without qRules, you can do this by adding default values (rows) to your form that are blank and then setting them equal to the day when they schedule. To iterate, you set a column which will trigger a rule for each row and then the row rule-action increments a counter and you check that counter when you are adding to make sure you don't add too many.

In either case, should be <4 hours of work.

Re: how to setup a car request form

claydevin — Mon, 22 Jul 2013 18:49:13 GMT

Maybe creating a view for each car and using Calendar Overlay to color code available/unavailable cars. The problem is calculated fields dont work with [Today]. That is really what you would be looking for

how to setup a car request form

TwanVeugelers — Tue, 16 Jul 2013 10:02:25 GMT

Hi. The situation: We have 7 company owned cars, which employees can use for travelling. Every car has its own calendar (currently exchage/outlook, but can also be SharePoint) The Request: We need a form that employees can fill out to request a car. In this form they fill in date+time of departure and date+time of arrival. The form has to show the number of available cars within that timeslot derived from those calendars. Is that at all possible, and what do I have to consider to set it up?