Forum Replies Created
Yup, same settings. Read type Action, active, Permissions set to Everyone. Test was successful.
Connection is active, permissions are setup for Everyone, and only Use is allowed. I’ve also sent an image to the email address you gave.
Nothing’s changed, and the test ran successfully. I should also mention that, if I’m logged into PerfectForms, the error goes away. Only comes up when I’m not logged in. This wasn’t happening before.
Alright, sorry for the misunderstanding, and thanks again for your help with this. Do you know if the Perfect Forms API can access timer data from a form? I want to send the date and time the form was opened and the amount of time spent on the form to our database.July 16, 2009 at 1:13 am in reply to: Via Form Connection, show data for “Open” instances only? #4673
Never mind, I got. Just used the equal sign instead of not equal to <>. Sweet!July 15, 2009 at 9:03 pm in reply to: Via Form Connection, show data for “Open” instances only? #4672
Thank you so much for this! Works like a charm. Now, the way this is setup, it shows any instance that doesn’t have the stage name I’ve set. Is there a way to show forms that actually have the word I’m using as a query? The Form I’m connecting to has multiple stages, and I’d like to effectively filter by the different stages.
I was originally envisioning a system where Perfect Forms writes to our Progress database upon Form submission, but I think what you’re suggesting is that because of compatibility issues, we’ll need to use the Perfect Forms API to read Form data, then manually write it to the database ourselves? Like instead of pushing data to the database, we’ll have to pull it in? Basically changing the starting point of the information exchange… database retrieves PF data and writes it to itself, instead of PF going into the database and writing the data in.
I’m sorry if all this sounds like it’s coming out of left field, as I might not understand what you’re saying. It’s just that I think the User Guide says something different than what you described. Here’s what I’m reading in the User Guide: The “…API allows you to pass data into PerfectForms™ and extract it from third party applications”. To me, this doesn’t sound like it has the ability to write data to a database, and none of the “common uses” listed there for the API are of this nature.July 15, 2009 at 1:53 pm in reply to: Via Form Connection, show data for “Open” instances only? #4666
Thanks for the help here. I think I figured out how to store the Stage name of the form in a Text Input field, but I don’t see the <> in the Connect action. Were you thinking of using a Simple Branch before/after the Connect action to activate the “return where field is not equal to” logic? I don’t think that would filter the data, actually. Could you be more descriptive? Thanks again.
Thanks for the prompt reply. We purchased the Connection Agent when we signed up for Perfect Forms, and have installed it successfully.
We’re trying have forms pass data into our Progress database. If I’m reading the User Guide correctly, that means we need to establish a Database Connection. The Perfect Forms API seems to be something used for reading data from, and writing data to, a form. Since that’s not what we’re trying to do, I don’t think the Perfect Forms API is the right place to start. Is that correct?
We’re trying to keep cost and system complexity down with this integration, so purchasing a license for SQL or MySQL and maintaining a database mirror is something we’re trying to avoid. Thanks for the suggestion, however.