Best Of
Re: Working with Dates
Hi @Walter,
In addition to what @Anastasia Pesyakova mentioned, you can also use Board NEXEL functions to extract those values directly in your report layout:
To extract those values, you would use Year(date field), Month(date field), Day(date field). Make sure you set these as text algorithms so the formatting doesn't have any decimals.
It would something like this:
Hope that helps.
Regards,
Hamza
Re: Working with Dates
Hi Walter,
You can achieve this by using ETL functionality of the data reader. You can find some info here:
Try using string formulas, LEFT, MID, RIGHT. e.g. B is your source column, so RIGHT(B,4) will return 2024 in your example.
Hope this helps,
Anastasia
Introducing Scout: A Helpful Guide to Fast Answers
We’re excited to welcome Scout to the Board Community! Think of Scout as your helpful guide, always on the lookout to fetch the best answers to your questions. Powered by our Community AI assistant, Scout delivers suggested answers to forum posts within minutes, helping you find solutions faster and keeping the conversation moving.
What can you expect?
When you post a new question to a Community forum, Scout will scan all existing human-generated Community content to search for answers based on question keywords and will provide up to three suggested answers in reply.
Here's what you'll see in just minutes:
Once the Suggested Answers have been generated, you have a couple of options.
- If the AI assistant answered your question, select 'Accept Answer' or select the 'X' to remove an answer that's not appropriate. Please keep in mind that each suggested answer includes a link that you can click to review the source material. It is always recommended to verify the source before accepting an answer.
- Alternatively, you can take no immediate action and wait to see if another user provides a better answer.
Accepting an answer makes the answer available for everyone to see:
*Please note: This feature is turned off by default for each Community member, and there is no obligation to use it. You're in control!
Turn on the AI assistant directly from your Profile > Account & Privacy Settings page:
- In the Community Preferences section at the bottom of the page, check or uncheck the Suggest Scout Answers on my Q&A Posts box to set your personal preference.
It's as easy as that! Questions? Let us know in the comments or reach out to community@board.com. We're here to help!
Re: Missing Ctrl+F functionality with in the Dataview.
Thanks Hamza for the clarification.
just to clarify, user knows the use of inherent search feature. The problem they see is that the search shows all members which has the search text and doesn't follow the parent child relationship. The feature actually filters the search text rather than highlighting. It creates confusion with the user to find out the exact member they are looking at when they actually want to search with the parent child relationship.
So it would be ideal to highlight the searched text rather than filtering it. Hope it clears the thought process.
