Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have an input box which requires users to key a word in into the field. Please see below:
Is there any way I can format the input field so that the user knows where to key the word or is there a better way to do this to make it more user friendly?
Thanks
Phil
You can't change the look of the input box much. You can add a caption title and add a help text.
What about a button that has an action which brings up an input field or something. Not sure how to do that though or even if it's possible?
phil
You can use a button to toggle a variable and use the variable to show/hide the input box. Create a variable vShow and give it an initial value of -1. Then add a Set Variable action to the button. Use vShow as variable name and =not $(vShow) as value. On the layout tab of the properties window of the input box enable the Conditional show option and use as expression =$(vShow). You can now show/hide the input box using the button. You can also make the text on the button depend on the variable: =if($(vShow), 'Hide input box', 'Show input box')
An alternatively might be to create a list of all possible (allowed) values which the user could chose per dropdown or scroll. Such listing could be applied manually or calculated. Have for this a look within the object-properties on the options in tab restrictions.
- Marcus
Hi Phil,
you can make your input box more user friendly by using below properties:
1)Remove caption of input box
2)remove = sign
3)in the general tab-> label ->Enter Space
4)Set input box constraint as shown in screen shot
5)Create one text box and place your input box over the text box
listed values will be the proposed values that user can select from the drop down list
hope this will help you..!!
You could add a text box next to the input box and provide the details for the same or
yes , you could use a button as well ...check this below thread
You can remove the label and equal sign, set a default value and some constraints to mimic a classic input box:
See attached sample QVW.
So close. It does the job, but the word which is keyed is a password (I use it as a variable to show / hide a sheet), so I don't want it to stay on the page.
How about a way to use this same scenario you suggested (above), but once you submit, the 'Enter Value Here' reverts back and the password is submitted to the variable seperately?
Is that possible? How to do it?
Phil
Perhaps you should use section access instead:
Sheets Security with Section Access
Section Access - Hide Sheet Level