Help- LINKTOFORM - Video Explanation

Danny_Frank
Participant II

Hello Everyone,

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.

Watch the video here

Thank you,
Danny

Solved Solved
0 6 470
1 ACCEPTED SOLUTION

Hi Danny,

The second linktoform Expression looks correct, and should be populating the form appropriately.

Try these trouble shooting steps

  1. Make sure the first parameter โ€œdispatch emailโ€ is matching the name of your destination form view exactly.
  2. If youโ€™re using a โ€œsliceโ€ to power that form view, then make sure the columns you want to populate are in that slice. If theyโ€™re not in the slice, you canโ€™t send data to themโ€ฆ
  3. Double check your column schema for that table matches in both the sheet and AppSheet

My is on #2 being your issue

View solution in original post

6 REPLIES 6

Danny_Frank
Participant II

Found this video and altered the expression based on their recommendation.

LINKTOFORM(โ€œDispatch Emailโ€,โ€œTime Stampโ€,[Time Stamp],โ€œIntake IDโ€,[Intake ID],โ€œJob Nameโ€,[Job Name],โ€œFirst Dateโ€,[First Date],โ€œLast Dateโ€,[Last Date],โ€œStart Timeโ€,[Start Time],โ€œEnd Timeโ€,[End Time])

Still not working

Hi Danny,

The second linktoform Expression looks correct, and should be populating the form appropriately.

Try these trouble shooting steps

  1. Make sure the first parameter โ€œdispatch emailโ€ is matching the name of your destination form view exactly.
  2. If youโ€™re using a โ€œsliceโ€ to power that form view, then make sure the columns you want to populate are in that slice. If theyโ€™re not in the slice, you canโ€™t send data to themโ€ฆ
  3. Double check your column schema for that table matches in both the sheet and AppSheet

My is on #2 being your issue

Stefan,
Thank you! Looks like after changing the expression to what was found in the video, the culprit was #3.
When I changed the column type from ref to text it worked!

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?

Marc,
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.

Sounds to me like you were still activating the old action somehow, double check that?

Top Labels in this Space