pmeidinger

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 69 total)
  • Author
    Posts
  • in reply to: Capturing SQL Server error messages? #6169

    pmeidinger
    Participant

    Thanks, but I was looking for something upon which I could act within the form when SQL returns a specific error, like if SQL returned a primary key violation I could tell the user a record already exists and to change their data.

    in reply to: Workflow Stage Names #6165

    pmeidinger
    Participant

    I’ve never seen a list of stage names; that would be very useful. What version is that in? This is what I see in the Edit Condition dialog for a Simple Branch:

    //i.imgur.com/aIaBE.png

    in reply to: Workflow Stage Names #6162

    pmeidinger
    Participant

    What if you use a Simple Branch with:

    Stage Name

    =

    “STAGE 1”

    Will it still work if your stage is named “Stage 1”?

    in reply to: Mapping our of a Security Request Form #6026

    pmeidinger
    Participant

    If I understand your post, it doesn’t sound to me like the three or four quizzes need to be separated in the workflow. Say the workflow looks like this

    //i.imgur.com/zdkUH.png

    In Stage 3, you could put the quizzes in the same form with each quiz on different pages. Of course, the quizzes could span multiple pages, depending on size, so you could have some kind of navigation scheme so they could move between the quizzes.

    When a quiz is completed, give the user some kind of indication (maybe as part of the navigation scheme), and you can choose to hide or disable each quiz when it’s complete if necessary. Once all the quizzes are complete, then you can move to the next stage.

    Hope that makes sense.

    in reply to: String comparison for sorting Text Input column in a Table #6019

    pmeidinger
    Participant

    Thanks for the response, Dennis!

    in reply to: Lists with Commas #6006

    pmeidinger
    Participant

    I justed tested this myself, and it’s Excel that puts in the double quotes. I entered Vincent’s list of city/states into one column in Excel 2003. I then saved the file as a CSV and immediately opened that CSV file in Notepad. The double quotes were present when I opened it in Notepad.

    I would suggest opening your CSV file in Notepad after saving it in Excel and doing a Find/Replace to remove the double quotes.

    in reply to: Character limit for Text Input/Text Area columns in a Table #6000

    pmeidinger
    Participant

    Thanks, Dennis!

    in reply to: GUID #5944

    pmeidinger
    Participant

    Wow, that seems like a lot more work than:

    1. Create a view in SQL as select NEWID()as NewGUID

    2. Create SELECT action in a Database Connection that queries that view

    3. Use a Connect object in the form for that action, returning the NewGUID to a helper Text Input Field

    4. Insert your other data into your database, using the GUID in the helper Text Input Field

    in reply to: GUID #5939

    pmeidinger
    Participant

    Me fail markup. That would be:

    select NEWID()as NewGUID

    in reply to: GUID #5938

    pmeidinger
    Participant

    I don’t know if PF can do this, but I would create a view in an SQL Server database that just does a

    Code:
    select NEWID()as NewGUID

    , and make a database connection action for that view. Not sure if there’s an equivalent in the other database server types, though.

    in reply to: Change default theme for new forms? #5899

    pmeidinger
    Participant

    Thanks, Dennis. I was hoping there was a system-wide setting so all of our forms authors could use the same style, but this will do.

    in reply to: Remove newline from text #5874

    pmeidinger
    Participant

    Try using [rn] (including the brackets) in the Pattern parameter of the Replace function to match the newline.

    in reply to: Question about workflow and notifications #5870

    pmeidinger
    Participant

    That was it. Thank you, Dennis!

    in reply to: Question about workflow and notifications #5868

    pmeidinger
    Participant

    Thanks for the reply, Dennis. Here’s what the states look like for the page where the Teacher enters the information:

    //i.imgur.com/h67R6.png

    The Teacher should always be able to see this page, but when the Registrar rejects it and the workflow goes to Stage 3, the page seems to be hidden.

    Here’s what the workflow looks like:

    //i.imgur.com/eg0jC.png

    in reply to: Question about workflow and notifications #5865

    pmeidinger
    Participant

    OK, so now I’m using roles in the workflow to enable or hide objects based on the role/stage. Here’s my problem:

    1. Teacher completes form and submits. (Stage 1/Unspecified role. Not sure why it says Unspecified)

    2. Registrar opens form from email notification, selects Reject, then submits. (Stage 2/Registrar role)

    3. Teacher opens form from email notification, but the form comes up empty as though all the pages were hidden (Stage 3/Teacher role)

    I’ve double checked my states and the first page is never hidden based on any role or stage. Any chance someone could look at the form and see what I’m missing? I can email the .pf file if someone would be so kind to check it out.

Viewing 15 posts - 16 through 30 (of 69 total)