Search the Community

Hi all, I am working on vehicle insurance portal. I have stuck in some building functionality in DataPage. My requirement is: A user wants to fill his information along with his family member's information by clicking on add in 'User information DataPage'. I need to create a "Add Member/Add Driver" button so that it can add its members/Driver's information one by one. Like if it has one then one member will be added or if it has more than one then more members will be added. For every member have same input field but different form. They should be able to submit multiple times based on the number of member/drivers added.These all data need to store in one table, so that we can fetch these data easily. Here is my DataPage URL which am working on it. Please find attached file below. This is the structure I have to developed in this DataPage. If any resources are available please share or give any road map to build this functionality.

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 "deal table" view consisting of combos of vendors and customers IDs forming records that have all the instances of vendors for each customer e.g. (V1/C2, V1/C3, V2/C2) OK- Here's the problem. I want to create a table that shows "All customers I don't have a deal with" from the perspective of a vendor. I do a login which passes vendor ID, and I can only view records that are not equal to that vendor ID, but that will still show all other vendors that have deals with that customer. I want to basically eliminate a customer entirely from the view if that customer ID shows up in the vendor's deal table. I need to pass all the customer IDs in the vendor deal table somehow into the combined view table and do a big "not equal" to any of those customer IDs. This doesn't seem to be possible, or maybe requires javascript. The rules don't allow you to eliminate individual records based on the content of another table. Thanks in advance. Like I said, gold star if you figure this out.