You are viewing limited content. For full access, please sign in.

Question

Question

Verify the form (hypertext link) has been opened

asked on September 7, 2021

Some of my forms display information only.

For example, I work for a school district.  We email a hypertext link to a parent that displays the courses their child is enrolled in.  When they have looked at the form, the click on the 'X' to close the page.

  And I'd like to be able to determine who has/has not opened the form.

I've thought about an api push in my JavaScript behind the form, but then I'd have to create a place to catch that push and then write that to a db table.

Can I trigger an Process Diagram from within the JavaScript, perhaps that would close the form as well...

Thoughts?

 

0 0

Answer

SELECTED ANSWER
replied on September 7, 2021

On a very basic level, without getting into API stuff, you could create a simple stored procedure that inserts a row into a database. 

Set this as a lookup rule on the forms side like so, and you get a log whenever someone opens the form.

The slightly difficult part becomes knowing who has opened the form. In an internal process, you could just use their username, but on a public form, I believe it would always be anonymous. If you are sending out these links with unique variables, you could use that as a basis for Identification.

 

I would add things to the stored procedure such as checking if a row already exists, in order to eliminate duplicate rows, and adding things to the table like an instance number, or a semester/year combo, if we are using the course list example. 

3 0

Replies

replied on September 7, 2021

@Brett Unverzagt is right - if you don't send the url to the parent with some identifying information in the query string, it's all going to be anonymous.  I would recommend focusing on when the page loads, as opposed to when they click on something that closes the form.  You'll need to do AJAX on the $( document ).ready() event that POSTs back somewhere to record the event.  I disagree with @Brett Unverzagt in eliminating duplicates.  I think it's important to capture if they've viewed it once or 100 times.

The Process Diagram is not in play, here, with a simple read.

replied on September 8, 2021

Thank You.

That worked!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.