Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

700 profile views

JulienMoulis's Achievements


Newbie (1/14)



  1. hi, view is the name my view. But I did tried to use the _v_, but I received a weird error message such as System error. (Caspio Bridge error) (FFFFFFFF) I concated the support thks
  2. Hi... I did what you suggest and I have this message on preview System error. (Caspio Bridge error) (FFFFFFFF)
  3. Hi everyone, I'm using a detail datapage on which I would like to show some average numbers. I'm using a view for this datapage. Is it possible to use SQL statement on views? Here is my Statement: SELECT SUM(FIDELIS_INTERVIEW) FROM view_fidelis_emp WHERE ID_EMP= [@authfield:ID_EMP] Thanks
  4. Hi, I want to create a ticketing system like caspio support. I have two table T_Ticket: --> ID_TICKET --> Ticket Subject --> Ticket Commentary and T_Detail_Ticket --> ID_DETAIL_TICKET --> ID_TICKET (Foreign key) --> Commentary_DETAIL_TICKET What I need is, when a ticket is created, create with an SQL insert the first detail_ticket commentary with the commentary_ticket Is that possible?
  5. Hi everyone, I've found this followig javascript code that allows me to move listbox items to one another listbox. The code works as he is on a submission form. But now I would like te reference my database listbox instead of the exemple. Can someone help me? Thanks The name of my "from" listbox is ID_SEARCH_FORM and the "to" listbox is cbParamVirtual1. CSS: <style type="text/css"> select { width: 200px; float: left; } .controls { width: 40px; float: left; margin: 10px; } .controls a { background-color: #222222; border-radius: 4px; border: 2px solid #000; color: #ffffff; padding: 2px; font-size: 14px; text-decoration: none; display: inline-block; text-align: center; margin: 5px; width: 20px; } </style> JAVASCRIPT: <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"> </script> <script> function moveAll(from, to) { $('#'+from+' option').remove().appendTo('#'+to); } function moveSelected(from, to) { $('#'+from+' option:selected').remove().appendTo('#'+to); } function selectAll() { $("select option").attr("selected","selected"); } </script> HTML: <form name="selection" method="post" onSubmit="return selectAll()"> <select multiple size="10" id="from"> <option value="html">Html</option> <option value="css">Css</option> <option value="google">Google</option> <option value="javascript">Javascript</option> <option value="jquery">Jquery</option> <option value="regex">Regex</option> <option value="php">Php</option> <option value="mysql">Mysql</option> <option value="xml">Xml</option> <option value="json">Json</option> </select> <div class="controls"> <a href="javascript:moveAll('from', 'to')">&gt;&gt;</a> <a href="javascript:moveSelected('from', 'to')">&gt;</a> <a href="javascript:moveSelected('to', 'from')">&lt;</a> <a href="javascript:moveAll('to', 'from')" href="#">&lt;&lt;</a> </div> <select multiple id="to" size="10" name="topics[]"></select> <form>
  6. Hi, Context: I have two tables: First: T_EMPLOYEE - PRIMARY KEY: Employee_ID Second: T_TASK - Primary key: ID_TASK, and Foreign Key: EMPLOYEE_ID_FK There is a Relationship on-to-many between those two (an employee can receive some task) I build a datapage tabular report based on T_TASK. I inserted in result page fields EMPLOYEE_ID_FK as a dropdown look up field as following: Table or view: T_EMPLOYEE Field for display: EMPLOYEE_FIRST_NAME Field for value: Employee_ID When I test the report I only see the first name when editing but I only see the number value when only display. see attached screenshot. Is there a way for displaying the right field for display in a no editing mode in a tabular report dropdown lookup field? Thanks for your help (I'm with the free version of caspio)
  • Create New...