May I kindly ask a question? When I click on a date tab in the calendar view, it redirects me to the Edit Screen, correct? I would like the Submit button to trigger a workflow that sets values in a Relate Column. However, it seems that the Submit button does not update the Relate Column as expected. I would like to understand why this is happening and how it can be resolved.
You mean a relation column?
A relation column does not contain actual values that can be changed.
However, if it is a single relation, then you can use it to set values in the related row.
If you can add a few screenshots - of the columns, and the workflow, that would be useful.
Thank you for your response. Here are some example tables and the workflow.
May I ask a follow-up question? When you mentioned âsingle relationâ, does that refer to the type of the column?
Yes, see below:
Can you show me how your âRelateâ column is configured please?
As I understand it, the Submit button executes the data update action first, and then proceeds with the steps in the workflow, correct?
Because even if I set the buttonâs action to âNoneâ, it still updates the data.
Is my understanding correct?
Yes, thatâs correct.
If you look in the workflow run log, you should be able to see more information about what is happening with the onSubmit action.
Your relation looks fine. Question: does the relation depend on data that is being updated with the edit form? If so, you may need a short wait condition at the start of your workflow.
Actually, my situation is a bit different. Iâve built a volunteer sign-up system, where each department has its own schedule and calendarâletâs call this Table A.
There is also a combined calendar (Table B) that aggregates the dates from all departments into one unified calendar view.
To connect Table A with Table B, I used a Template Column based on the booking date and the volunteerâs name. The Edit Form Iâm using is from Table A.
My goal is to update data in Table A and, at the same time, have the corresponding data in Table B updated as well.
To do this, I tried to make the Submit button trigger a workflow that updates the Relate Column in Table A, which is linked to Table B.
However, since the Submit button always updates Table A first, the Template Column changes right awayâcausing the relation to break or mismatchâbefore the workflow can act on Table B.
As a result, the workflow canât update the related row in Table B because the relation no longer matches.
Do you have any suggestions on how to solve this problem?
Is there anything I should adjust in the structure or the workflow?
Any recommendations would be greatly appreciated.