Jump to content


  • Content Count

  • Joined

  • Last visited

  1. Found out that this is "by design" When a control is hidden by a rule, the value is not saved in the table on InsertRecord. Unhiding the control means that the value is saved When a control is hidden by javascript, or via marking it "hidden" in the control type, the value is saved in the table on InsertRecord Hopefully this helps others Mark
  2. Hi all, I've got a very frustrating problem that I can't seem to solve, and it's driving me nuts. Form is http://www.createafoundation.org/enquire In my insert record form, I have a field called "caf_code" that is hidden dropdown list populated from a view (hidden by a rule on the datapage). I pass a variable to the form (via a cookie and some js) that sets the index of the dropdown list depending on the variable value. This works fine, and I can query the javascript console to confirm that the dropdown has the right index and value even though it is hidden. Now, when I submi
  3. Thanks Chad - let me digest this and I'll post back Cheers Mark
  4. Hey Iren, thanks for the reply. I'd much rather keep the directors in a separate table and use a foreign key to join - much better database and programming practice. The number of directors can vary - from 1 up to 5. Imagine if they were employees instead - there could be anywhere from 1 to hundreds per company and that would make a flat file pretty difficult to manager Cheers Marl
  5. Hi there, I've got an application that allows for a company to self-register to a service. All company-relevant information goes into the Companies table and they can edit this as needed. This functionality is pretty straightforward in Caspio, but now I want to extend it. I'd like to capture details on the company directors during the registration process. The intent would be to have a dropdown asking for the number of company directors, and then provide a form (or forms) to gather the name, email, contact details etc of each one (either all together or consecutively). These detail
  6. After letting this bubble around my brain for a while (which didn't take long ) I solved it by just doing a SQL inner join in a calculated field: SELECT name FROM fm_intervals WHERE fm_intervals.value = [@field:client1_income_interval] Makes much more sense to do it this way - it is far more elegant and allows me to make changes to my table without having to change my datapage each time.
  7. Hi Jan, thanks for the reply - yes that works, however only for the first looked up value in the view that is from the same lookup table. One of my tables uses duration/name pairs (e.g. 1/Yearly, 12/Monthly, 4/Quarterly, 365/Daily etc) and this is used multiple times on the datapage report detail (income and expenses for a client). I can join the first duration entry fine (and it works) but subsequent ones result in a view with no data. Caspio support suggest s using virtual fields and rules to hide or show the text; to me this isn't very elegant as it negates good database and prog
  8. Hi there - quick question about relationships. I've created a relationship between two tables using the Relationship Settings dialog, and set the "Value for display in Related Field" to the desired field. This works great - in the table view, I can see this lookup happening no problems (this substitutes the integer values 0/1 for the text values "Single"/"Married"). When I use the table as a datasource for a Report Details Datapage, I see the original value ("0"), not the looked-up one ("Single"). Is this by design? How can I set the report to show the looked up value, not
  • Create New...