I posted earlier but I want to push again that what is desperately needed is conditional formulas.
We have a powerful system going here BUT SADLY LACKING IN SOME PRETTY BASIC MAJOR FEATURES.
In my database I have the possibility of a SOLDIER being taken as a POW.
Not all only some
There is a flag to tell you YES or No
We construct a text formula to tell us when where and where he was imprisoned.
But text formulas being DUMB do not allow us to tell the system
DO NOT GENERATE THIS TEXT FORMULA RESPONSE IF THE FLAG IS NO OR THE DATE TAKEN PRISONER IS NO.
For the data to be meaningful free text needs to be added to it “Date Taken Prisoner :” for example.
Because we can’t specify that the text formula should or should not be generated.
EVERY SINGLE RECORD in the database ends up with the free form text “Date Taken Prisoner :” even though the flag is set to now he was not a POW.
I have mutiple fields that needs conditional formatting and decisions.Because of the lack of CONDITIONAL PROCESSING every one of those fields contain text whether they are applicable or not.
MAJOR MAJOR MAJOR WEAKNESS - PLEASE RESOLVE - CONTIIONAL FORMATTING IS INTEGRAL TO DATABASE DESIGN
Thank you for bringing this to our attention, and we apologize for any inconvenience this may have caused. I would like to suggest an alternative solution to address this problem.
To manage the different conditions, we recommend creating separate fields for each valid condition. For example, you could create “Field A” to show the text formula when the flag is set to “Yes,” and another field, “Field B”, to show a value when the flag is set to “No” (if necessary).
Further, you can create a third short text field, “Field C”, with a conditional rule to manage the correct value based on the flags. If the flag is set to “Yes,” then set the value of the field to Field A. If the flag is set to “No,” then set the value of the field to Field B (or leave it blank if there is no value to show).
You would then use this field, Field C, to display in your views. (Field B may not be necessary if the null value is just to leave the field blank.)
Hopefully this helps. Feel free to reach out to support if you have any follow up questions.
You can use conditional rules to set the value of a text field based off the value of other fields.
It’s kind of a pain. You have to write rules that evaluate each expected condition and one that handles all others.
Does that make sense? I can provide some images when I’m back at my computer…
Edit: I’m talking about conditional rules, not conditional statements in a text formula or an equation. When you right click on the settings icon (I think) it is longer of the items you can click. You wrote rules that change the value of the field based off of some condition…
Hi Ray, Correct - you cannot use conditional rules with Text Formula fields. However, you can apply them to Short Text fields to capture event conditions captured in your Text Formula fields.
For example, you would configure your fields as follows:
Use a Text Formula field to create compound string for Name, Rank, and Serial
Use Text Formula Fields to create compound string for Date Taken or Wounded and Place
Use a short text field with conditional rules to set the value based on whether they choose WIA or POW.
(Since Date Taken, Date Wounded, and Place are the same types of data you could potentially use one field to capture the date and one field to capture the place)