-
Hi Endless112. Thanks for posting!
What is "the traditional filter suggestion"?
You need to execute a query using data from your form. Out-of-box SQL data connections do not accept field parameters as part of the SQL query text. You could use a Web service that does it and pass the value to it. Qdabra's DBXL Web service has a Query ...
-
Hi JRicoRod and welcome!
Have you tried another machine? You can delete the cached credentials on that machine for the SP Site. I don't think it's related to the Excel template.
-
1. Set the value for the Default to be " " or something.
2. Use an xpath filter something like ... sum(@field[. = "foo"])
-
qRules does multiple repeating tables. We don't tend to support S.Y.M. Wongaton's site since there are numerous issues with the approaches she takes - in general, we don't recommend adding specific code to your forms since it will cost you more to maintain them.
That's why we recommend qRules. It's xpath agnostic which means ...
-
You can add a separate button for Close and Submit and hide the default buttons at the top (see file->form properties->...). To do printing on a custom button will require some code
-
Hi Shamisty,
Yes, you can do this. Do you want to make the number unique per form or per site/per library? If it's unique per form, it's easy. Just add a rule in your form that creates the number before submitting the form. You can use Concat function to create a REF ID in any desired format. If it's per library or site, ...
-
Hi Toni,
We did a webinar in January showing how to pull tasks into a form and change their values. No code required, but configuring the ShP stuff is a bit tricky. I'm not sure if the webinar shows how to create new tasks, but that should also be relatively straightforward. Check out Qdabra's YouTube channel for the webinar Jo-Anne ...
-
Hi Nikunj,
You could cache the secondary data source in the form template so that it will be part of the XSN. It will require that the XSN be copied to the local desktop whenever you update it, but 5000 items is not that huge so maybe this is acceptable. On load performance should be quite fast if everything's local.
Unfortunately, trying to ...
-
The delete button is just there for the sample - it is not needed for your solution.
We have lots of customers using the default data solution to copy values in.
It's better than code because it doesn't have hardcoded xpaths in it and won't require maintenance. In addition, it doesn't require site collection admin to deploy for ...
-
Hi David,
The column ID issues are vexing. I was talking to another person at the SharePoint User Group last Thursday and she was having the same issues. We have solved this countless times, and I think we even have tools that admins can run to fix site columns. I need to check with the guy that deals with this more often. We will plan a weekly ...