Hey! I'm trying to use 2 input boxes to get a button to calculate and display my result in a third box. It has worked so far when I only have one input box, but when I add the other it says "Edit your formula so that it evaluates to a text or a number at this point in the formula".
The boxes are coded exactly the same so they are identical.
This is the formula for my button that displays the error message above:
If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K",
Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7)))
)
When I take out my second TextInput (1_7) it runs just fine, no idea what the issue could be so any advice would be super helpful!
Here is your issue. Add the .Text to the second Text box part. TextInput1_7.text.
If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K",
Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7.Text)))
)
Omg thank you! don't know how i missed that!!
For troubleshooting purposes, just work on the math function. Once you have that working then add in the If portion with one at a time. I am not sure that your issue is the math. Can you provide a screenshot of that error?
I tried your formula and it works fine with no errors.
If(Dropdown1_6.Selected.Value="B" And Dropdown1_15.Selected.Value="K",
Set(varResult, Value(TextInput1_6.Text)*2/(8*Value(TextInput1_7.Text)))
)
A ".Text" was missing there
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Buy me a coffee!
Check my User Group (pt-PT)!
Last Post on Community
My website!
MS.Ragavendar
20
BCBuizer
10
Super User 2025 Season 1
LC-26081402-0
10