Not sure if this is a bug but not finding any previous details on it.
I have a custom form with a add row action, send email, and set columns action > clear columns.
I recently added the email action between the add row and clear columns but just noticed the columns are no longer clearing. Emails are being sent fine, just nothing happens after the send email action.
I added notifications after each step and i see the first add row notification, but nothing after. I can run the action from the action editor and see the blocks light up, but again, nothing after the email step.
So the emails are working and I like them but i need the form to get cleared for the next submission and to navigate back to the form page which was working before i added the email step.
I canât have the email at the end as then there is no data in the email.
Any idea why this is working like this? Is this a known issue/feature or is this a bug?
Has it been known for long? Any ETA on a solution?
Can you add some insight on how to clear before the page opens? I navigate to the page via a simple button with the navigate to tab action. I donât seem to be able to add any before steps to that navigation.
I donât see any âon page loadâ options for the page itself so not sure how to do this.
I appreciate your help. I am probably going to just use Outlook for now as that is a simple replace action step but i donât like that it uses âupdatesâ since this is only being used to get around a bug.
The set column action though is linked to the previous page base data which is a different table than the form data, so the set column action doesnât work from that button.
The previous page is a metrics page with some rollup data and serves as a dashboard. The link to the form is a button on it. I donât seem to be able to select which table to set column of when i hit the button, it only applies to the current page base table which isnât the form data.
Sorry that is kind of confusing to walk through so I can try to word that differently if that doesnât make sense.
If you create a âSingle Valueâ â âWhole Rowâ column, then you will be able to set column values in other tables through that single value column. The same is possible with a Single Relation.
Got it, great workaround. Ok I think this is functional so will run with this for now. Thank you for the help and great to know how to do that with the whole row columns.