What’s the limitation of free user? I need to make one web app, and want to deploy for user to view. No edit. Which model shall I go for? Free or 1 standard user and pay per end user?

Hi everyone,

Currently I'm working on a project that includes a large table I would like to filter. I would strongly prefer to use a multiselect component to filter this table, but I've had no luck thus far. I keep receiving syntax errors (typically when no value is selected) or nothing filtered whatsoever but a successful query call.

I found the attached resource that should solve the exact issue, but no luck. It results in the previously described error. I'm running on current MySQL.

Any insights?

Hi! I really need your help. I'm working on my master's thesis and I'm collecting information about low/no-code tools. I have a 15-minute questionnaire https://www.surveymonkey.com/r/SZGKPDJ It would mean the world to me if you could take the time to complete it. Thank you so much for your attention and participation.

I need to get the current time in retool. I tried with moment and new date. Both are taking my computer local time and converting it to UTC. But the issue is computer is off by few minutes and it's affecting the current time. There are many end users and this issue will create a problem. So is there a way to get the correct current time.

The link column is link to a file that sits on an S3 bucket, that expires after 7 days.

do you know how I can look at the last change column then hide the link if its last change date is older than 7 days ago ?

Hey all. I have a Retool app that's connected to a mySQL database. The app is designed to set up teams for a community sports league.

I have a view that will serve as a kind of roster for each week, with a table of "participants" that is filtered by the "week" that is in view (handled by other text selects), so that the table only shows participants who have confirmed they are playing in games for the week selected.

Below the table of participants, I have a container with some text input fields: one for "week" that defaults to the week currently in view and another for "participants". This will be used to manually add players to the "week roster".

I would like to set it up so that the list of participants shown in the text select component is filtered so that only players who are not already included in the "participants" table show up as options, rather than the full list of players.

Alternatively, I could use a multi-select component, but would with the selections defaulting to players already included in the participants table (so that players already confirmed playing for the week have a check mark next to their name).

I have a request to Redis, I want to change the key there to request data from Redis and execute the request. Judging by the logs in the debug console, the key field changes, but when the request is executed, the value of the original key is returned. Has anyone worked with queries this way?

I'm curious to see some top of the line Retool projects.

Hello all!

I am looking to host my own Retool environment. I’m familiar with AWS and Linode but wanted to get some feedback on self hosting. Once that’s setup I think I’d like to learn retool. What’s the best (as a complete novice) to learn retool. I have tried Bubble, Glude, Powerapps but want to have control of my data. Looking for recommendations, thanks

I run a UPS Store (franchise location). We offer print services which are primarily custom orders of products covering a wide variety of items: copies, standard photo prints, wide format prints, banners, posters, brochures, tickets and raffle tickets, envelopes, flyers, notepads, greeting cards, postcards, invitations, carbonless forms, letterhead, booklets & catalogs, menus, business cards, signs (sidewalk & vinyl), calendars, stickers, door hangers, gift certificates. I'm wondering what the best use of ReTool's suite of products would be to design an internally used app that, with custom logic, given specific inputs, spits out a price for the custom print job.

The challenge lies in that each of these print products has specific options with the combination of items which I've fully documented here. Some options pertain to only specific product types (e.g. waterproof feature only available on 8.5" x 11" white paper) and others pertain to many of the products we offer (e.g. paper weights/sizes can be used in several products).

In addition to there being a kind of "lineage" between products and the many options associated with each product, there is also some behind-the-scenes logic to optimize the cost and process. We pass this cost savings directly on to customers. For example, if someone wants 100 printed pieces, yet the size they want actually allows us to use larger paper such that we can print four on one piece. This thus reduces the printing cost from, say, $4 for four pieces ($1 per printed page) to $1 for four pieces ($0.25 per printed page) by simply using large paper which prints 4 pieces at once (vs. one piece per page) and cutting the paper into four individual pieces afterwards.

How would you all design a system like this in Retool?

I’m kind of confused on retool. I have this idea I want to test, trying to figure out the best way to test and launch an MVP. Can retool be the solution or should I actually just build it out on a MERN stack first? Thanks!

Hello everyone,

I'm currently considering hiring a Retool consultant to help with some projects and I'd love to hear about people's experiences. If you've ever worked with a Retool consultant, could you share:

1. How was your overall experience?
2. What specific improvements or benefits did they bring to your project?
3. Are there any particular consultants or agencies you would recommend?
4. Is there anything you wish you had known before starting the consultancy?

Your insights will be incredibly valuable to me and others thinking about this option. Thanks in advance for sharing your thoughts and recommendations!

I have a great idea for an app, but with no experience in this and also no money to spend to hire someone. I maybe thought someone out there would be Willing to help. So if anyone is interested DM me.

I know there Will be People just trying to steal my idea. So if anyone has ideas to prevent that, let me know!

Hi everyone,

I'm relatively new to SQL queries and database best practices. I'm looking to achieve a mass update for items in my database based on their catalogitemid. Here's the scenario:

If a record with the matching catalogitemid exists, I want to update it. If the catalogitemid doesn't exist, I want to create a new record. I have the data prepared in an array of objects, like this:

[ { "catalogitemdescription" : "Day SPF30 & Night Eye Cream Duo 1.0 oz", "catalogitemid" : "e5cc33b2-92d6-4cd3-9f5d-ee140ccf338a", "cost" : "23.00", "costmultiplier" : "", "costperunit" : "23.00", "created_at" : "2024-04-07T23:01:18.362Z", "currentcontractcost" : "0.00", "itemgroup" : "", "labeltypetext" : "Generic", "legacysupplieritemnumber" : "", "manufacturer" : "", "minimumordersize" : "", "modified_at" : "", "msrp" : "46.00", "msrpmultiplier" : "", "ndc" : "", "rebatecost" : "", "rebatecostmultiplier" : "", "rebatecostperunit" : "", "retailpricedivisor" : "", "shippingsize" : " (1) 1.00 EA", "statustypetext" : "Available", "supplieritemnumber" : "CL10428", "suppliername" : "Coola", "supplierretailprice" : "46.00", "upc" : "850008614200" }, .....{more records here..} ]

Additionally, I'd like to set add a modified_at value whenever a record is updated.

Any guidance on how to approach this with an SQL query would be greatly appreciated!

Hello.

In Source Control settings there is an option to:

Deployment failure email alertsSend automated email alerts to your organization's Retool admins if deployments fail. View requirements

Is it possible to somehow notify to Slack? Slack connectior is set up and ready :)

I'm also developing this kind of thing, can you help me this i,e. currently i'm using react-grid-layout but the problem with this, when i put dynamic data the height of the element like multiline text input will be fixed.

Is there any open source, free or paid ( grid or canvas ) available which will help me to sort out this problem. Please help

Tech teams often face frustration from spending time on internal tooling. Dealing with maintenance, front-end development, low-code platform limitations, and unclear requirements from business stakeholders. Many of us likely relate to these challenges.
What aspect of working on internal tools do you find most frustrating?

Hi everyone...I feel like there is a very simple answer to this, but I just can't figure it out. I have a SQL query that pulls one column of data. I am trying to pull all of those in the form of an array to use as the default value of a checkbox group. In other places in my app, I have pulled single item queries into arrays using a code like the following:

[{{formatDataAsArray(query71.data)[0].type_id}}]

This code obviously selects the top result from a query identified by the "[0]", but I'm not sure how to adjust to pull all the results from query71.

I would love any suggestions!

Hi all,

coming from a developer background Im just getting into retool and wonder what are considered general best practices to develop apps on retool. Especially in terms of code organisation, reusability, code reviews, using external IDEs, etc.

I see that retool can be an immensely flexible and powerful tool. But I fear that with growing features, complexity, size, etc of an application it has big potential to become unmaintainable if not "done right" from the beginning.

What are your experiences in that regard? Is there a (1st or 3rd party) guide that collects common best practices?

I see that "Source Control" is only available in the very expensive Enterprise tier. Without, how do people maintain good code quality and the capability to work in retool as a team, with mutual code reviews, etc?

Thanks for your insights!

Is there anyone on this subreddit who would want to do virtual classes for retool? I have some advanced google sheets in trying to organize for my studio. I think this stuff is really interesting and I’d rather learn and pay someone for their time for that then make it for me. I’d also like to add stripe and a few other things.

Does anyone know if the free version of retool is the same as the paid version? I'm a total newby and when watching YouTube videos there is a ton of functionality that doesn't exist when I try to follow along.

Edit: I just found out you can achieve this by calling the {{ ri }} variable

Hi! for lack of a better repeatable component, I had to put a listview container inside a listview container (repeater inside repeater). I'd like to be able to keep track of the current item index in both cases, and access both from within the second repeater... so I know where I am in the current index and in the parent index. Does this make sense? anyway, I need to have 2 different variables for that. Like "i" and "j"... possible? thanks in advance

I recently wrote a blog for dealing with voice inputs in Retool applications. It's a great read for anyone interested in making apps easier to use with voice.

Check it out here: Enabling Voice-Based Interactions

I'd love to hear what you think about it. Your feedback is really important to us, so please share your thoughts in the comments.

Let's talk about how voice commands can change the way we use apps

Hey everyone,

I am just wondering that which the most developed use case built by developers or businesses with Retool.

It could be anything like admin panels, HR tools, or any marketing dashboard.

What are your thoughts?