Search the Community

I'm trying to set up a dynamic redirect after a user enters a code. I have a table set up that has a code and a url for the code. When a user enters a code in the first form field it completes a cascading text box with the url and after clicking submit it takes you to the correct page. All good. However, I found that an entry is entered into the url table. So I set the fields as virtual fields and now it enters a blank value into the table. How can I prevent a entry into the table? Also, I would like the url field to be hidden and not displayed. So the only form field displayed to the user is the code field. In the Dynamic Redirect How To is says you can set up a field as hidden, but when setting the field to hidden nothing happens. I appreciate any help offered.

Hello, I have a table I am maintaining of products. It has about 1,000 records in it. One of the fields is SKU, which is a unique identifier for each product. Some users would like to be able to search for several SKUs within the file...how can they (or can they at all?) search for 100002, 102567, 256789 in one search field? I have the parameter today set up as "contains" - should I do something else? I've tried some boolean separators as well like ampersand or * but those didn't work. Any thoughts or ideas I could try? Thank you!

I am new to Caspio and need help. I created a data page that allows user to search a (or more than one) source. The results page lists the source(s) and for each their term number. User wants to select term numbers and pass those term numbers directly into second data page which I set up to search by term number. The solution I am being told is to use Java to creates a multiply select in data page 1 results page and pass selection to data page 2. If anyone can help me, I would greatly appreciate your help.

Hello everyone, I started using Caspio only a couple of days ago. As a first test project I am trying to build an invoicing app. I am now facing a problem and I really hope that someone here can help me. Before generating a new invoice, I need to enter all data for it. Customers I pick from a drop down, invoice date from the date picker etc. That is all fine. Now I select the Service I am sending the invoice for. (Let’s assume it’s only one service in the invoice.) This is another dropdown and refers to a table with, let’s say, the following content ID SERVICE PRICE 1 Accounting 100 2 Consulting 120 3 Training 140 In my data page I pick the service from a dropdown, display and value are both set to the 2nd column shown above. I pick Consulting, Consulting is displayed. The problem is, I need the price to show up somewhere so I can later calculate the invoice overall sum with it. I know I could insert a 2nd dropdown with SERVICE as display and PRICE as value, but I don’t want to drop down twice. So here is my question: How can I, in my data page, display the price (col. 3) of the service (col. 2) that I just picked in the drop down field? (By the way, the same solution will help me to, in the next phase, display the customer’s address in the printable invoice page, after I selected the customer’s name from a drop down. Same thing I guess.) Thank you very much in advance. I am looking forward to receiving your posts. Anatol

Hello; Does anybody know a way to dynamically set the data source of a data page? For example: tblData_[@authfield:AccountID] AccountID = 1 DataPage -> Data Source = tblData_1 AccountID = 2 DataPage -> Data Source = tblData_2 Much Thanks!!