-
Posts
635 -
Joined
-
Last visited
-
Days Won
35
Everything posted by Jan
-
Hello tpurdue, As far as I know, you can enter the formula like ([@field:Field1]+[@field:Field2]+[@field:Field_n])/n in your Calculated field.
-
Hello kme, I think, you can store the value of a Calculated field to the table and then work with it. It is not the best solution, but it is a solution.
- 9 replies
-
- search
- search filter
-
(and 1 more)
Tagged with:
-
Import Excel File With More Than 255 Columns
Jan replied to TroyPurdue's question in Import/Export and DataHub
Hello tpurde, Can you open the .CSV file via Exel and edit it? I think then you can save the file as a .CSV and import it back. -
Hello kme, I think, the simplest way is to use one additional DataPage that will take the value from the View and pass it as a parameter to your DataPage.
-
Hello kme, If I understand correctly, You can format the text it in your table. Also you can store the data as the HTML code (with tags). Then on the Configure Details page fields page, in the field Render values as, enter "HTML".
-
Hello Wallace, Please check the Destination and Triggers page of the DataPage. I think, an incorrect URL may be entered in the Go to a new page field.
-
Hello kgjlist, you can use Virtual fields. In this case no record will be opened and edited. But the changes will not be saved. If you want to save changes, you can use, e.g., the Details type of Reports with pre-defined criteria and make the check-boxes editable.
-
Hello kme, This message can be edited in your Localization. You can read details in the article.
-
Hello tpurdue, If you need to calculate an average value of some fields of the same record, you can use Calculated fields. You can create Charts by Calculated fields the same way as by any other fields.
-
How To Style The "view Details" Page?
Jan replied to ccvortex's question in Styles and Localizations
Hello ccvortex, You can edit items: Form/Details - Labels - Default (settings of the text) and Form/Details - Layout - Label Cells (settings of the background color) You can find details about settings of Layout in the article. I would recommend you to create a new Style for the DataPage. -
Javascript On Autocomplete Fields
Jan replied to quinnygdn's topic in User JavaScript and CSS Discussions
Hello quinnygdn, If I understand correctly, IDs of your fields may become dynamic. You can try to change your code var Flightno = document.getElementById("InsertRecordFlightno").value; var Date = document.getElementById("InsertRecordFlightDate").value; var Dayno = Date.getDay(); var Dayno = document.getElementById("InsertRecordDayno").value; like var elems = document.getElementsByTagName("*"); for (var i=0, m=elems.length; i<m; i++) { if (elems[i].id && elems[i].id.indexOf("InsertRecordFlightno") != -1) { var Flightno = elems[i].value; } if (elems[i].id && elems[i].id.indexOf("InsertRecordFlightDate") != -1) { var Date = elems[i].value; } if (elems[i].id && elems[i].id.indexOf("InsertRecordDayno") != -1) { var Dayno = elems[i].value; } } -
Ine Login Form - Many Apps
Jan replied to leadma's question in Security, Authentications, Roles, SAML
Hello leadma! You can read the article Create User-Specific Redirect After Login ? I hope it can help you. -
Js: Concatenate/combine Two Fields Into One Field
Jan replied to leadma's topic in User JavaScript and CSS Discussions
Hello Leadma, In the script, semicolons after some lines are absent. You can try the code like: <script language="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordPosition1").value; var position2 = document.getElementById("InsertRecordPosition2").value; var allpositions = position1 + position2; document.getElementById("InsertRecordAllPositions").value=allpositions; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> -
Hello Thor, You can use conditional-forms. Put the Calculated field in a separate Section (I made my field the last and create a Section that contains only one field). Add a Rule, add a criteria that is always true (e.g., Value 1 equal Value 1), and add an action that hides the Section. You can read more details in the article in How To: http://howto.caspio.com/datapages/forms/conditional-forms/
-
Hello Thor, Maybe, this article can help: http://howto.caspio.com/tech-tips-and-articles/parameters/results-and-details-on-two-separate-web-pages/
-
Hello Ezio, If you want to compare whether two variables are equal, you should use "==" instead "=" Try to change the code like var data = { if ([@authfield:users_list_registry^]=='Y' && [@authfield:companies_list_registry^]=='Y') { anagrafiche: "Yes", } else { anagrafiche: "No", } };
- 6 replies
-
- parameters
- var data
-
(and 1 more)
Tagged with:
-
Hello tclemendor, Do you want to search records via Report DataPage? Then on the Configure Search Fields step you can add criteria (one or more) to one field and select OR as a logical operator between criteria. You can find more details in the article in How To http://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/ The Combining Comparisons and Range Searches part.
-
Hello Ben, The Plugin can only update your Access/Excel data on the local PC. But you can import your files from the local PC to the web. Please read the Importing Data article for details on how to prepare and import data. I would recommend you to use Replace Action instead of Append, because the System maight do not recognize that fields already exist.
-
Hello Ovidium, If I understand correctly, you can try next steps: 1) In the table, set the field as unique (in the Table Design tab, select the Unique check box). 2) On the Configure Fields page of the Wizard, select the field and enter 6 to the Character length - Max field. 3) Add Header and Footer, in the Footer, enter the code like <SCRIPT LANGUAGE="JavaScript"> function checkInput() { var text = document.getElementById("InsertRecordFIELDNAME").value; var pattern = /^[A-Za-z]{3}[0-9]{3}$/; if (pattern.exec(text) === null) { alert('Please, enter data in format AAA111'); return false; } } document.getElementById("caspioform").onsubmit=checkInput; </SCRIPT> Enter the name of your field instead FIELDNAME.
- 1 reply
-
- special format
- varchar
-
(and 1 more)
Tagged with:
-
After Submit, Stay On Page, Scroll To Position/anchor
Jan replied to staaks's topic in User JavaScript and CSS Discussions
Hello Staaks, As far as I know, you can use iFrames. When you click Deploy, on the Deploy window, there are several buttons and Frame is the third. I would recommend you to use iFrame - you can paste the code the same way as embed deployment. You can add the code width="x" height="y" in pixels to define the size of the frame. Then the code will be like: <iframe width="x" height="y" name="NAME" title="TITLE" src="LINK">Sorry, but your browser does not support frames.</iframe> -
Hello Thor, Can you say the URL of this page, please? Maybe, the code with User, Admin etc is present in the Footer of your DataPage or in the Footer of the Authentication?
-
Hello Brad, You can use the JavaScript code like: <script language="JavaScript"> var meta = document.createElement('meta'); meta.name = "Author"; meta.content = "Name"; document.getElementsByTagName('head')[0].appendChild(meta); </script> To add the JavaScript code to your DataPage, add it to the Footer of the DataPage. Best regards, Jan
-
Hello Luiz, It seems that both brunches have the same code: document.getElementById('Section3').style.display = 'inline'; document.getElementById('Section4').style.display = 'none'; Probably, in one of cases the code should be like document.getElementById('Section3').style.display = 'none'; document.getElementById('Section4').style.display = 'inline';
-
Hello, Vzahomes2, You can change the line TwoWeeksAgo.setDate(TwoWeeksAgo.getDate() - 14); to two lines: TwoWeeksAgo.setDate(1); TwoWeeksAgo.setHours(0,0,0); So, the beginning of the script will be like the code: <script> var TwoWeeksAgo = new Date(); TwoWeeksAgo.setDate(1); TwoWeeksAgo.setHours(0,0,0); function chk_date(){ ...