I have 3 drop list fields, I want a fourth field to be checked/unchecked as per the selected values. List three has all countries in the world so is this possible? thx

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have the following fields: 1- Products (drop list of 6 products), 2- Area of cover (drop list of 7 areas)  3- country of accident (drop list of all countries of the world). I want to: if PRODUCT X and  AREA Y and the country of treatment is UK for example so the (field check area of cover) is ticked. But if PRODUCT X and  AREA Z and the country of treatment is  USA for example so the (field check area of cover) is unchecked. Appreciate you help.  
Photo of Eias666

Eias666

  • 60 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
I will attempt an answer even though your question is not clear.

I think that you are saying that you want to set up a table which defines whether or not an incident is covered by insurance.  The coverage depends on the Type of Insurance Product, the Area (perhaps the medical area) and the Country where the insured is seeking treatment.

An incident happens and you want the app to look up to see if  the incident is covered.

This can be done if you set up a Coverage Master Table with a key feld in the format

Product-Area-Country.  

To do that I would either import the data if the source data is excel or else create a formula field using the List function to calculate that string and then when the record is saved , to have a form rule to save that formula result into a text field.  

Once that Master Coverage table is built and it's key field set, then it's a simple matter to build that same Hyphenated Key field in the incident table and look up if the situation is covered.  If there is no entry in that Coverage table, the the lookup will be blank, and the situation is not covered.
Photo of Eias666

Eias666

  • 60 Points
Hi Mark, thank you for your comment - can you please provide me with a virtual formula just to see what functions I will be using and how the formula would look like ? I'm struggling to figure out who I will work the country of indecent with the list of the area of cover which has many countries in it.  Appreciate you patience.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
I have described the method above and I can answer specific questions here on this Forum if you like if you get stuck. Alternatively, feel free to contact me directly for one on one assistance via the information in my profile.
Photo of Eias666

Eias666

  • 60 Points
Hi Mark, can we please continue here the work mentioned above as your time allows. I've created a new table as per your advice which contains 3 drop list fields:  Product (10 items) - Area of cover (12 items) - Country of treatment (196 items)- but I still don't know how to link these three fields together so my APP can notify the user if the country is within the area of cover or not.. any suggestions? thanks in advance.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
Can you paste in the choices for area of cover so I can see what they look like?