ContributionsMost RecentMost LikesSolutionsRe: Sandbox App option not appearingTurns out that the problem we were having comes from the fact that we have 3rd party software running within that specific app which negates the ability to use the sandbox feature.Re: Text List Cannot Be Used In A Formula?I have again recently tested with converting a Text List using ToText() and it worked fine for me, Jim maybe there is another area of your formula that is causing the data type error. If there is more to your formula than the line you commented above can you show it?Sandbox App option not appearingI wanted to create a sandbox app so that i can test some much needed changes to a few tables without making those changes live yet, however while i was following the steps listed here: https://help.quickbase.com/user-assistance/how_to_update_QuickBase_applications.html , I noticed that there was no "Sandbox" option anywhere in the apps settings. I made sure with my boss that we had the platform plan and even checked to see if it was a permissions issue by seeing if she was able to create the sandbox, yet she was unable to see the option just like me. We both have the two highest roles in the database so im not sure as to why we are unable to see the sandbox option, am i missing a step or are the directions outdated? Re: Text List Cannot Be Used In A Formula?I tried this, except i get an error basically stating that the ToText() function does not support conversions from a textlist (It basically says it is looking for text, numbers, bools, etc. but found textlist) Re: Assigning employees ID#'s based on their programsThe goal was to make the process automatic once an employee finish a payroll form, I do see what you mean about the whole thing being very tedious and quite complex... I have advocated to my supervisor that we just do the assignments manually since we are a relatively small company (~50 people) so it wouldnt be much of an issue compared to what setting up an automatic program would be. The thing is that she is looking more towards the future with this and not needing to manually input or change data once the company grows. I really appreciate the advice and guidelines you provided and will try to implicate them as best i can. Thank you. Assigning employees ID#'s based on their programsI was tasked with creating a method to assign an employee ID# to all active employees, however i have hit a bit of a wall while trying to do this project due to the conditions for which an ID# is assigned. Here is the situation: - All employees are assigned a program (OMHC, PRP, Group Home, or SUD), most employees are only assigned one program but there are a select few who are a part of 2 or 3. -Numbers should generate in chronological order by program type. If program is PRP, number should begin with 1, Group Home 2, OMHC 3, SUD 4. ID#'s are 4 digits, so an ID# for OMHC would look like : 3001, 3002, 3003 etc.. (employees #'s cannot start with 0 : 1000, 3000 etc..) -Employees who are a part of multiple programs will receive a separate ID# for each program EX: An employee in PRP and OMHC might have 3002 as well as a separate number 1005. I have created a new test table to try and complete this task that looks like this. I had planned to use a relationship to the table itself and than use summary fields to take the maximum employee ID# for a program and add 1 to create a new ID, but this is where i am stuck as the summary field does not work as intended and i am not sure how to account for employees who are apart of multiple programs. Any help would be appreciated.Re: Operation failed : error code = 3 (Insufficient permissions)Thank you, I will open a support ticket about the issue.Operation failed : error code = 3 (Insufficient permissions)As of yesterday 02/25/2019, a weird problem has popped up for some of the users at our company. While trying to edit a record, some users receive the above error. They are allowed to hit "ok", and after that they are able to edit the fields within the form, however every time they make a change to a field the error will pop up again, and again. The error does not remove/revert the change and the user makes. When they save the form everything they did is still saved (despite receiving the error one last time). I went through the table settings and checked the role permissions and from what i could tell they are allowed to modify all fields in the form, so why does this error keep occurring? One thing to also note is that this error is only occurring to only specific users in the role, as when i tested things out for myself in the role everything worked fine, but when i tested as the specific users who were having the issue the error occurred.Re: Numerical Formula Field not saving a value after closing the record.I redid the entire project and eventually got the entire thing to work properly without creating a circular relationship.How to have two codepages running at once on a single table.Ok so i understand that having two code-pages running scripts at once is not the best idea in the first place and should always be narrowed down to a single program of scripts, but that is what i would like to know how to do today. At the moment my company has table that collects information and always require a signature at the end, to do this we use a code page that creates the extra HTML and dynamic functionality that we need for the form. Recently however, my supervisor has requested that i make some quality of life changes to the form (that was actually very complicated to do) in which i basically acquire information from a report in another table and use it to compare to information in the current form, which will then go through and auto-fill some other fields in the form (all of this being done in a code page). Its hard to explain in writing but its all something a simple relationship was unable to do and i just wanted to provide some context to my situation. My point is, i need to have the code from both code pages (the one that does the signatures, and the new one i just made to auto-fill information) running at the same time. We have been using [iol] [/iol] as our method of calling code pages in the form and ive tried to use two at once, however this causes an error. NOTE: I am really trying to refrain from having to combine ALL the code from both code pages into one since they are very cumbersome and i would like to keep them separated for future reference. I have tried using $.getScript() function at the top of one code page as shown below, but that did not work. Are there any other