Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Getting started question on formula fields
Fiona Carr
02-16-2019 19:45
I'm a beginner. I want to create a formula field that will take the selected text from a multiple choice ...
Laura Thacker
02-16-2019 20:03
When building an IF statement you also need an "else" condition. If([Enrollment Type]="5 Full Day",360,null) ...
1.
Getting started question on formula fields
1
Like
Fiona Carr
Posted 02-16-2019 19:45
Reply
Reply Privately
Options Dropdown
I'm a beginner. I want to create a formula field that will take the selected text from a multiple choice field and convert it into $. This is for a student enrollment app where parents can select 5 full day, 3 full day, etc. enrollment options. Each option has its own fee. I have created a formula field: If([Enrollment Type]="5 Full Day",360). Clearly it doesn't work. I want the result to be $360 if 5 Full Day is the enrollment type (that's the field name) selected.
2.
RE: Getting started question on formula fields
0
Like
Laura Thacker
Posted 02-16-2019 20:03
Reply
Reply Privately
Options Dropdown
When building an IF statement you also need an "else" condition.
If([Enrollment Type]="5 Full Day",360,null)
if "enrollment type" is equal to "5 Full Day", then 360, otherwise zero
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic