I’ve created an application that will house our daily checklist, currently done on paper.
I have one big form for all the check with controlled sections on each one.
In the main view, the documents are displayed sorted by date in column 1.
What I’d like to do is perform a check when somebody hits the “new checklist” button.
I want to do a lookup that checks if a document already exist for that day and displays a “please edit the existing document” message if it does.
I’m having problems extracting the dates from the view for use in the formula within the compose. I’m using the @DBColumn function but it appears to be bringing back no results.
datelist:=@DbColumn(“”:“ReCache”;server:database;“bydate”;1)
Any ideas?