Need help for Menu item on Auto Action

Hi,

Here's what i want to do.

I have un first Database Table with a date and a link ; for exemple :
| ---- date ---- | ---    link                            - |
| 02-02-2022 | www.mysite-aa.com |
| 04-04-2022 | www.mysite-bb.com |
| 06-06-2022 | www.mysite-cc.com |

A second table with user_id, and a code wich is 0 or 1 :
| -- user_id --  |  -- code -- |
|        1           |       0         |
|        2           |       1         |
|        3           |       0         |

And a Menu Item, let's call it "OutsideLink"

If the today's date exists in the first table and if the code for the logged user_id is 1 in the second table
then when the user clicks on "OutsideLink", a new tab open on  www.mysite corresponding to the today's date.

if the today's date dosen't exist in the first table or if the code for the logged user_id is 0 in the second table
then when the user clicks on "OutsideLink", a message (or an article with a message) that indicate an error
An alternative would be to hide the link  "OutsideLink" in this case.

I guess this could be done with a  Menu  item on an Auto Action, type SQL request fired on UserLogin.
But i can't figure out how i can do

Thanks for your help
Regards

I can only help you in regards to the initial setup, but I cannot help you code your solution. This will require SQL and likely PHP experience. Below would be the initial setup.

Global
Triggers: None
Type: Query
User: Self
Access: Everybody
Action
Query: Output
Display: Redirect
URL:
The above for example should redirect to the link if the query returns one otherwise redirect to home page. Next you'd create a Joomla menu item with a menu type of Community Builder > Plugin then select CB Auto Actions for Plugin and supply your auto actions id to the Actions parameter to have it be a menu item.

Note this is just an example and is not tested, but should get you started. I cannot help you code a solution beyond this simple example without a Business Membership , sorry.