HI, I did a workflow to generate a quote using a google sheet that is sent directly to the customerโs email, but it happens that the fields on my sheet are not filled in, leaving them empty,
Solved! Go to Solution.
Okayโฆ the reason is what I thought. With your existing structure itโs not sending correct data from child table when you add new records because the parent record is saved before child records. Thatโs why itโs working corretly when you update records. You need to adjust your flow a little. Check this sample app โParent Workflowโ from hereโฆ https://www.appsheet.com/portfolio/531778
Are you reading data for these tables from related child records?
Hi Aleksi. What you mean? i try to explain:I compile the table of the estimate, the workflow prepares only the pdf but without content as in the first photo, so I have to reopen the same content, modify some data and at this point the workflow works correctly filling in all the fields as in the second photo
For me it sounds that you are reading data from related table (child records with the Ref field) for your template. Are you able to take a prinscreen from your template?
yes
The template is correct, it works but in a second time, the fist it remain uncompletedโฆas if I had not entered any data
Okayโฆ the reason is what I thought. With your existing structure itโs not sending correct data from child table when you add new records because the parent record is saved before child records. Thatโs why itโs working corretly when you update records. You need to adjust your flow a little. Check this sample app โParent Workflowโ from hereโฆ https://www.appsheet.com/portfolio/531778
than iโve to insert an action to add for eg the dateโฆis it correct?
thanx, now it works.
Youโre welcome
Iโve 2 question: can i do workflow with the action to change data and send e-mail?
2nd: i tried to insert a row in the table of my google sheet, but not the workflow doesnโt work.
BEFORE (WORKFLOW WORKS)
AFTER MODIFY (WORKFLOW DOESNโT WORK)
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |