I am new to all this low code/no code world and I can not figure out how to get a record from a supabase table to display in weweb. I have the workflow for select from supabase and have the record filtered to down to the one I need and is currently displaying in the logs but how do i get that record to display back to a user in weweb?
hi @kdavis307
If you are getting the data from the select action, you’ll need to save it in a variable with a “Change a variable value” action in the workflow after the fetch. That way you can bind texts on your layout to values in the variable.
Does that make sense?
Hi Joyce,
Thanks for the incredibly fast response. I have attached a picture of where I am at with as I believe what you explained is what I’ve already done but i’m clearly missing something as the “monthly premium” amount I can not get to actually display in the Long answer - value. Thank you for your help.
-Keith
Awesome! It looks like you’re off to a great start
Can you show me where you are trying to display it on the page layout? You should be able to bind the value of the variable to a text element for example like we did here:
I have just built a page trying and get it working but I follow everything in your image until step 4 then I don’t have that drop down field under the long answer?
Ah ok. Your Long answer
variable is a text variable but you are trying to update it with an object. If you change the type of the variable to object, it should work ok.
Sorry I missed that in the first screenshot you shared
PS – I will create a bug ticket internally because the logs are misleading: the variable cannot be successfully updated because it’s a different data type
Ok, so where do I go to change the variable type to object? or do I need to write a formula to change it?
I created an object variable called test and bound that to a text box but I still can’t seem to get the data to display in the text box.
Hi @kdavis307
You can’t change the Long answer - value type.
You can try with : Action.result and then put “.monthly_premium” so you will have Action.result.monthly_premium
Or with a formula getKeyValue(Action.result,“monthly_premium”
The other way is that in the workflow, instead change the variable value Long answer - value, you change the “test” value (which is an object) with Action.result and then you can bind the property “monthly_premium” (which you can display with the arrow just on the left of the “test”) to your long text
Thank you! That worked perfectly, I knew it had to be something small I was missing.