Data Table - Make lookup mode trigger on new key value.

earl_bennett

It's 2024 and returning data from a lookup query shouldn't take 4 to 5 minutes. It's my understanding that DataTable refreshes every 5 minutes by design. Please change this when in Lookup Mode. When a user enters a key value, that action should trigger the refresh/lookup.

It's ridiculous for a user to have to wait up to 5 minutes.
* Change lookup mode to trigger on sheet value entry/change
* Open the data table for direct access

scottreiter

I agree the lag in the lookup from DataTable makes the value of DataTable low. In my case, I have an approval automation that runs once a row is submitted to a sheet. In order for the approver to make a decision, they need the content that would be stored in DataTable and synced with columns in my sheet. Since the DataTable takes up to 5 mins to sync and the workflow sends the approval request almost immediately upon the row being added ..the fields in the sheet are blank. If the approver opens the approval request within the first 5 mins, the content is not there to make an approval decision. They would have to wait for DataTable to catchup and populate those fields. There shouldn't be bottlenecks like this that slows down an approvers workflow where they have to wait for the system to catch up. Lookup fields from DataTable should populate immediately.