davids

Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • in reply to: Error on form connection #4741

    davids
    Participant

    Yup, same settings. Read type Action, active, Permissions set to Everyone. Test was successful.

    in reply to: Error on form connection #4739

    davids
    Participant

    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.

    in reply to: Error on form connection #4736

    davids
    Participant

    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.

    in reply to: Accessing a Progress database (RDBMS) #4674

    davids
    Participant

    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.


    davids
    Participant

    Never mind, I got. Just used the equal sign instead of not equal to <>. Sweet!


    davids
    Participant

    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.

    in reply to: Accessing a Progress database (RDBMS) #4669

    davids
    Participant

    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.


    davids
    Participant

    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.

    in reply to: Accessing a Progress database (RDBMS) #4664

    davids
    Participant

    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.

Viewing 9 posts - 1 through 9 (of 9 total)
Do NOT follow this link or you will be banned from the site!