can a transaction body non-storing formua field use a field from a joined record

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that a transaction body non-storing formula field cannot use a field from a joined record directly. The issue seems to be that non-stored fields are essentially "visual" references and cannot be used in saved searches or sourced directly from another record. One workaround suggested in the threads is to use a script to fill the field whenever a particular field changes. However, this might not be the most efficient solution if you're looking for a simpler approach. Another workaround is to use a saved search to populate the field. However, this approach has its own limitations and might not work as expected in all scenarios. In conclusion, while it's technically possible to use a field from a joined record in a non-storing formula field, it's not straightforward and might require additional steps or workarounds. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******