How to store values collected in a javascript prompt in a field

------Original Message------

Hello Manny, 

I am not real sure what your question is, but we will give this a shot.  Is your formula working?  I am not sure if this is the entire formula, but you have a variable that you declared and have not used and in your first href, you seem to be missing the URLRoot() & "db/".  This is where I am not sure if you are asking any ideas on why the formula is not working, or if you are just wondering if there is a better way or what you would need for the javascript. 

According to my understanding of your needs, I do not think that javascript would be necessary.  If you have a form that collects all of the information and has a field to store who the ticket is assigned to, it would be much simpler and cleaner to create a new form in the ticket table that only has two fields.  A text in the form that says "Who do you want to assign?" and the User field that you are using to assign people to the ticket.  Then, just create a button that takes you to this form. 
"<a href='" & URLRoot() & "db/" & DBID() & "?a=er&dfid=Numeric ID of new Form&rid=" & [Record ID#] & "'>"Assign Ticket" & "</a>"

This button would take you to edit the record of the related ticket, but would take you to the form that would have the user field, or multi-select field, that would contain the list of users and then allow the manager to select without seeing or needing to scroll through all of the other information in the original form.  This would also avoid all the headaches and potential breakage in the future if for some odd reason JS in a form is no longer supported.  

I hope this helps...


------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------