ContributionsMost RecentMost LikesSolutionsRe: How to store values collected in a javascript prompt in a field Brandon, Thanks for this suggestion. I'll gives a shot and avoid JS. Emanuel Pinheiro SR. Technical Consultant, PIE O 781-370-3782 C 401-258-6122 Emanuel.Pinheiro@aciworldwide.com ACI Worldwide, 880 Winter St. Waltham, MA ------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 ------------------------------ How to store values collected in a javascript prompt in a fieldI created an app to allow customers to open trouble tickets. Analysts review customer tickets and have the ability to assign the tickets to themselves using a magic button (f-rich text). Here's the formula I use: var text DisplayParent = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]; If([Unassigned] = true, "<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=cfc8kgqbwxd4ydd3vsabj8vdcbe&_fid_82=1&_fid_41=In-Progress&_fid_22=" & URLEncode(User()) & "&rdr=" & URLRoot() & "db/" & [_DBID_CASES] & "'><img src=\"https://images.quickbase.com/si/32/060-folder_out.png\"></a>") I have created a Managers Dashboard and I'd like to create a new Button - when pressed by the manager he/she can select users (from an existing field) to assign the case to. I was thinking of adding a JavaScript Prompt, then take the selected/entered value and update to update the user field - thus assigning the case. "javascript:prompt ('Who do you want to assign?')" Any ideas? ------------------------------ Manny Pinheiro ------------------------------ Re: Entering minutes and seconds, How?Thank You Sharon. This definitely pushed me in the right direction! I really appreciate it. ------------------------------ Manny Pinheiro ------------------------------ Entering minutes and seconds, How?Hello, I'm trying to establish a duration field and in it I would like to accurately represent minutes and seconds. I was able to do this by creating a Numeric field [Length] where users enter in a value like 4.12 ( 4 min 12 seconds ) and in the duration field I have this Formula : Minutes([Length]). With this - the duration field will have this value "4.12 mins". Thats ok, but I have 2 issues. 1 - How can I get the value to be 4:12 mins 2 - I noticed that sometimes the duration value will output to "4.309983333333" mins when 4.31 is entered in the Numeric field. I might be complicating things - the must be an easier way, but #2is my bigger issue. I need to accurately represent minutes and seconds. Thanks! ------------------------------ Manny Pinheiro ------------------------------ Re: How to prevent negative values from being displayedThank you Very much Mark! ------------------------------ Manny Pinheiro ------------------------------ Re: How to prevent negative values from being displayedPLease ignore... I figured out my issue with Marks Formula. missed the $ infront of the DaysFromEndDate Variable in the if statement ------------------------------ Manny Pinheiro ------------------------------ Re: How to prevent negative values from being displayedIm actually getting an error: Sorry this is hard to read.... ------------------------------ Manny Pinheiro ------------------------------ How to prevent negative values from being displayedHello I am working on a Table field where I am calculating the number of days that have passed since the date entered in another date field "Date of Release". This formula seems to work great: var date EndDate = Today(); ToDays($EndDate - [Date of Release]) However, if the date is in the Future, the formula is returning a negative value - which is ok, but I would like to suppress negative values from being displayed in the field and only display positive values greater than 0 returned by the formula. Any suggestions? ------------------------------ Manny Pinheiro ------------------------------