Prefill Form with a Date Column
Hey Smartsheets Community!
I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would like it to remove that date option from the next person who fills out the form.
Currently the column is manually filled with the approved dates and the column has the property of "Dropdown (Single Select)". Dependencies are turned off as we don't have the need for a time window.
If a user selects one of the options, we want to remove that option from be selected again.
User1 opens the form to apply and is presented with the dates "8/10/20", "8/17/20", "3/17/21", and "8/17/22". User1 selects date "8/10/20" and finishes the rest of the form. The form submits and we can make an actionable item off of the line in smartsheets
User2 opens the same form after User1 has submitted their information. User2 is presented with all possible dates minus the date that User1 has selected - ie: "8/17/20", "3/17/21", and "8/17/22".
Aside from manually updating the column each time, is there a way to automate this process inside of Smartsheets?
Bonus Q: Can we make a drop down selection when the column property is set to "date"?