Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Mar 22, 2021 01:25 PM
Hello,
New to AT community and hope to find help. This could be extremely simple but not sure how this field needs to be coded.
Column needing help = “Monthly Fee”
As shown in the fee section, is there a way to assign a value to each selected fee? For example, Exempt = $0, Forewarn =$5, Admin =$10? Therefore once any combination of those fees are selected it populates a total in the Monthly Fee section?
Assume the Monthly Fee section needs to be a formula but not sure which formula it needs to be or how to do it?
Thanks so much!
Mar 22, 2021 01:40 PM
Hi and welcome @Shawn_Ryken!
I would suggest making {Monthly Fee} a formula field and use a SWITCH()-formula in it.
SWITCH({Fees},
'Exempt','$0',
'Forewarn','$5',
'Admin','$10'
)
If you’re going to use the output in another field I would recommend to leave out the dollar sign in your SWITCH()-formula.
You can find a realy handy formula field reference guide here for future use.
EDITED: Sorry, I was too fast to post / too fast reading, so I missed that it’s a multiple select field.
I’ll update with an answer in a bit.
Okay, this is maybe not all that elegant, but it does what you’re asking for.
IF(FIND('Exempt',{Fees}),'0')+IF(FIND('Forewarn',{Fees}),'5')+IF(FIND('Admin',{Fees}),'10')