You’re offline. This is a read only version of the page.
Announcements
390
Hey team,
I created a log table on my form "Associate Form" which store the records of the associate which are created through a batch job. If the associate is created successfully the Log table stores the details as "Associate Created successfully" and if there is any error it stores the system generated exception in the log table. Now this data is stored in log table through the same batch job which creates the associates. I have written the insert method of log table in the same batch job. In the action pane of my main form [Associate form] there is a action menu item which when clicked for a particular associate shows the logs for that associate. But now I have a problem, the information of associates created before writing the log insert method have no information in the Log table which I don't want. I want that when the previous entries are clicked either it shows the same way as above or a message as "No logs available" for that associate. How can I achieve this?
My log Table:
The info when an associate is selected and logs are viewed for that associate:
Information of previous associate [before log insert method]
Hi skd,
Great! Please mark the helpful answer as verified.
That's why it is trying to insert a new record when none exist. You can set the "Insert if empty" property to "No" so that it displays no record when nothing exists in the logs.
Based on your requirement, I think you have 3 options -
1. Show no records when the log form is opened when none exist.
2. Disable the "Log" button from the associates form when no logs exist for the particular record.
2. Run a job to create log entries for all successful records for which no logs exist.
You can decide on which suits your requirements best.
Hi skd,
On the form showing the log for the associates, do you have AllowCreate, AllowDelete and AllowEdit set to "No" for the data source?
#1
André Arnaud de Cal...
294,118
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
