ContributionsMost RecentMost LikesSolutionsRe: Change entered values to positive or negative valuesAgreed. What about just being able to keep only positive numbers. If a user enters a negative number it is automatically "flipped" to positive. If they enter a positive it stays positive?Re: Change entered values to positive or negative valuesYes. That is exactly what they are asking for. I know its confusing and strange, which is prolly why I haven't been able to figure out a solution.Re: Change entered values to positive or negative valuesIts a data entry field. I've asked why cant the user just enter the information correctly, but they want to try and ensure data integrity. :)Re: Change entered values to positive or negative valuesBut A formula may not contain a reference to itself directly or indirectly through another formula?Change entered values to positive or negative valuesI have been requested to create a field that changes negative numbers to positive numbers and positives to negative numbers after being entered in the field. I looked at using the ABS but only works with converting negative values to positive but QB has a limitation preventing users from referencing the current field in the formula. Any help is greatly appreciated. ThanksRe: Need to create a button to copy the current record details and update a couple of field labelsSo I am still stuck on this. I am trying something different. I am trying to create a button that copies the current record and removes some data from only a few specific fields. Example would be: I have a contract that is expiring soon and all the information is in the current record. I need all the information in the current record to be copied except for the comments field, date fields to be cleared. The user will update when needed.Re: Need to create a button to copy the current record details and update a couple of field labelsHmm, I'am trying to minimize the amount of manual data entry for copying or updating these contract budget totals from year to year. We are currently using these fields to determine the increase or decrease from the previous contract to the current contract. So the FY17 Field represents the Total Cost for FY17 and the FY18 Total Cost shows what is the current spend. I have a formula field that determines the percent of increase or decrease from year to year.Re: Need to create a button to copy the current record details and update a couple of field labelsSure, I can try to explain more. The application is currently being used to capture and monitor Vendor contracts for my department. The record being used contains all the needed information a user would need to update or extend the contract for the current Fiscal Year. The ask is to be able to copy all the current contract information AND update/change the FY17 and FY18 fields labels to FY18 and FY19 on clicking a button. We are nearing the end of FY18 and users are starting contract talks for FY19 so I need to be able to easily update/copy the current contract record with no manual input or changing these fields. Does that help?Need to create a button to copy the current record details and update a couple of field labelsI have a table called contracts and I want to create a button to copy all of the data in the current record and update some field labels upon copy. I have two fields that I would like to be updated when the record is copied. FY17 Totals and FY18 Totals. When the button is clicked. I would like it to copy the record and change the FY17 Totals field label to FY18 with the data currently in the field and the FY18 Totals field changed to FY19 and so on. Basically adding 1 to the last digit. Any help would be great!