Some time data not updated, I have to refresh manually

Options
Shubham
Shubham ✭✭✭✭
edited 04/12/23 in Add Ons and Integrations

I’m using a Smartsheet form to process bulk orders, I’m using an Excel template to fill in the bulk order details in the bulk order sheet and then using a data shuttle to transfer the information to the order summary sheet. 

I’m experiencing issues with the order numbers not always appearing in the order summary sheet.

Once bulk order form submits then excel file upload in bulk order sheet and here I have one column “Order number”, here order number generated sequentially. For example, order number is 1001, and in the excel template have 5 orders.

In Order summary sheet – here I have one column “Order number”, in this column I am getting reference from “bulk order” sheet and order number is generating like, order number is 1001 into the bulk order sheet and 5 order in the excel template, so here order number is generating like 1001-1, 1001-2, 1001-3, 1001-4 and 1001-5.

It is working properly but sometimes I have to manually refresh the bulk order sheet to get the order numbers to appear in the order summary sheet. What could be causing this issue and how can I resolve it?

Note: Time zone of sheet owner and my time zone is different. when sheet owner’s time zone is US time, at that time my time is IST.

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Shubham

    You can check the Data Shuttle logs to see the frequency of updates. I would note that what you're describing sounds expected: the data is coming across properly, but it can sometimes take a bit of time to populate. Data Shuttle using the API to copy and add data. Depending on the number of rows & requests, it may take time to process.

    Cheers,

    Genevieve