LinkedIn
Twitter
Hi AppSheet Community!
I’ve built a lightweight rich-text editor that plugs right into any AppSheet field. No HTML hassles—just format your text, and hit Save to push it back to your AppSheet directly.
How it works
-
Open the editor URL in any browser tab.
-
Provide your AppSheet parameters in the query string (App ID, Table, Row ID, Column, Access Key, Key Column Name).
-
Edit with headings, lists, links, images—and click Save to update your record instantly.
Example URL
https://appsheet-chrome-rich-text-editor-production.up.railway.app/
?appId=a9fd722c-bb8d-4137-a55c-ahsdhshdasdaads
&tableName=Job
&rowId=959bb981
&columnName=Job+Description
&accessKey=V2-RpVem-s6Uoh-6XO63-aassdd-C6mUp-lGRPx-asddsa-FE53p
&keyColumnName=Job+ID
Copy, paste, and swap in your own values.
Build the link in AppSheet
Use this expression in a virtual column or action to generate the URL dynamically:
CONCATENATE(
"https://appsheet-chrome-rich-text-editor-production.up.railway.app/",
"?appId=", "YOUR_APP_ID",
"&tableName=", [Table Name],
"&rowId=", [KeyColumnName],
"&columnName=", ENCODEURL("Job Description"),
"&accessKey=", "YOUR_ACCESS_KEY",
"&keyColumnName=", ENCODEURL("Job ID")
)
Replace the bracketed fields and "YOUR_ACCESS_KEY" with your app’s details.
Parameters Explained
Below is what each query‐string parameter does:
-
appId
Your AppSheet Application ID (the GUID you see in your app URL or API settings). -
tableName
The exact name of the AppSheet table you’re editing (e.g.Job). -
rowId
The value of the record’s key column you want to edit (e.g.959bb981). -
columnName
The name of the column (field) in that table you’re editing (e.g.Job Description). -
accessKey
Your AppSheet API access key, found in Users > Integrations > Interface in the AppSheet editor. -
keyColumnName
The name of your table’s key column (the primary key field, often “ID” or similar).
Give it a spin and let me know how it fits into your workflow!
