@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!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
nuimage
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!
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.