how to add a static date depending of a course (schedule) or sql result query ?

how to add a static date depending of a course (schedule) or sql result query ?

by REMI PICARD (substitute) -
Number of replies: 0

hi,

the DATE element we can insert into the certificat is a today date isn't it ?

we need to add a date which would be enter by the teacher  OR would be the date of a schedule (scheduler plugin).

Imagine the student need to pass a oral test (like a vision session) and the teacher need to add this date on the certificate. we cannot use the current date element in this situation.

is there no way to insert a "SQL" result from a sql query we could enter ? it would be very userful to have a custom value from a thing like SELECT date(XXX) FROM YYY where teacher=XX and student=YYYY and course=ZZZ

have a good day

Pierre

Average of ratings: -