Leaderboard

Hey Ocean, Great question. Check out our documentation on resetting the audit log here. If you're interested, here's the explanation: The audit log keeps a record of past changes to allow MirrorSync to merge conflicts, however it can get huge, up to a maximum of 1 TB. The solution is to use the configuration client to reset it. Log in, right click the configuration, mouse over Reset SyncData and click "Only AuditLog". Despite its size, the audit log isn't critical to MirrorSync's function; you won't need to replace your spoke or even expect much longer syncs after you wipe it out. You may not even notice the downside: that MirrorSync won't be able to merge some record changes after you delete the audit log. However, after resetting this problem will quickly resolve itself; after a few days of normal use it'll be as though nothing happened, and you'll have your ~80GB of space back. Hope that clears things up! - Adam

Testing

The term you're thinking of might be, not magic key, but 'multi-key.' It can indeed be quite useful, not only for going to related records, but displaying those records in a portal.

Here's a basic demo of what I meant: PendingElsewhere.fmp12

Actually, there is. The table you call the Track table is a join table. The table you are missing is the real Tracks table, where each track would be a unique record. I believe it can - at least this part: You need to construct a self-join of the (not) Track table as: Track::Track# = Track2::Track# AND Track::Job# ≠ Track2::Job# This allows each track belonging to the current job to look at its "siblings" that belong to other jobs and ask: are any of you pending? The exact method to do that depends on what type of field is Pending and how it is populated (ideally, it would be a Number field with the value of 1 if true, 0 or empty for false). Scripting is also a possibility, and it doesn't limit you to "some sort of pop-up message". You can populate a global variable or a field when loading a job record. But I am not sure you need to do this, at least not for the highlighting part (I haven't really thought about the 2nd portal option).

https://community.claris.com/en/s/question/0D5Vy000006IQnpKAG/free-prompt-engineering-training-resources https://www.cloudskillsboost.google/paths/118 https://microsoft.github.io/AI-For-Beginners/ https://www.edx.org/learn/artificial-intelligence/harvard-university-cs50-s-introduction-to-artificial-intelligence-with-python https://www.coursera.org/learn/prompt-engineering https://www.deeplearning.ai/short-courses/chatgpt-prompt-engineering-for-developers/ https://www.deeplearning.ai/short-courses/llmops/ https://www.coursera.org/learn/big-data-ai-ethics https://www.edx.org/learn/computer-programming/edx-ai-applications-and-prompt-engineering

Does the attached test work for you? InsertFromRedirectURL.fmp12