Search the Community
Showing results for tags 'logic'.
Have a table of data. Need a report or view showing IF field 1 = X, AND field 2 = A or B or C show those entries. So below, if the field Evals = YES AND field Hospital = A, B, C, D, E, E or F - show them to me. But cant get it to show data: Tried it multiple ways, nothing. ;^)
I have an problem that I cannot figure out how to solve. It's a bit complicated, but I think it may be unsolvable within Caspio. Anyone who can solve this gets a gold star because I have tried everything. I have a table of customers example (C1, C2, C3, ... Cn ) and a table of vendors (V1, V2, V3... Vn). Every customer can have deals from multiple vendors e.g.( Customer C1 can have deals from vendors V1, V3, V4, C2 can have deals with V2, V4, V5) etc. Vendors can have different deals with one or more customers, but only a single deal with a given customer. This yields a