MultiTech's Weekly AppSheet Show || 1/20/23 || #28
This week: ChatGPT in AppSheet
(Patreon Supporters) New OpenAi Script: Embeddings
(Patreon Supporters) New Utility Script: File Deleter
New Patreon Tiers: (www.Patreon.com/MultiTech)
($10) Wanderer = access to resources and tools
($50) Student = Answer Portal access
($100) Initiate = Priority support and exclusive voting rights
Deep Dive: ChatGPT in AppSheet
Building a continued conversation context system for OpenAi API endpoints in AppSheet
Get a copy of the app here: https://www.appsheet.com//templates/C...
----------------------------------------
HOW TO BUILD A CHATGPT-LIKE SYSTEM IN APPSHEET
----------------------------------------
1) Create data source
Threads
Start Date (dateTime)
Label (text)
ID (text/key)
Messages
Prompt (longtext)
Response (longtext)
Number (number)
Reformatting (longtext)
Total Tokens (number)
ID (text/key)
2) Initialize app, setup columns, customize views
3) Create ongoing history
Message Reformatting (in message)
Thread history (in thread)
4) Create Script using ChatGPT
Google Apps Script function to take a 'prompt' parameter and fetch OpenAI completions using the API endpoint https://api.openai.com/v1/completions, model text-davinci-003, maximum 500 tokens, returning the completion text (result.choices[0].text) and token usage (data.usage.total_tokens) in an array format (converting the token usage to a string).
Script returns an array
Your Response
The total tokens (as a string)
Script must be saved in an actual script file to work
5) Integrate and test continued conversation
Task 1) Get Response
Call your script, passing it your API key and the prompt
You'll want to provide a little instructions around your prompt, telling the Ai what you want it to do
Returns: Array(LongText)
Task 2) Record Response
Run a data action: set row values
Response: Index([Get Response].[Output], 1)
Total Tokens: NUMBER(Index([Get Response].[Output], 2))
---------------------------------------------------------------------------------------------------------
Table of Contents
---------------------------------------------------------------------------------------------------------
00:00:00 Intro
Updates & Releases |----------------------------------------------------------------------
Comments & Questions |-----------------------------------------------------------------------
Weekly Rundown |----------------------------------------------------------------------------
Deep-Dive |--------------------------------------------------------
YouTube Chat |--------------------------------------------------------
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
Join Matt from MultiTech Visions (and the occasional special guest) for updates about:
New Resources, Classes & Training Packages
Interviews with insiders
Video Comment Answers
Weekly Rundown (AppSheet News)
Submit your story here: https://forms.gle/8ujyirToLW1bT99h8
Patreon Questions
Patrons submit your questions here: / people-of-hear-66712743
LIVE Chat Answers
---------------------------------------------------------------------------------------------------------
/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Patreon
// / multitech
//
// Merch
// https://multitech-merch.creator-sprin...
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
https://www.MultiTechVisions.com
#CitizenDeveloper #AppSheet #chatgpt