Notifications
Announcements
No record found.
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,
On the form showing the log for the associates, do you have AllowCreate, AllowDelete and AllowEdit set to "No" for the data source?
No, I have kept it to "yes" for now.
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.
Hey Gunjan Bhattacharyya ,
Thank you so much your suggestions helped a lot.
Great! Please mark the helpful answer as verified.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
