I can't start a related table

[ReyRSL12]

I am working on a bot that gives me all the records related to the company that was created, for example a new visit, a follow-up call, a follow-up visit or closing sale. The problem I have is that in the Company (Empresa) table there is the Related Records (Related Registros) table, but when I start the command in my format nothing appears.

Here is my code:

Here is what I get:

Here's the relationship between tables: 

The related table: 

And what I expect to get: 

What am I doing wrong?

[rmsmeltz]

Based on the provided screenshots and information, it appears that the issue is with the bot's command and its relationship to the related records table. Here are some possible solutions:

1. Ensure that the bot command is properly configured to retrieve the related records. According to the Salesforce article on record-triggered flows, you can trigger a flow before or after the record is saved to the database, and updating the record before the save gives you the ability to update the record that triggered the process prior to them being saved. Make sure that your bot command is set up to trigger the flow and retrieve the related records.

2. Consider using an AI chatbot platform that supports retrieving related records. According to the Tidio blog post on AI chatbots, Tidio, Drift, and Ada are some of the best AI chatbots for business. Check to see if any of these platforms have the capability to retrieve related records and integrate with your Salesforce database.

3. Check the configuration of your survey data maps and custom report type to ensure that they are properly set up to view the related record details. You can create survey data maps to create or update records, add topics to survey records, gather feedback at the end of a chat session on a digital engagement, define default settings, show survey pages based on merge fields, and add the survey invitations and responses related list to object. Make sure that these settings are properly configured to view the related records in your bot command.

[Joseph_Seddik]

Please show the columns of the table on which you are running the template.

[ReyRSL12]

In the same order they are, report ID, report type, elaboration date, start date and end date, these last two dates to filter, the filter is a reference to the table of my users, file is where the report is saved and counter is the column I use so the bot knows when to triggers the action

[Joseph_Seddik]

Please read the reference for SELECT() function and also this post. 

Your first SELECT() expression should rather include: [Asesor] = [_ThisRow].[Filtro]
and [Fecha] >= [_ThisRow].[Fecha inicial]

Your second SELECT() should rather include: [Email] = [_ThisRow-1].[Asesor]

[ReyRSL12]

I tried those options and it didn't work