I have an app to enter sales that get forwarded to the office for processing. The data is stored in Google Sheets.
The format is one customer to many products per order. I was using behaviors to send an email but I thought automation would be a better way to go.
The automation populates the the email before the data in the child table has a chance to finish the sync.
So all the email shows is the customer info and none of the products in the order.
If I go back and change any of the sale information to trigger the bot, the email sends with all the customer and product information perfectly.
The โWait for condiionโ option in the automation causes to unpdredictable of a delay, the sale should be sent in to the office as soon as it is synced in the app.
Is there a way to get the bot to wait until the sync is completed on both tables before it sends the email?
Attn @prithpal @Dan_Bahir @praveen
Could you please share what your automation steps look like ?
What is the expression in your wait step ?
We are a small family nursery and are having trouble finding help. This is being tested by two of us to take the order in the display yard then send it on to the office to be entered into quickbooks.
I have our customer list and products uploaded into the app. We are using the app outside in our tree yard.
When the app starts it opens to the Orders screen,a dropdown is used to lookup the customer then select the โAdd Itemsโ which opens an โOrder Detailโ screen so each product can be entered
Once all the items are in, I set up a behavior button to send an email, but automation would make it easier when it is busy.
The Tables are setup as.
Customer, Product, Order, Order Details
The main table Is โOrdersโ with many products referenced to that order in the 'Order Details" table.
Is there a way to wait until the sync on the child table is finished then trigger the automation?
I tried the โWait for conditionโ but since it does not trigger until the next time a record is updated it is to unpredictable to use here.
Not sure if this is what you need. Iโm pretty new to apps so let me know if this isnโt what you ent.
Thanks for helping.
I believe @Dan_Bahir was asking if you can share the details of your wait step configuration. i.e a screen shot of the wait condition or paste the condition here.
The expression is, ISNOTBLANK(SELECT(Order Details[OrderDetail Id], ([Order ID] = [Order ID]), TRUE))
The expression does wait until there are records in the โOrder Detailโ table with the matching โOrder Idโ. but because it waits until a new record is created or updated the time frame for that to happen is unpredictable. It would be Ideal to send once the Sync completes the records in both tables or maybe a wait time of 30 seconds to 1 minute to continue with the rest of the automation.
I am having the same problem,
The e mail is sent before the child table is updated, how can I fix it?
thnak you
See Sending Email Only After Adding a Parent Record and All of Its Children here:
Thank you I will try with the statusโฆ
Steve Many Thanks it worked.
Iโd like to comment that in the Workflow help document: โSending Email Only After Adding a Parent Record and All of Its Childrenโ, also works with โadd and update onlyโ, and not only with "updates only"
Best
@Steve @Anyone finding this post.
Thanks for posting. I wanted to provide the new link to the help article that covers this as the link that was originally posted in this thread is no longer active.
Here's the new link: https://support.google.com/appsheet/answer/11541779?hl=en
it not work
Hi Team,
I am having the same problem, The Child table is not being updated until sync completes, and before that bot automatically runs and gives the wrong output,
I just wanted a sync event occurs before initialising the bot, but how to ?
Please Help... over "SYNC EVENT"
@User20 wrote:I have an app to enter sales that get forwarded to the office for processing. The data is stored in Google Sheets.
The format is one customer to many products per order. I was using behaviors to send an email but I thought automation would be a better way to go.
The automation populates the the email before the data in the child table has a chance to finish the sync.
So all the email shows is the customer info and none of the products in the order.
If I go back and change any of the sale information to trigger the bot, the email sends with all the customer and product information perfectly.
The โWait for condiionโ option in the automation causes to unpdredictable of a delay, the sale should be sent in to the office as soon as it is synced in the app.
Is there a way to get the bot to wait until the sync is completed on both tables before it sends the email?
Sync Event
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |