I am puzzled on a situation I cant find a solution to.
I have a table for Rentals. On this table is the item, checked out by, checked out date, checked in by, and checked in date.
I have two form views for the table. Checked in_Form and Checked Out_Form.
The Checked Out_Form doesnt show any of the checked in fields and visa versa.
I have an action on an item that opens the Checked Out_Form and fills in item, checked out by, and checked out date. This works perfectly!
Here is the problem:
I have an action on my Rentals table to check in the item, which I cannot get to fill in the checked in by, or checked in date. I have individual actions to write the correct data to those fields and when I group them with an open form to edit, they do not populate. I cant do initial values on those fields because this is the second time the form will be opened. I cant do a deeplink like LINKTOFORM() because that opens a new form and writes data to a new row.
I do not want an action to simply write the data to the fields because if the item was checked in yesterday and I hit the action today, it will fill in todays date. I need to be able to open the Checked In_Form and have it pre-fill the checked in by, and checked in date.
Any ideas on how to accomplish this?