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.
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
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.