I am new to development, so my approach to the database I am creating could be the long or hard way. My question is this, is there a way to specify more than one form to be used in a form formula? Or is there another way to go about this? What I am trying to do is take a form that has been submitted and show the data in a different form. I have 3 forms that are being used in each view. I have tried select case with no success. Can you help out a novice developer?
Sure... Something like the following would work for you in the Form Formula section of the view.
@If( DocType="C"; "ContractForm"; DocType="Q"; "QuoteForm"; DocType="P"; "ProposalForm" ; "DefaultForm");
That code would open one of the four forms listed depending on the contents of the DocType field. If the DocType field contains something other than "C","Q","P" or does not exist, the form "DefaultForm" will be used.