Jump to content

PeterER8

Members
  • Content Count

    6
  • Joined

  • Last visited

  1. I just tired my expression with Null and that did not work Hmm
  2. Thank you JolliBeng! This is perfect t! I assume this can also be used with null in the logical expression, for example in a case where the Reason_1 field is empty : (CASE WHEN [@field:Reason_1] = NULL THEN 1 ELSE 0 END)
  3. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding dynamically selecting data labels on submission datapage based on a field. Assume I have a shift field and in that field I can select “morning” or “afternoon”. Based on that selection I would want the labels for the next 4 fields to either say “08:00” , “10:00”, “12:00”, “14:00” or, if it is afternoon, “16:00”, “18:00”, “20:00”, “22:00” The exact times can be stored in
  4. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding generating more than one table entry from a single submission form. Assume I have a DataPage where I list items that I own and the colour of each item. First, I enter a name (Max) in the name field, then in the item field I enter “ball”, then in colour I enter “white. On the next line in the item field I enter “toy soldier” and a colour I enter “green”. The table itsel
  5. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding hidden sections on a submission form and entering data in the fields there. So I have created a DataPage that depending on a Dropdown (either morning or afternoon) shows different sections (with the help of rules). If I select “morning” I get following cells that I need to fill with data from a dropdown ( [ ] signify the data entry cell on the form), the remaining f
  6. Hi Apologies upfront if my questions have been asked before (I could not find the answer). In my defense I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding DataType formula in tables and specifically trying to count the number of occurrences of a specific text string in that data row. Easy thing to do in excel (yes, I am damaged by too much excel usage). Basically I am after “count cells that contain x”. I understand the aspect that this only works for the row in which the formula field is present and that is perfectly fine. Exam
×
×
  • Create New...