Forum Replies Created
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.
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:
What if you use a Simple Branch with:
Will it still work if your stage is named “Stage 1”?
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
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.February 24, 2012 at 6:29 pm in reply to: String comparison for sorting Text Input column in a Table #6019
Thanks for the response, Dennis!
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.February 1, 2012 at 11:44 pm in reply to: Character limit for Text Input/Text Area columns in a Table #6000
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
Me fail markup. That would be:
select NEWID()as NewGUID
I don’t know if PF can do this, but I would create a view in an SQL Server database that just does aCode: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.
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.
Try using [rn] (including the brackets) in the Pattern parameter of the Replace function to match the newline.
That was it. Thank you, Dennis!
Thanks for the reply, Dennis. Here’s what the states look like for the page where the Teacher enters the information:
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:
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.