Lassi Viitakoski
10/03/2024, 11:30 AMCeligo AI
10/03/2024, 11:30 AMAI generated answer (using internal Slack threads):Based on the conversations, it seems that it is not directly possible to write a search formula that checks if a field is available through a saved search. However, there are workarounds that can be used to achieve similar results. In the first conversation, a user suggests using a custom field that is updated based on the results of a saved search. This custom field can then be used in the criteria of a second search. However, it is noted that this might not work as expected if the custom field is set to not store its value. In the second conversation, a user asks if it is possible to use a
Formula (Text)
field in the Available Filter of a saved search. The response suggests setting up the Formula (Text)
field as a criteria and provides a link to a guide on how to use formula values as available filters in NetSuite saved searches.
In the third conversation, a user is trying to find a saved search based on the field name, but is having trouble when the field name is used in a formula. The responses suggest including the formula in the results of the search and either naming the column the field they are looking for and detecting it in code, or parsing out the formula.
In conclusion, while it may not be directly possible to write a search formula that checks if a field is available through a saved search, there are ways to manipulate fields and formulas to achieve similar results. However, these methods may require additional setup and may not work in all scenarios.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
10/03/2024, 11:30 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.861851156
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.858064353
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.853543639
Celigo AI
10/03/2024, 11:30 AM