External LED showing status

🤝 Discussion
1

Hi,
has anyone attempted to control some sort of an external LED depending on the result of a sql query for example ? The objectif is for example if I have one task that is still under "not completed" then light up red but if all task are "completed" then light green.

2

Hi, I'd suggest a basic way to do it:

  1. Run your SQL query in Retool to check the task status.
    For example:
    SELECT COUNT(*) as incomplete FROM tasks WHERE status != 'completed';

  2. Based on the result, send a command to your external LED controller.
    This depends on what you're using to control the LED (e.g. Raspberry Pi, Arduino, or an API).
    You can use a REST API request or a Retool workflow to send the signal.

  3. Example logic:
    If incomplete > 0, send command to turn on red LED.
    If incomplete = 0, send command to turn on green LED.

You’d just need a way to connect Retool to your device (like via an HTTP request, serial server, or MQTT broker, depending on your setup)

3

Thanks for you answer. My question was not for the Retool part that part I can handle it. I was more asking if anyone had any experience with any HTTP or easy to work with LED. I found something I think it is now on the way to my office. Kind regards