Skip to main content
Question

I need a searchable text log field?

  • Dec 5, 2018 2:31 AM UTC
  • 0 replies
  • 72 views

I am needing a way to log changes to a PN field, While also making sure that it is usable in current formulas and also possibly searchable for future reference?

At the moment I have a text field [PN] and a Multi-text, edit-logged field [PN Log], along with a form rule that says "When the record is saved and [PN] is changed, change the field [PN Log] to the value in the field [PN].

This seems to work well for logging, but I am really needing something searchable. Any advice, tricks?

Thanks.
This topic has been closed for replies.

  • Qrew Cadet
  • Dec 5, 2018 2:36 AM UTC
Make a table just for logging for all tables and all future logs you need. Used the API_AddRecord. With adding a new record to your log table you can send any data over you want to log, different data from diff tables, and make a status field in your new log table so you can type the status (which tables the log is getting sent from). This will be searchable in anyway you want with any of the data you send to this new awesome table.

@ david....  just to offer a different solution .. are you looking for a way to include that field on searches using the filter box at the top of reports, but not wanting to clutter up the table report with the ugly log field?