Search the Community

I have a details page with text fields that allows the user to submit data. After submission the destination is the same datapage so the user can keep editing the details page if they wish. After they click submit I'd like a progress bar/status bar that takes over the screen and says something like "Saving...." or "Processing......" Just like this js example does: http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage/ Also, if a user makes changes to the details page and tries to close the window before submitting, I 'd like a message to save "You have made changes to this form that you have not submitted/saved. Are you sure you want to close this window." Thanks in advance for the help.

I have two complex data pages that are both submission data pages. Because they are submission data pages, I do not have the ability to use view data to help create the new records. Because of this, I am being forced to make MANY database calls in order to get the data I need to create the new records. Requirement: Log user Login activity, load external parameters, redirect user to appropriate landing page based on user type Scenario #1: 3 states (User exists and is Member, User exists and is Admin, User doesn't exist and is NEW) Based on User Status: If Exist, Get Profile information and load external parameters (currently 12 params) If Exists, Get Profile Preferences and load external parameters (currently 27 params) Redirect to appropriate location Problem: If I keep with a Submission DP (submitting ProfileLoginLog), then I need 39 individual calls to the database because I don't have a view I can rely on. What I am Thinking: If I change the data page to an Update DP, I can then use a view that will support the Profile and Profile Preferences. But then I end up with two problems: How do I handle the condition (a VALID condition) of when the user is NOT found? How do I insert a record into the ProfileLoginLog table? Any Ideas? If I can solve this for one situation, I can solve this for both situations. Your help would be much appreciated. Lynda

Hi, Not sure if this is possible... I have a tabular report results list that uses a button (shows on each record) to send a url with the clicked record's ID value as a parameter to open a popup submission form. The submission form captures that ID value in a field and the user 'does other stuff' and submits a new record to a different table (now related to the original tabular results record the button was clicked from by that id value). What I need to do is, upon submission, instead of closing the submission popup, have the submission form clear but automatically go to the next record in the original tabular results list--sort of how a Details form can click through to the next record after update. This would have to be done in the Destination of the submission form, sending it back to itself BUT with the ID value of the NEXT record in the tabular results list as the parameter. I figure you could use a Virtual field in the submission form, set to calculation, to lookup the source View of the origin tabular datapage and get the 'next' ID value after the one the user originally clicked from, using the same Order By regime a the origin tabular results datapage uses (which has 4 OrderBy properties). It would be something like: SELECT TOP 1 ItemID FROM _V_myView WHERE myAuthID = '[@authfield:Users_AuthID]' ORDER BY firstField ASC, secondField ASC, thirdField ASC, fourthField ASC This obviously doesn't work. I don't think 'Top 1' wouldn't get the next ItemID in the recordset AFTER the current ID value stored in the submission form, based on the 4 Order By properties. So for example, if the tabular datapage results list shows 6 records and the order by properties puts them in the sequence ItemID=5, ItemID=3, ItemID=7,ItemID=2, ItemID=9, ItemID=12 and the user clicks on the record with ItemID=7 to open the submission form, passing ItemID=7 as a parameter, then the submission form's Virtual field calculation needs to get ItemID=2 as the NEXT record. Then in the submission form's destination I can use that value as a parameter when refreshing the form. This way the user can 'click through' the whole recordset in sequence, when submitting. Any help would be greatly appreciated, if this is even doable.

I have a submission form that have 2 date inputs and I would like to cancel a submission if these 2 inputs are the same date. This will prevent having "bad data" on my tables, not just an error message that a user can ignore and click submit anyway.

I have a submission form that my users needs to fill-up. I also created an email notification that contains all the fields on my form. The problem is that some fields can be blank and I would like to remove those fields to make the email shorter. Is there a way to this in caspio?

Does anyone know the adjustment for this code to work? I'm trying to copy the value of a Virtual field (drop down) to a regular text field, on a button's click. Here's the code I'm working with: <div style="text-align: center;"> <input class= "cb_custom_btn" type="submit" onclick="myfunction()" value="Submit" /> <script> function myfunction() { var virtualval = document.getElementByID("cbParamVirtual4").value; document.getElementByID("InsertRecordMyFieldName").value = virtualval; } </script> </div> I'd also tried the ElementsByName with [0] for cascading values but that doesn't work either.. What's weird is I've used code similar to this for the same purpose with no problem so I must be missing some minute detail. Any help would be greatly appreciated.

Hello, Is there a way to copy an image field from one table to another in a Submission form? I'm using Cascading Text to grab values from fields from a table (based on an ID identifier for the record) and put them into the fields for another table on a Submission form but cannot get the image field to do this. Some kind of workaround would be really great.

I am able to get the below working on a Submission form with the element set to text box. Is there a way to do the same thing, but with the autocomplete element chosen? So far I have not been able to get it to work when I change to element type from text box to autocomplete. It does not add the entries together

I am having trouble with a submission form getting a total amount. I can get the javascript to work if I enter values in standard fields. It works fine if I use custom values in a dropdown. Where the code does not work is when I use a cascading dropdown. The form is an internal billing request form. There is a price field which is based on the product selected in a previous form. When the select the product, the price goes into the cascading dropdown and fills in the form properly. After price is a field for additional charges and following that a field for discount. I have the following javascript in the footer of the submission form. <SCRIPT LANGUAGE="JavaScript"> function summation() { var Cost = document.getElementById("InsertRecordPrice").value; var Additional_Charge = document.getElementById("InsertRecordAdditional").value; var Disc = document.getElementById("InsertRecordDiscount").value; var Total_Invoice = parseFloat(Cost) + parseFloat(Additional_Charge) + parseFloat(Disc); document.getElementById("InsertRecordTotal").value = Total_Invoice; } document.getElementById("caspioform").onsubmit=summation; </SCRIPT> There's obviously something I'm not getting about the difference between entering a value and using a cascading dropdown. Technically, it doesn't even need to be a cascading dropdown if there is another way to get a default value from a table. If anyone can see where my error is, please let me know. I even created a stand alone form with only the 5 necessary fields just for experimentation and I'm stumped. Thanks in advance.