Lock other fields when certain option in a Dropdown Option is selected
My Form has
Dropdown Field Options 1. Debit Order 2. Cash
Other Fields: Account Number; Bank; Debit Date
Is there a method to Lock the other fields in the form when form user select the Cash Option.
The form users always ask why they need to enter Account Numbers when they have selected Cash Option. I want the Debit Order fields to be Blocked or Greyed Out or Disabled when Cash option is selected.
Current solution I have entered a note in the account number field for the user to enter 0000 if Cash option is selected. It's working but it would be nice if the cells are automatically disabled.
Comments
-
I hear conditional Forms are in the works. I vote for that.
As another possible workaround that we have for something similar, you could have 2 forms, based on the FOP. With that, you could have the appropriate required fields for each. Again, perhaps not ideal, but another option.
-
Hi,
I agree! The best option at the moment would probably be to have two different forms.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This content has been removed.
-
This content has been removed.
-
Ok.
Unfortunately, it's not possible at the moment to use any formulas in forms or to use any conditions, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I'll get back to the post if I think of some other way to solve it.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This content has been removed.
-
Happy to help!
Would it work/be better if you had an initial form with two links to the different forms?
Make sense?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives