I am struggling with the use of the Linktoform expression presented in the click to send email app. Click to send Email
I have asked this question before; however, I am not sure I explained what I was trying to do well enough. So I decided to ask in a video to hopefully provide a better picture of what I am trying to do.
What exactly are you trying to do here? Send an email, or are you just using this as an example for using LINKTOVIEW expression?
The first argument for LINKTOVIEW is a view name, not a table name. You said that at the start, but it looks like you might have corrected yourself later.
The reason timestamp is populating into Job Name is because timestamp must be the key column of whatever table the button is on. [_THISROW] is an alias for the key column of your current table.
The way the example app works, is by creating a Ref link in the dispatch email table, referencing back to whichever row of the origin table that you clicked the button from. You create Ref links by populating the key column value of one table into a Ref type column of another table, thus why they show sending the [_THISROW] value through. From this one Ref, you can use dereference expressions to pull all the other column’s info, either in other columns of the dispatch table, or in the email template itself.
If you do want to create replicate columns in your target table, instead of using a single Ref link, they should NOT be Ref type columns as you mentioned. They should have column types matching the column types of the origin table.
This expression looks to have the correct syntax. Is the target view “Dispatch Email”? Does it produce an error, or how does it not work?
Thank you for your response. I will look through those links soon to view the content.
The purpose of the action button is ultimately to send an email. I have not developed that workflow yet as the app is not populating the proper data in the spreadsheet yet. I am not worried about getting the workflow to function properly.
The updated expression was returning the same data as the original one I used. The timestamp (key) was the only data being returned, and it was populating in the wrong column.