3
I have a dropdown on a submission app that has items from an excel table. When a user submits an entry, I want the default field in the dropdown to increment to the next one.
The table is:
00:00 - 01:00
01:00 - 02:00
and so on for 24 hours.
when the user submits data for 00:00 - 01:00, the dropdown will increment to 01:00-02:00.
Is this possible?
I am not sure what your Table looks like so I will give my own example.
Assume we had a Table created from a collection like this. (You can expand it to 24 hours but I didn't want to type that much).
Share
Report
All responses (
Answers (
ClearCollect(
myTimePeriods,
{ID: 1, TimePeriod: "00:00 - 01:00"},
{ID: 2, TimePeriod: "01:00 - 02:00"},
{ID: 3, TimePeriod: "02:00 - 03:00"},
{ID: 4, TimePeriod: "03:00 - 04:00"}
)
We start by putting this code in the OnVisible property of the screen
Set(currentTimePeriod, 1);
Then we put this code in the Dropdown for the following properties. Make sure it is a Dropdown and not a ComboBox.
Items: myTimePeriods.TimePeriod
Default: LookUp(myTimePeriods, ID = currentTimePeriod)
Finally, put this code in the OnSuccess property of your form to increment the next dropdown option.
If(currentTimePeriod = 24,
Set(currentTimePeriod, 1),
Set(currentTimePeriod, currentTimePeriod + 1)
);
Reset(your_dropdown_name);
Now your dropdown will increment to the next option.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
