Jump to content

kme

Members
  • Content Count

    24
  • Joined

  • Last visited

  • Days Won

    2
  1. Hello, There is one column on the Results Page where there are duplicates. How do I make the column have only distinct values? Thanks.
  2. How do you store the Calculated Field values into a table? I'd like it done automatically as the value is being calculated.
  3. Does anyone know of a workaround for this, without having to pay the support team for customization?
  4. When creating a Report DataPage, one of the first things you can do is "Select Filtering Data". When I've selected a field, I want the filtering value to be from a View (which is not part of this DataPage's data source). The View itself has filters and contains only one row, which contains the value that I want to filter the DataPage with. Is there anyway that I can select the value from the View and input it into the DataPage filter value field?
  5. One field, titled FullText, on a Details Page is a long text, like: 01 TEXT TEXT TEXT TEXT TEXT 02 TEXT TEXT TEXT 03 TEXT TEXT TEXT TEXT TEXT TEXT 04 text text text text 05 text 06 text text 07 text text text 08 text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text 09 text text text text text text text text text text text text text text text text text text text text text text text text How do I format it so that it becomes like: 01 TEXT TEXT TEXT TEXT TEXT
  6. Thank you so much, the fields are non-editable and everything is working now. Here is my code: <script> document.getElementById('EditRecordSupportReadyYes').disabled= true; document.getElementById('EditRecordSupportRequiredYes').disabled= true; document.getElementById('EditRecordSupportRequired0').onclick= function () { if (document.getElementById('EditRecordSupportRequired0').value == 'Y'){ var currentdate = new Date(); var datetime = (currentdate.getMonth()+1) + "/" + currentdate.getDate() + "/" + currentdate.getFullYear() + " "
  7. So there is no way to do it, whether with Javascript or..?
  8. Is there a way to create a search filter for a calculated field?
  9. This is the solution: SELECT TOP 1 RonOpportunity FROM Routing_1 WHERE RonOpportunity !='' AND Current_Open_NEF_Data_Ship=AcNum
  10. This is the SQL that works, for Table A and Table B. Table B is the data source for the DataPage, and Table A isn't. I want to update Table B's column "City" according to Table A's column "Letter". TABLE A +----------+-------+ | Number | Letter| +----------+-------+ | 1 | A | | 1 | | | 1 | | | 2 | | | 2 | | | 3 | | | 3 | B | | 3 | | | 3 | C | +----------+-------+ TABLE B +--------+-------+ | AC | Ci
  11. Thanks so much. How do I make it so that the aircraft number in "(aircraft number) not complete; please process." refers to the number the user typed into the form?
  12. There is a form where user can input aircraft number, and records/results are shown accordingly. When there are no records found, it says "No records found". However, I want the text to say "(aircraft number) not complete; please process." How do you do this? Thanks for any help.
  13. For those interested in the solution: CAST(Datediff(hour, [@field:SupportRequiredYes], [@field:SupportReadyYes])/24 AS CHAR(15)) + 'days ' + CAST(Datediff(hour,[@field:SupportRequiredYes], [@field:SupportReadyYes])%24 AS CHAR(15)) + 'hours'
  14. [Please skip to the first comment that I posted] On this DataPage: http://b4.caspio.com/dp.asp?AppKey=b05320005057b918f4354d1992ba I want the TimeDifference column to have the difference between the 'SupportRequiredYes' and 'SupportReadyYes' timestamps, in days and hours. What is the simplest way to do this? This is what I have so far, but there has to be an easier way. The code is after the comment "//TIME DIFFERENCE". This has it so that when 'SupportReadyYes' radio button on the Details Page is clicked Yes, the time difference is calculated. <script> document.getEleme
  15. [Please skip to the first comment I made] I have a slightly complicated procedure I'd like to implement. DataPage D's data source is from View V In the Results Page of DataPage D, I'd like to include a field F that's from Table T But Table T is not included in View V. This is a sample Table T: [iD] [fieldF] 1 A 1 1 B 2 2 C 2 2 3 3 This is a sample View V, according to Table T: [iD] [fieldF] 1 A 1 A 1 A 1 A 1 A 1 A 2 C 2 C 2 C 3 3 3 3 3 3 ID from Table T = ID from Vie
×
×
  • Create New...