I have a Excel table named, "Results".
In the table there is column named "Completed", with values "true" or "false".
I need to query that table to find out if Record #2 is true or false.
If true, I want to mark a checkbox with a check.
Shouldn't this work?:
Default = LookUp(Results,ID="2",Completed)
I can use that function to get the text to read "true" but I need a checkbox checked.
Nothing seems to work.
Go to Solution.
Change the default property to:
See if doing this would help.
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.