SyaefulBahri3
6 years agoQrew Trainee
Formula text for preferred approver
Hi All,
I have this condition
If purchase <= 2000 approver Diana
If purchase > 2000 approver Rob
With this condition, I can create formula text "Approver" with this
If(
[Purchase Price] <= 2000, "Diana",
[Purchase Price] > 2000, "Rob")
The problem is I have different approver for one specific unit
There are 3 units: Communication, Trade, Economics
For Economic unit for purchase <= 2000 the approver is Melissa
This is my form structure
Unit name: multiple choice (Communication, Trade, Economics)
Requested by: text (name of the requester)
Purchase price: numeric
Approver: formula text
How can I achieve this condition?
Many thank
------------------------------
Syaeful Bahri
------------------------------
I have this condition
If purchase <= 2000 approver Diana
If purchase > 2000 approver Rob
With this condition, I can create formula text "Approver" with this
If(
[Purchase Price] <= 2000, "Diana",
[Purchase Price] > 2000, "Rob")
The problem is I have different approver for one specific unit
There are 3 units: Communication, Trade, Economics
For Economic unit for purchase <= 2000 the approver is Melissa
This is my form structure
Unit name: multiple choice (Communication, Trade, Economics)
Requested by: text (name of the requester)
Purchase price: numeric
Approver: formula text
How can I achieve this condition?
Many thank
------------------------------
Syaeful Bahri
------------------------------
- no problem,
Quick Base evaluates the IF statement conditions in the sequence as listed, so just deal with the more specific situations first.
IF(
[Specific type] = "Communications" and [Purchase Price] <= 2000, "Curley",
[Specific type] = "Trade" and [Purchase Price] <= 2000, "Larry",
[Specific type] = "Economics" and [Purchase Price] <= 2000, "Moe",
[Specific type] = "Communications" and [Purchase Price] > 2000, "Wilma",
[Specific type] = "Trade" and [Purchase Price] > 2000, "Fred",
[Specific type] = "Economics" and [Purchase Price] > 2000, "Barney",
[Purchase Price] <= 2000, "Diana",
[Purchase Price] > 2000, "Rob")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------