ContributionsMost RecentMost LikesSolutionsSandbox Access We are getting ready to start a new project with a new client and they have provided links to Sandbox environments they created for each App we will be working with. However, those links expire and the next time we try to use them we can log into their system, but nothing shows in the "My Apps" section. With previous clients where I worked with a Sandbox, I would log into their live environment and then switch over to the Sandbox environment to work. Base on that, does a user need to be added to the Live and the Sandbox version to be able to have continuous access? I believe I even tried saving the Sandboxes in my bookmarks but that didn't work either. ------------------------------ Chris Swirtz ------------------------------ General Sandbox QuestionFor those who have a good amount of experience utilizing the Sandbox feature to make changes to applications, is there any general rule of thumb to how many changes should be made before publishing? Fore instance, I currently have roughly 1900 change lines in the current Sandbox I am working in that have not yet been published. Granted, the live app is not currently being used by the client anyway, but, I feel like that is a lot of changes to be sitting on. Has anyone had issues with changes not transferring correctly for one reason or another? We are currently at a lull between development work, I feel like it is the right time to publish what has been done so far and then start new work with a clean Sandbox so to speak. Any thoughts? ------------------------------ Chris Swirtz ------------------------------ Re: Restricting choices in a Text - Multiple Choice fieldThat's what I thought as well Mark. However, I started this and got stuck. I created a new table called "Year" and created a Numeric field of the same name. Then I created a record for each year starting with 2022 out to 2050 for now. But these are numbers not actual "Years", so when I went to make the report thinking could filter the list to only show records where the Year is during or after the current year, that wasn't an option because I wasn't using a date field. But date fields show more than just the year, so how do I produce just a list or records showing just the year to then use as the list for the drop down on the Parent record? I expect I am missing something simple. ------------------------------ Chris Swirtz ------------------------------ Restricting choices in a Text - Multiple Choice fieldIn the app I am working on I have a Text - Multiple Choice filed with years listed on it that a user is to select from when creating a request. My client is asking that I limit that field so that a user can only select the current year or a year in the future. Obviously I can remove the past years as options for now, but short of someone manually going in every year and removing the previous year, the only other way I can think to do this is to create a child table with years as the records and create a report to use in place of the standard record picker that restricts the years listed to the current year or after. Does anyone have another idea? ------------------------------ Chris Swirtz ------------------------------ Re: Creating a Code Page that displays a Message and 2 action buttonsYour takes me to the Cancel Form no problem, but I get this error message when I click on the cancel button from the Cancel Form. This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>30</errcode> <errtext>No such record</errtext> <errdetail>Missing "rid" parameter.</errdetail> </qdbapi> The problem isn't getting to the Cancel form while in add mode. It is capturing that Record ID between so that theoretically when I get to the Cancel Form, it should be in edit mode of the Record that was just created. But that isn't what is happening, it's like it is saying that it is saving a record but then just reopening the add record screen in a different form. ------------------------------ Chris Swirtz ------------------------------ Re: Creating a Code Page that displays a Message and 2 action buttonsHey Mark, This is the code to get the user to the "Cancel Form" URLRoot() & "db/" & Dbid() & "?a=er&dfid=81&rid=" & [Record ID#] And this is the code for the actual "Cancel" button on that form. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_1161=Cancelled" & "&rdr=" & URLEncode(URLRoot() & "db/bsd4f85xs") Which works perfectly when they are working with a record that has been saved and has a Record ID. However, when adding a new record, there is no Record ID established yet. Now, when I click on the button to navigate to the Cancel Form from a new unsaved record, it does save the record first because I have the setting turned on to do so, but when it opens the Cancel Form, it remains in "Add" mode and doesn't capture the Record ID that was created when it saved and navigated to the other form. It's almost as if the formula needs to save the record and reopen it as is then run the code to navigate away so the new form so it reads the Record ID at that point. ------------------------------ Chris Swirtz ------------------------------ Re: Creating a Code Page that displays a Message and 2 action buttonsHey Mark, Thanks for this! It actually worked great, for the most part anyway. I created a button to go on the form and on the reports on the home page that takes the user to that alternate form I created which displays the warning message that says to either continue cancellation by clicking the cancel button below or to click on your home button. Might add another button to take them back to edit mode on the main form so they can continue working if they want. The problem I run into is the Cancel button the Cancellation form is setup to change the Status field and then navigate to the Home Page. But in order to change the Status field it needs to look for the Record ID, which is not available when Adding a new record. Clicking the button to take the user to the Cancellation page does save the record first before opening the next Form, but the Cancellation form opens in Add mode versus Edit mode of the record that was just created. Any ideas on how to modify this option so it works in Add mode too? ------------------------------ Chris Swirtz ------------------------------ Creating a Code Page that displays a Message and 2 action buttonsIn my app I have a form that has a button that when clicked will display a message that prompts the user to take certain next steps. That works fine, however, the client wants a button on the home page that does the same thing. I was wondering if someone can help me create a button that will take the user to a code page that displays the message and the shows 2 buttons, one will change the change the status field on a form to "Cancelled", the other will just navigate back to the home page. ------------------------------ Chris Swirtz ------------------------------ Displaying a message when clicking on a button from the HomepageOn a form in the app I am working on I have a cancel checkbox that when clicked displays a warning message and then provides a Cancel button. Currently I have that same Cancel button showing on a report on a homepage so a user can cancel a request direct from there but clicking the button from the homepage won't cause that warning message to come up. Any thoughts on a solution for this? ------------------------------ Chris Swirtz ------------------------------ Clearing data from multiple fields based on a selection in a drop-down fieldIn the app I am currently working on there are several sections where a user may select yes or no from a drop-down and if yes is selected, another section appears with data entry fields to be filled out. My client would like it so that if a user were to go back and change a yes to a no, that it would not only hide that section again but also clear any data entered in those fields. I am fairly certain I can do this with form rules, however, I wondered this could also be achieved via Pipelines? Which do you think would be cleaner? ------------------------------ Chris Swirtz ------------------------------