Force requery of Excel-linked Drop Down?

Forms
1

Hi, in public web forms, we would like to pull new data from an Excel-linked Drop Down field each time the browser page is refreshed. We have currently set the cache timeout to very short durations (like 10 or 20 seconds), but sometimes it does not seem to pull new data from the spreadsheet.

Is there a way to deterministically force a refresh from code, so that we are certain we are working with the latest information available?

Thank you in advance.

2

Hi @chs-web,

Please try fd.field('Dropdown').widget.dataSource.read();
Let me know if it helps.

3

Thank you for the suggestion, Ilia. I will probably need a couple of days to be able to work on this, but I will try it and report back here.

Best.

1 Like