This tip describes how to make the formula for Show Response Only columns in databases where multiple response forms are used.
Code
Have you ever had to use a formula a the Show Responses Only column that goes something like this:
@If(Form = "Invoice" ; InvoiceNo + " - " +
CompanyName + " - " + @Text(@Date(InvoiceDate));
@If(Form = "Order" ; OrderNo + " - " + CompanyName
+ " - " + @Text(@Date(OrderDate)); InquiryNo + " - " +
CompanyName + " - " + @Text(@Date(InquiryDate))))
This formula relates to 3 different kinds of response document Invoice, Order and Inquiry.
The easier way of doing this is to create a field called ViewDetails on each form, make the field text and computed and put the relevant part of the response column formula into that field value. This means that the response column only has to have the value ViewDetails instead of the long winded formula above. It also means that should there be aby changes to the forms and fields, there doesn't have to be a change to the view.
