Re: Setting Key Field/Formula Field as Key Field Issues
Hey Michael,
Thanks for the reply last week. I used the pipeline idea to add the parent record ID to the child record by matching the user it gets assigned to and the date it was assigned to the user and date on the schedule, and that's working.
What I'm trying to do now is stop users from creating more than one record on the scheduler table for the same day. In the past, a person who works 7 am to 9 am, and then 5 pm to 8 pm would enter two records on the scheduler table with the same date. I've added functionality in the form to cover for this, but I still want to try and stop users from adding more than one record per calendar day. Any idea how I would do that? I've already got the User + Date field, but how do I say in a data rule that a new record can't be created when one already exists with that value?
------------------------------
Daniel Johnson
------------------------------
Thanks for the reply last week. I used the pipeline idea to add the parent record ID to the child record by matching the user it gets assigned to and the date it was assigned to the user and date on the schedule, and that's working.
What I'm trying to do now is stop users from creating more than one record on the scheduler table for the same day. In the past, a person who works 7 am to 9 am, and then 5 pm to 8 pm would enter two records on the scheduler table with the same date. I've added functionality in the form to cover for this, but I still want to try and stop users from adding more than one record per calendar day. Any idea how I would do that? I've already got the User + Date field, but how do I say in a data rule that a new record can't be created when one already exists with that value?
------------------------------
Daniel Johnson
------------------------------