11 Replies Latest reply on Feb 19, 2017 11:17 AM by user28397

    Check if related record exist for a certain date

    user28397

      Hi

      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?

       

      thanks