1. Sign up for free account on ChatGPT.com using your personal email

2. Sign up for free account on Airtable.com using your personal email

3. Create 3 tables in Airtable using this prompt


Please create 3 Tables:
1. Food
2. Meals
3. Days

I'm listing each of the 3 Tables below with the Fields that I would like each Table to have,
with settings for each column indented as bullets under the column name.

The first Field listed underneath each Table is the Primary Field for that Table.

# Food
* Name
	* Type=Single line text
* Serving Size
	* Type=Single line text
* Calories
	* Type=Number
	* Decimal places=1
* Carbs (g)
	* Type=Number
	* Decimal places=1
* Fat (g)
	* Type=Number
	* Decimal places=1
* Protein (g)
	* Type=Number
	* Decimal places=1
* Alcohol (ml)
	* Type=Number
	* Decimal places=1
* Last Modified
	* Type=Last modified time
	* Fields=All editable fields
	* Formatting -> Include time=Checked

# Meals
* Name
	* Type=Formula
	* Formula={Food} & " x" & {Qty}
* When
	* Type=Date
	* Include time=Checked
	* Time format=12 hour
* Date
	* Type=Link to another record
	* Existing tables=Days
* Food
	* Type=Link to another record
	* Existing tables=Food
* Qty
	* Type=Number
	* Decimal places=1
	* Show thousands separator=Checked
* Calories (from Food)
	* Type=Lookup
	* Select lookup source=Food
	* field you want to look up=Calories
* Carbs (g) (from Food)
	* Type=Lookup
	* Select lookup source=Food
	* field you want to look up=Carbs (g)
* Fat (g) (from Food)
	* Type=Lookup
	* Select lookup source=Food
	* field you want to look up=Fat (g)
* Protein (g) (from Food)
	* Type=Lookup
	* Select lookup source=Food
	* field you want to look up=Protein (g)
* Alcohol (ml) (from Food)
	* Type=Lookup
	* Select lookup source=Food
	* field you want to look up=Alcohol (ml)
* Calories
	* Type=Formula
	* Formula=Qty * {Calories (from Food)}
* Carbs (g)
	* Type=Formula
	* Formula=Qty * {Carbs (g) (from Food)}
* Fat (g)
	* Type=Formula
	* Formula=Qty * {Fat (g) (from Food)}
* Protein (g)
	* Type=Formula
	* Formula=Qty * {Protein (g) (from Food)}
* Alcohol (drinks)
	* Type=Formula
	* Formula=Qty * {Alcohol (ml) (from Food)} / 17.75

# Days
* Date
	* Type=Date
	* Formatting -> Include time=Unchecked
* Calories
	* Type=Rollup
	* Select rollup source=Meals
	* field you want to roll up=Calories
	* Aggregation formula which rolls up the values in each linked record=SUM(values)
* Alcohol (drinks)
	* Type=Rollup
	* Select rollup source=Meals
	* field you want to roll up=Alcohol (drinks)
	* Aggregation formula which rolls up the values in each linked record=SUM(values)

4. Add an Automation to add new Days records each night


5. In ChatGPT, install the Airtable plugin

6. Create a new Project and then edit the Project settings

7. Populate the Project Instructions with the instructions below
Replace the values on these 2 lines with your data:
– Airtable Base: `Gloria`
– Base ID: `appUNznSJ5K2WhpvY`


- I will send a message where the first line is the exact value that
  should be added to the `Name` field in the `Food` table.
- Any additional lines contain clarifying details about the food item,
  serving size, preparation, nutrition, etc.
- Always use the entire first line exactly as written when populating the `Name` field.
  Do not shorten, normalize, or rewrite it unless I explicitly ask you to.
- The first line will often use this format:
  `Restaurant name - Food item name`
- The only change that you should make to the name is to
  capitalize the first letter of every word like this:
  `Restaurant Name - Food Item Name`
- The only words that should not be capitalized are filler words like
  `a`, `the`, `and`, `or`, etc.
- When interacting with Airtable, always use:
	- Airtable Base: `Gloria`
	- Base ID: `appUNznSJ5K2WhpvY`
- Only INSERT new records. Never UPDATE or DELETE records.
- Do not ask for confirmation before inserting a record into the `Food` table.
- For every request to add a record to the `Food` table,
  follow this three-step Airtable workflow:
	1. Read the Gloria base schema or the `Food` table schema first.
	   This initializes the Airtable connection and
	   confirms the current table and field IDs.
	2. Insert the new record into the `Food` table,
	   then report the values populated in every column.
- Use the information I provide, including any nutrition label, serving-size instruction,
  or preparation details, to determine the appropriate values for:
	- `Name`
	- `Serving Size`
	- `Calories`
	- `Carbs (g)`
	- `Fat (g)`
	- `Protein (g)`
	- `Alcohol (ml)`
- When exact nutrition information is visible in an image
  or provided in my message, use those values.
- When exact nutrition information is unavailable,
  make a reasonable nutrition estimate based on the portion,
  ingredients, restaurant, and comparable foods.
  Do not omit nutrition fields merely because the values must be estimated.
- Use the serving size I specify. When I say to use the entire bag,
  container, package, order, pizza, or similar unit, calculate and
  store nutrition for that entire amount rather than for one labeled serving.
- Use `0` for `Alcohol (ml)` when the food or drink contains no alcohol.
- After the insert succeeds, display a clear summary of every populated field,
  including fields intentionally left blank.
- Do not claim that the record was added unless the Airtable insert tool
  confirms that the record was created.
- If an Airtable call fails, retry the workflow after re-reading the base
  or table schema before reporting failure.

8. Go into the Project and try adding a food item

9. Verify that the record was added to the Food table in Airtable

10. Continue experimenting…