• Content count

  • Joined

  • Last visited

  1. Hi all, I'm a newbie and would like to know if it is possible to create a hyperlink within a calculated field? Any help is greatly appreciated. Thank you
  2. Replacing blanks in a field

    Hello there, i had the same question. i'm sure by now you've found the solution but i will answer the post in hopes that it may help other newbies. From Datasheet view select the replace tab in the "find what" field enter a "space". in the "replace with" field enter "some text" in the "search range" field enter "all" in the "direction" field enter "all" or "current column" select both "match case" and "match entire field" the find should find all blank entries. once those entries are found, you can then select "replace" or "replace all". be careful with the replace all, i would suggest testing a single row before updating all. I hope this helps someone else.... Regards
  3. How to tally ye/no responses.

    Hello David, did you receive a response to your question? if not you may want to create a new thread. regards
  4. How to tally ye/no responses.

    Thank you MayMusic for responding!
  5. How to tally ye/no responses.

    Franchiser, Thank you! Thank you! for such a quick response. Initially, i tried a select statement but instead of a value of "1", i indicated a value of "yes". I completely forgot that Yes/No fields have numerical values of "1" or "2". Your solution worked like a charm. Thanks again, you are a life saver. nuimage
  6. Hello All, I have a simple form asking users to check the "Yes" checkbox if they prefer a vegetarian meal option. The field datatype is "Yes/No". I have a report that i would like to count only those who checked "Yes". I've created an aggregate field in the report called "Veg Count" and I have selected the field "veg" to do a count function on. However, i'm unable to count only those who have checked the checkbox. It gives me a tally of all entries "yes" and "no". How can i count only those boxes that have been checked and has a value of "Yes". I cannot figure out how to create such a report. Any help would be greatly appreciated!
  7. CASE in calculated field

    Hello Vitalikssssss, I've reviewed the article countless times on "how to limit the number of submissions" but still cannot get the form to update the courses table. I did correct a small typographical error in the javascript (semicolon missing from first edit record statement) that updates the page but still without success. What am i missing? Below is the the javascript from my single record update page. Unique ID field - Course_ID Parameter name - [@cid] Attendees - field to update Header code - <div style="display:none"> Footer code - </div> <script> document.getElementById('EditRecordAttendees').value; parseInt(document.getElementById('EditRecordAttendees').value) + 1; document.getElementById('caspioform').submit(); </script> Destination after record update goes to a new data page. I'm forwarded to the new page as expected and do receive the confirmation message that i crafted, but the Attendees field in the Courses table is never updated. Thanks for your input!
  8. CASE in calculated field

    thanks, i will.
  9. CASE in calculated field

    Hello Vitalikssssss, Is there a way to update the record dynamically without creating a Single record update form? I have a registration page that list all "Published" courses. This status is set when the course is created. However, when the criteria is met (student count >= MaxParticipants allowed for course) I would like to update the the field "CourseStatus" with the value "Not Active". Essentially, the updated status would remove the course from the Published list of courses. Thanks again for your help!
  10. CASE in calculated field

    Thank you for such a quick response. I will give it a try and let you know the outcome. Thanks again!
  11. CASE in calculated field

    Hello, Please help! i'm a newbie to Caspio. I want to update a Table value but can't figure out how to do this. I have created a Reports Datapage and would like to UPDATE CourseStatus to 'Not Active' when @calcfield1 >= MaxParticipants. MaxParticipants (fieldname) CourseStatus (fieldname) @calcfield1= count of participants SELECT COUNT(*) FROM iied_tlpreg_Participants WHERE iied_tlpreg_Participants.Course_RECID = [target].[@field:Course_RECID] @calcfield2 = CASE WHEN[@calcfield:1] >= [@field:MaxParticipants] THEN 'Not Active' ELSE 'Published' END CourseStatus is a hidden field in the data page and on load, receives the datasource field @calcfield2. I can see the correct value from the data page but the Table doesn't get updated. Any help on how to update the field is appreciated!