4 Replies Latest reply on Feb 13, 2017 1:30 AM by newbiedonut

    Prompt when a record is completed?

    newbiedonut

      Basically I have 5 layouts with one or several tables in each layout. For every record, each layout will be filled in at a different time, depends on the record's progress (some could take up to 6 months before the next layout is filled).  In each table, I created Modified Entry User and Entry Timestamp to track who and when filled the 'forms'. A record is only considered 'completed' when all these Modified Entry User and Entry Timestamp fields are filled. Currently, I have to scroll through all the records to check which record is completed and it's not exactly feasible as the record numbers are increasing and it's getting more difficult to track every records' progresses. A prompt to the 'admin' user every time a record is completed would be great but I am not sure how to do that. Are there any suggestions for this? Thanks!!