ContributionsMost RecentMost LikesSolutionsRelationships - SandboxI am working on major change updates to our application. I am thinking about changing how relationships flow between some of our tables thinking that there is a better way to have them relate to one another. If I change this in the sandbox, when I move over the changes will it cause issues within the application? ------------------------------ Anna Harris ------------------------------ Re: Not connectingclick on the link and remove the extra HTTP.... ------------------------------ Anna Harris ------------------------------ Re: Not connectingyes!!!! I've tried multiple times ------------------------------ Anna Harris ------------------------------ Reports - Charts I am wanting to have a report that shows two things: How many cases were opened per month for the year and How many cases were closed per month for the year. I currently have 2 reports showing each thing. I would like to have them all on one report. ------------------------------ Anna Harris ------------------------------ Re: Formula - Total field if/then based on numeric value and percent.Today your a hero Adam!!! Thanks for your help! It worked perfect! ------------------------------ Anna Harris ------------------------------ Re: Formula - Total field if/then based on numeric value and percent.That makes sense until the percentage. So as a breakdown: My fee is as follows: 499.99 and under fee is 100.00 500.00 - 999.99 fee is 150.00 1000.00 - 2999.99 fee is 250.00 3000.00 + fees will be 12 % (ie: 3000.00 fee is 360.00 and so on...) But the way this is written looks like it will add 12% to everything? or will this only add 12% to anything that does not fit in the prior statements?? ------------------------------ Anna Harris ------------------------------ Re: Formula - Total field if/then based on numeric value and percent.Formula: If([Estimate Cost]<=500,"100.00",[Estimate Cost]>=500,"150.00",[Estimate Cost]>=1000, "250.00",[Estimate Cost]>=3000,[Estimate Cost] *.12) ------------------------------ Anna Harris ------------------------------ Formula - Total field if/then based on numeric value and percent.I have attached a photo of a formula I have been working on. A bit of background information: I will use this to create an estimate for clients for some of our products. This formula field will display our fee based on the total cost the the Estimate Cost field. The first few statements are based on cost with a flat fee associated. After $3000.00 the costs will be based on percentage. It worked until I added the percentage portion. I've written it a few times, and after so many times of staring at it I can't seem to get it right. Please help :) ------------------------------ Anna Harris ------------------------------ Re: Create a button to change the value of another fieldRan into an issue that says <qdbapi> <action>API_EditRecord</action> <errcode>32</errcode> <errtext>No such database</errtext> <errdetail> The application does not exist or was deleted. If you followed a link to get here, you may want to inform the author of that link that the application no longer exists. </errdetail> <dbid>-b</dbid> </qdbapi> help? ------------------------------ Anna Harris ------------------------------ Re: How to display PDF in file attachment fieldsJEFF man thank you!!!! THAT was the magic number!!!!!!!! It works! :)