AnthonyTesoriero

Q&A Radio Box Selection To Generate Text Report

Discussion created by AnthonyTesoriero on Nov 24, 2016
Latest reply on Nov 28, 2016 by David Moyer

I am trying to create a solution that allows users to answer simple yes no questions and based upon the answer have Filemaker generate a text based report.

 

Example:

Case ( LIC_included = "No" ; "WARNING: You must include a copy of your business license." ; LIC_included = "Yes" ; "√ A copy of your license is included." ; "" )

 

So Far I've been successful generating a text report using a calculation but I recognize this is not a scaleable solution

 

Example:

 

LIC_included_a  & ¶ & ¶  & LIC_Name address_a & ¶ & ¶  &LIC_Validity dates_a & ¶ & ¶  & VIN_Picture_a & ¶ & ¶  & VIN_Picture is clear_a & ¶ & ¶  & VIN_Picture is permanent_a & ¶ & ¶  & BILL_Picture_a & ¶ & ¶  & BILL_Biz n LIC Match_a & ¶ & ¶  & BILL_VIN match_a & ¶ & ¶  & BILL_Service date visable_a & ¶ & ¶  & BILL_Service date n LIC valid_a & ¶ & ¶  & BILL_Customer_a & ¶ & ¶  & BILL_Details_a & ¶ & ¶  & BILL_Totaled_a & ¶ & ¶  & BILL_Includes Storage_a & ¶ & ¶  & BILL_Authorized_a

 

I need advice on how I can more easily edit the Yes or No answers rather than have to edit every case calculation

 

An a better way to generate the text report so that it will better format itself to look more cohesive and natural flowing.  Meaning currently if the answer is Yes it takes up 4 lines, no is 1 line no answer will leave a bing blank space in the middle of the report.

 

Any help you can provide is appreciated.

Outcomes