i want to allow users to create a new record in a related table only if it's not already created For a certain date.
how can i check if a related record exist for this date?
the user have a button, that it should work as a switch.
the first time is pressed, it create a record to the related table, If it pressed another time, it delete the related record.
how can i tell to the script that he should evaluate if for today's date the record is already created?
how can i create a conditional formatting that change color based on the presence of this related record or not?