Jump to content


  • Content Count

  • Joined

  • Last visited

About jgorny

  • Rank

Recent Profile Visitors

389 profile views
  1. I asked support about similar aggregation issues. Essentially each SQL call in a calculated field is a 1-1 - so you can grab extra an extra row of data but you can't really grab sets based on a single value - UNLESS - you use a FOR XML construct. I am spending some time digging into this aspect of MSSQL because SQL Server 2016 is providing FOR JSON which will allow for similar aggregations but formatted in a way that is easier to work with in javascript than XML. You get a XML recordset. Haven't played around yet with it. The example code they gave me (since I want to build family
  2. Hi, I am trying to work out a way to get a flat view, but having a difficult time trying to figure out how to make Caspio return what I need. I have a table of locations, and a table of workers. Each worker works at one location. Each location has one parent. A location can have many children. Say the location table has: Loc_ID | Location | Parent_ID ----------------------------- 1 | USA | NULL 2 | Oregon | 1 3 | Portland | 2 Now say I have a worker who had credentials at the national headquarters. I can create a flat view that connects him dire
  3. In the form datapage, you need to go to the advanced tab and set your dropdown field to grab the external parameter you are sending on load. If you don't, the form will just reload on submission as if it was new.
  4. Hi! I think I understand you correctly. I have a field with a lastnamefirst_usr and a user_id field. I'd like to use autocomplete based on the name, but have the user_id field entered in the form. So I start with a virtual autocomplete field that selects from lastnamefirst_usr. Then I add a cascading field that uses the autocomplete as a parent field, and selects the user_id field from the table. And I know ways to hide that second field. Is that correct? I originally had code that populated a dropdown and changed the value of the dropdown based on an autocomplete f
  5. The answer to this question doesn't really say enough to be helpful. The problem the original person is having is that same issue that I have. I have a table that stores several lookup key fields as IDs from other tables. I can set those fields to be editable dropdowns in the submission datapage form that will list a text field in the dropdown, but store the ID number in the key field on my record. But if I try to change the field on the form to an AutoComplete field, the only choices the wizard gives me for searching values on that form are other integer fields in the lookup table
  • Create New...