LoriPelzel
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How can I add a form to a home page?
Thanks for responding. I wanted to have one home page for our sales reps. I needed to make it really simple so I made a for that has only the information they would need on the road. The form is perfect - I just want that to be their home page. Thanks Lori ------------------------------ Lori Pelzel ------------------------------101Views0likes2CommentsResults of Formula Fields that we want to copy into field I can edit.
I have a commission field that is calculated. My boss wants to be able to change the amount. How can I copy the values in that field into a field that can be edited? Thanks, Lori ------------------------------ Lori Pelzel ------------------------------8Views0likes1CommentNeed help with a formula that is asking for last year
var date datevariable = AdjustYear([WTF],-1); SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159) So this is saying sum the Year to Date value in field 159 when the Distributor and Manufacture are the same and the Date is last year. WTF is the date field I'm trying to define as last year? Something is wrong, it works perfectly when I use this for the current year-to-date total. var date datevariable = FirstDayOfYear([WTF]); SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159) Thanks for your help! Lori ------------------------------ Lori Pelzel ------------------------------6Views0likes2Comments