Jan

Hi cflanagan, Welcome to Caspio Forum! I have found the following information on the page: "Caspio Authentication server supports only “client credentials†flow at the moment, so only confidential clients, clients capable of maintaining the confidentiality of their credentials (e.g., client implemented on a secure server with restricted access to the client credentials), or those capable of secure client authentication using other means are supported." Please make sure that your authentication is supported at the moment.

Hello Andy, Welcome to Caspio Forum! If I understand correctly, you can define what field is displayed on the "Editing" tab of the "Configure Results Page Fields" step. As far as I know, these settings defines both Inline editing and Grid Edit mode. Does it work for you?

Hello CollinCC, Welcome to Caspio Forum! As far as I know, this script cannot disable the "Enable data grouping by this field" checkbox. Please make sure that this field is not used in any Aggregate.

Hello ScottDube, Could you please provide the file? It is interesting to find the reason of the issue.

Hello Niranjan, If I understand correctly, you can add a Criteria. On the "Configure Filtering Fields" step, select Username field, click the "Insert" picker and select "New Criteria". Then you can select "Is Blank" Comparison Type for the Criteria1 and equal [@authfield:USERNAME] for the Criteria2. I hope, it helps.

Hi Jan Could you please provide the URL of your webpage? It is probably bug, but I hope I can find the temporary workaround.

Hi Sergio, I am sorry for delayed response. You can try doing the following steps: For example, names of Fields: Id - the name of "ID" field; "Project" - the field with name of "Project", if you use this field; "UniqueReference" - the field for Unique Reference. 1) Create a Single Update Form: 1a) On the "Record Identification" step, in the field "Parameter name:" enter like: [@InsertRecordID] 1b) On the "Select Fields" step, select your "Project" and "UniqueReference" field (if "Project" is used); 1c) On the "Configure Fields" step 1c*) Set "TextField" Form element for "Project" and "UniqueReference" fields; 1c**) Add a Header&Footer element, select the Header element, click the "Source' button" enter the following code: <div align="center"> <p>Processing...</p> <img src="images/progress_bar.gif" alt="Progress Bar" width="200" height="15" /> </div> 1c***) Select the Footer, click the "Source" button and enter the code like following: <SCRIPT LANGUAGE="JavaScript"> var position1 = document.getElementById("EditRecordProject").value; var position2 = "[@InsertRecordID]"; var allpositions = "IR-" + position1 + "-" + position2; document.getElementById("EditRecordUniqueReference").value = allpositions; if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } </SCRIPT> If you do not use the "Project" field, you can use the following code: <SCRIPT LANGUAGE="JavaScript"> var position2 = "[@InsertRecordID]"; var allpositions = "IR-ProjectName-" + position2; document.getElementById("EditRecordUniqueReference").value = allpositions; if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } </SCRIPT> I have marked names of fields. Please make sure that you enter names of your fields. 2) Edit your Submission Form. 2a) On the "Select Fields" step, check the "On exit, pass AutoNumber ID field as parameter" checkbox. It is under the "Available fields" section. 2b) On the "Destination and Emails" step, select - if you use Embed Deployment: "Go to a new page" and enter the URL of the page where the DataPage from step 1 is deployed; - if you use iFrame or URL Deployment: "Go to a new DataPage" and select your DataPage. Now, when a new record is added, the Autonumber is passed as parameter to Single Update Form. On this form Unique Reference is created, entered to the field, and the form is autosubmitted. A user sees "Process" instead of the Single Update Form. I hope, it helps. Fell free to ask, if anything is unclear.

Hello Alan, You can add the Header&Footer element, select the Footer, click the "Source" and enter the following code: <SCRIPT LANGUAGE="JavaScript"> function set_param() { var inserted_value="[@Virtual_Location_name]"; var v_dropdown = document.getElementById("EditRecordAV15"); var selection = v_dropdown.options[v_dropdown.selectedIndex].value; if (selection=="BR") { document.getElementById("EditRecordNE15").value = inserted_value;} else { document.getElementById("EditRecordNE15").value = "";} } document.getElementById("caspioform").onsubmit=set_param; </SCRIPT> If you want to check other fields, you can add lines like: <SCRIPT LANGUAGE="JavaScript"> function set_param() { var inserted_value="[@Virtual_Location_name]"; var inserted_value2="[@Virtual_Location_name2]"; var v_dropdown = document.getElementById("EditRecordAV15"); var selection = v_dropdown.options[v_dropdown.selectedIndex].value; if (selection=="BR") { document.getElementById("EditRecordNE15").value = inserted_value;} else { document.getElementById("EditRecordNE15").value = "";} var v_dropdown2 = document.getElementById("EditRecordAV16"); var selection2 = v_dropdown2.options[v_dropdown2.selectedIndex].value; if (selection2=="BR") { document.getElementById("EditRecordNE16").value = inserted_value2;} else { document.getElementById("EditRecordNE16").value = "";} } document.getElementById("caspioform").onsubmit=set_param; </SCRIPT> I hope, it helps.

Hello Niranjan, As far as I know, API allows to insert records only one by one. You can import the whole table, for example, Excel file, if it works for you.

Hi! I have entered the following code to the Header (after click "Source"): <style> #InsertRecordSTART, img[alt="Calendar"] { float: right; } </style> Please enter the name of your field instead of "START", and if you add the code to Single Update form, enter EditRecordFIELDNAME. I hope, it helps.

Hello Alan, If I understand correctly, you can try doing the following steps: 1) Create a Submission or Single Update Form (I am not sure, what you want - to add a new record or to edit the current record). This form receives parameters and auto submit the form. 2) Create App Parameter with the URL of this form. 3) Edit your Report DataPage, insert links that go to the Form and pass parameters: 3a) Delete fields like "OK"-"NO" and add an HTML Blocks instead of them. 3b) Edit HTML Blocks: click the "Source" button and enter the code like following: <a href="[@app:SubmissionForm]&resource=[@field:resource]&day=mon">[@field:mon]</a> <a href="[@app:SubmissionForm]&resource=[@field:resource]&day=tue">[@field:tue]</a> <a href="[@app:SubmissionForm]&resource=[@field:resource]&day=wen">[@field:wen]</a> <a href="[@app:SubmissionForm]&resource=[@field:resource]&day=thu">[@field:thu]</a> <a href="[@app:SubmissionForm]&resource=[@field:resource]&day=fri">[@field:fri]</a> I hope, it helps.

Hello sddenrweb, I hope, I get it. As far as I know, "5 DataPages incuded" meas, that you can create five DataPages. You can try creating of six DataPages and see, if the another messages is displayed. Number of deployed DataPages are on the right side (Current Usage), if I understand correctly, you see "DataPages 2 of 2", the second number is number of DataPages that may be deployed.

Hi Niranjan, You are welcome!

Hi Bookish, I am not sure that understand correctly both scripts, but i have tried to concatenate them: <script> if ([@field:amount] == "0") { document.write("No Signup Yet"); } else if([@field:attendees] < [@field:max_attendees]) { document.write("<a href='URL?ID=[@authfield:ID]&activity=[@field:activity]&amount=[@field:amount]'>Signup Here</a>"); } else if ([@field:waitlisted] < [@field:max_waitlist]) { var test='Closed. <a href="URL?ID=[@authfield:ID]&activity=[@field:activity]&amount='; var countr = '[@field:country]'; if ((countr !="country1")&&(countr !="country2")) { if('[@field:activity]'=="activity1") { test=test+'[@field:amount1]'; } else { if('[@field:activity]'=="activity2") { test=test+'[@field:amount2]'; } else { test=test+'[@field:amount]'; } } } else { test=test+'[@field:amount]'; } test=test+'">Waitlist me</a>'; document.write(test); } else { document.write("<div>Signup & Waitlist Closed</div>") } </script> I hope, it works - and works correctly.

Hello sddenrweb, May I ask, how many DataPages have you created? When you open the DataPages page, there is the "Deployed" column and for ever DataPage the "Enabled" or "Disabled" is displayed in the column. If I understand correctly, "three allowed DataPages" means that three DataPages may be marked as "Enabled", even if only one of them is really deployed. Please make sure that only two DataPages in your account are marked as "Enabled".

Hello Scottster, Could you please provide the whole script or the URL of your page? I have tried with the following script: <script> var v_NewDate = new Date(); var v_LeadTime = 10; v_NewDate.setDate(v_NewDate.getDate() + v_LeadTime); alert(v_NewDate); </script> And I have got the correct date, April 21th.

Hi aam82, Do you want to edit records as an admin or you clients want to edit records with Bulk Update? An admin can export the table, change values in Excel and import it back. I am not sure, that it will be faster, however. Users can use Grid Edit - I am not sure that it is faster, but it is more... dynamic or interesting I hope, it helps.

Hi Olivier, As far as I know, now it is impossible. You can create one more field and add the Concatenate of all fields ti this field every time, when one of fields is changed, if it works for you. There is the idea in the Ideabox, add possibility to have a calculated field in a View. If this possibility will be added, you can group by the calculated filed that concatenate your fields. You can vote for the idea, and probably, this feature will be added faster.

Hi Niranjan, If I understand correctly, the following line brakes the code: var oldstyleemail = document.getElementByID("InsertRecordPermittedUserEmail").value; JavaScript cannot find the "InsertRecordPermittedUserEmail" object and stops. If you display alerts after every line, like var PermittedUserEmail = document.getElementByName("InsertRecordPermittedUserEmail")[0].value; alert(PermittedUserEmail); var oldstyleemail = document.getElementByID("InsertRecordPermittedUserEmail").value; alert(oldstyleemail); var ProjectID = document.getElementById("InsertRecordProjectID").value; alert(ProjectID); You see, that only the first variable is displayed. I think so

Hi Niranjan, The first element is dynamic, if I understand correctly. So you can change var PermittedUserEmail = document.getElementById("InsertRecordPermittedUserEmail").value; to var PermittedUserEmail = document.getElementsByName("InsertRecordPermittedUserEmail")[0].value; Then the whole script will be like: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var PermittedUserEmail = document.getElementsByName("InsertRecordPermittedUserEmail")[0].value; var ProjectID = document.getElementById("InsertRecordProjectID").value; var ChkUnique = PermittedUserEmail + ProjectID; document.getElementById("InsertRecordChkUnique").value = ChkUnique; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> I hope, it works

Hi Berean, My idea is: 1) Create the table with locations names. 2) Create a Tabular Report, select the table from step 1 as a DataSource. 3) On Results page add a Calculated field and enter SQL query like: SELECT SUM(name_of_the_field_with_id_in_view) FROM _v_viewname WHERE name_of_the_field_in_view_where_locations_are _stored = target.[@field:locationfieldname] Please, enter your values instead of green values. I hope, it helps. Let me know, if anything is not clear.

Hello sddenrweb, Unfortunately, I have not seen the attachment. Could you please to attach it one more time? As far as I know, "Build as many DataPages as you want, but only 3 DataPages can be deployed outside your account to your own website", but you have read the page. Maybe, you have three DataPages that are marked as "enabled" in the "Deployed" column, but only two of them are really deployed? If yes, you can disable the third "enabled" DataPage that is not deployed. You can click the "Deploy" link and then "Disabled". I hope, it helps.

Hi Niranjan, Sometimes it is enough to see the code of the page, and if I have the URL, I can see the code with the "Inspect element" feature of browsers. Maybe, I will be able to find what is wrong. And I hope I will have free time to investigate your page

Hello Geoff, Could you please provide the URL of your page? If the field is not displayed, its value is not submitted. But if the field is displayed, its value is submitted. I have checked this a couple minutes ago and the data was submitted. Maybe, there is some additional conditions.

Hi Niranjan, Are fields dropdowns or cascading dropdowns? Cascading dropdowns are dynamic. Could you provide URL to your pages? You can use "Send message", if you want.