bookish

Thank you @Alison for the efforts and the links. Happy new year!

HI Alison, The results should only be NO SIGNUP YET, SIGNUP HERE and SIGNUP CLOSED. Hence: please remove any reference to waitlist like: a. here in else if([@field:attendees] < [@field:max_attendees]) b. or here in test=test+'">Waitlist me</a>'; c. the last part should just say document.write("<div>Signup Closed</div>"), removing "& Waitlist " Thanks!

Hi Jan and Aurora, Is this script still working for you? It has stopped working in my program, I do not see the alert anymore. I would appreciate your feedback. Thanks!

Sorry for the late reply. If you could try it, please do. Please remove anything on Waitlist as we don't have waitlist anymore. Thanks much!

HI! Could anyone help me transform this code to a CASE-when scenario? <script> if ([@field:amount] == "0") { document.write("No Signup Yet"); } else if([@field:attendees] < [@field:max_attendees]) { document.write("<a href='URL?ID=[@authfield:ID]&activity=[@field:activity]&amount=[@field:amount]'>Signup Here</a>"); } else if ([@field:waitlisted] < [@field:max_waitlist]) { var test='Closed. <a href="URL?ID=[@authfield:ID]&activity=[@field:activity]&amount='; var countr = '[@field:country]'; if ((countr

hiHeezyMeezy, Thanks for taking time to study my case and to reply. Yes, I am updating a table ATTENDANCE where "an attendee [can] be associated to multiple scheduled activities". I have solved my problem with the suggestion posted by Vitaliksssss Thanks again. Appreciate it.

Hi, I am taking advantage of the triggered action in updating a related table, and I have found greater accuracy than using the increment attendees approach (old version). I am just finding a challenge in relation to bulk edit. I have 2 tables: attendance and schedule. In updating table ATTENDANCE record to FINISHED status, there is an increment of 1 to the field FINISHED (number of attendees who finished) in the SCHEDULES table. The triggered action works if I update one record. However, I have a datapage where activity in-charge use bulk editing to update several or all recor

HI! Live support is off on weekends. I have this problem I hope someone can help me. I get this error message in my site--- wp-content/plugins/caspio/classes/class-datapage-loader.php on line 4 i deleted the plugin 1.9 and uploaded the Caspio deploy plugin Version 2.0 but it still appears.

HI, I had a 4MB registration database that I thought is the reason why I have huge monthly billing (data overage). It only has 2300 records and 37 fields (name, dates, yes/no, etc.) I downloaded a copy, removed some irrelevant entries (mostly texts) and uploaded them again. The file size went down to 2.9MB. Since that registration database opens every time someone registers or updates her record, I decided to just remove the ones who finished the ativity and create a separate app to search these "finished" records. However, the file size remains to be 2.9MB even if I removed 1153 records. Shou

Great! It worked! Thank you very much, Jan

Hello! I would like to ask help on disabling a form or a way for a signup not to proceed because an authentication field is erroneous (e.g. the birthday has the year between 2000 and 2014). Thank you.

Thank you, Bangalore for the suggestion and sorry for the late reply. I had tried it why you posted your reply. But it does show only the age by month and day granularity. Perhaps I just don't know how to tweak it to suit my purpose.

Hi! I would like my report to show the difference between the start date of an activity and the birthday of a participant. It seems that datediff does not work as per my studies. Say the activity starts on Jan 1 and the birth day is Jan 3, I would like the column to show, 0 (for the month), 2 (for the days). Is this possible in Caspio?