One row url link

AppSheet AppSheet Q&A
1

Hi There

Is it possible to make a link in the HTML email text body that when we click it goes directly to that ONE row information instead of we LINKVIEW the how page. Example below

The BOT send email with the link

desmond_lee_0-1738744762021.png
desmond_lee_0-1738744762021.png309Ă—557 27.5 KB

If I use this <<[EMPLOYEE ID]>>

desmond_lee_1-1738744971888.png
desmond_lee_1-1738744971888.png968Ă—562 65.6 KB

But I want it be a link goes direct to that employee. Like this. And I notice that if you copy the top url link and paste that to a new tab it exactly that employee link. Is possible to get that link into the email body?

desmond_lee_2-1738745056467.png
desmond_lee_2-1738745056467.png1049Ă—717 194 KB

2

LINKTOROW()

1 Like
3

Hi Steve

I finally got it. Thank you so much for the tips. When an email is receive click the name as below

desmond_lee_0-1739342411155.png
desmond_lee_0-1739342411155.png562Ă—562 83.7 KB

After you click that link you will take you directly to that row of the employee info. See below. You can use a virtual column or a physical column to create this link. I tested both they all works well

desmond_lee_1-1739342483619.png
desmond_lee_1-1739342483619.png956Ă—444 89.5 KB

Step To Create Row ID

Step 1: Open Your App in AppSheet

  1. Go to AppSheet and open your application.
  2. Navigate to the section where you want to generate a deep link (e.g., a detailed view of an employee record).

Step 2: Identify the URL Format
3. Click on a record to open its detailed view.
4. Look at the browser URL—it will typically follow this structure:

------https://www.appsheet.com/start/{APP_ID}#control={VIEW_NAME}&row={RECORD_ID}------

  • {APP_ID} → Unique identifier for your AppSheet app.
  • {VIEW_NAME} → The name of the view you want to link to.
  • {RECORD_ID} → The unique key for the specific record (e.g., EMPLOYEE ID).

Step 3: Use This URL Format in a Formula
5. Use the following formula in AppSheet to create a dynamic deep link:

CONCATENATE(

“https://www.appsheet.com/start/@@@@@@@@-@@@@-4133-a911-128a78fe8aa9#control=Name Database_Detail&row=”,

[EMPLOYEE ID]

)

  • The first part of the URL is your AppSheet deep link structure.
  • [EMPLOYEE ID] dynamically appends the Employee ID to open the corresponding record.

Step 4: Find the Correct View Name
6. If “Name Database_Detail” isn’t working, follow these steps:
:check_mark: Go toAppSheet → UX → Views
:check_mark: Find the exactView Name where your details appear
:check_mark: Replace"Name Database_Detail" with the actual name from AppSheet

Step 5: Use an AppSheet Deep Link Instead (Optional)
7. Instead of using the full URL, you can use AppSheet’s built-in deep link function:

LINKTOROW([EMPLOYEE ID], “Name Database_Detail”)

Final Thoughts

:check_mark: Use the full URL approach if your app is web-based.
:check_mark: Use LINKTOROW() if the app is used inside AppSheet.

3 Likes
4

Excellent! Thanks for the detailed process!

5

Thanks. Quite a few days I think of how to do this

1 Like