AhuvaBrown
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Trouble with more complex interactions
Can you describe the form rule you're using for #3? I've come across the same issue where I wanted to autopopulate a field but allow it to be changed and it kept reverting to the initial value, and I resolved it by writing the form rule like this: If [Field 1] = X and [Field 2] is blank, change [Field 2] to Y That should allow you to change the value of Field 2 after it's been updated to Y, since at that point it's not blank so the form rule doesn't apply anymore. Does that answer your question? ------------------------------ Ahuva Brown ------------------------------19Views0likes1CommentRe: Date field formula that is always the 10th of the next month of a given date.
This should do it: FirstDayOfMonth(AdjustMonth([Date Field], 1)) + Days(9) AdjustMonth([Date Field], 1) returns the date one month from the date field. FirstDayOfMonth() returns the first day of the above month. + Days(9) adds 9 days to the first day of the month, returning the 10th day. I hope that works for you. ------------------------------ Ahuva Brown ------------------------------46Views2likes0CommentsRe: Date Formula Assistance
Here's the formula I came up with, which should be done in a Formula-Date field: If(Month([Last Inspection Date]) = 3 or Month([Last Inspection Date]) = 4, AdjustMonth([Last Inspection Date], 5), Month([Last Inspection Date]) = 8 or Month([Last Inspection Date]) = 9, AdjustMonth([Last Inspection Date], 7)) The Month([Last Inspection Date]) function retrieves the month number, so if the last inspection date is March, it will output 3, etc. If the month of the last inspection date is March or April (3 or 4), AdjustMonth([Last Inspection Date], 5) adds 5 months to the date. So if the last inspection date is March 1, 2022, the formula will result in August 1, 2022. If the month of the last inspection date is August or September (8 or 9), AdjustMonth([Last Inspection Date], 7) adds 7 months to the date. So if the last inspection date is September 30, 2022, the formula will result in April 30, 2023. Does that make sense? ------------------------------ Ahuva Brown ------------------------------20Views0likes1CommentRe: Date Formula Assistance
I may be misunderstanding the issue, but is there a reason you can't add a fixed number of months to the last inspection date? Meaning, if the last inspection date is between August 1 and September 30, add 7 months to the date to get your next inspection date (using the AdjustMonth() formula), and if the last inspection date is between March 1 and April 30, add 5 months. ------------------------------ Ahuva Brown ------------------------------21Views0likes3CommentsRe: Help with GetFieldValue(GetRecords....to lookup value in another table
The result of the GetFieldValues formula is multi-select text, so it has to be converted to the data type of the field it's in (unless it's already a multi-select text field). So if it's a text field, convert the formula to text: ToText(GetFieldValues(GetRecords("{16.EX.'"&[Date]&"'}","tableB"),25)) ------------------------------ Ahuva Brown ------------------------------831Views0likes1CommentRe: Report Field - Formula Date and concatenate.
If you're attempting to concatenate two dates to display on your report, the report formula needs to be Formula-Text, not Formula-Date. You're getting that error because this: &" - "& is a function for text, not dates. ------------------------------ Ahuva Brown ------------------------------89Views0likes1CommentRe: Need two if conditions for a numeric formula
Try this: If([Project Points Override] = 0 and [Approved] = true, [Project Points]*[Contract Coach - Current Rate], [Project Points Override]*[Contract Coach - Current Rate]) ------------------------------ Ahuva Brown ------------------------------23Views0likes0Comments