Guide / Bistodio PRO

Turn on the new interface in 2 steps

The new interface for the Bistodio PRO Recipe Cost Calculator works on computers, laptops, iPads and tablets. Follow the cards one by one.

0/3steps done
See FAQ Start step 1
What you’ll get

This is the new interface after you finish the 2 steps

Try it in the frame below. It is a demo, so nothing you enter is saved.

Required8 steps

1Update the version

Watch the step-by-step video first, then follow the steps below.

  1. Open your template file and click Extensions Apps Script
  2. Under Libraries, open your library’s settings
  3. In Version, choose the highest number
  4. Click Save
  5. Go back to Google Sheets and press F5 to refresh
  6. Click Bistodio Update version OK
  7. If Google asks for permission, click in this order: Advanced Go to Recipe Pro Continue Select all Continue
  8. Wait a moment. When a pop-up appears, the update is done

Can’t find the Bistodio menu? See FAQ 803

Required7 steps

2Open the Bistodio app from the menu

If the app opens right away, you can skip steps 2–6.

  1. Click Bistodio Open app
  2. If it does not open, click Close and do steps 3–6 (one time only)
  3. Click Extensions Apps Script
  4. Click + Script and name it AppBridge
  5. Copy the code from the AppBridge code document ↗ (choose EN or TH to match your template), paste it into the file, then click Save
  6. Go back to Google Sheets and press F5 to refresh
  7. Click Bistodio Open Bistodio app and start using the new interface
Recommended4 steps

Make your file faster

Turn off scripts that run from a checkbox

  1. Click Extensions Apps Script
  2. Open the RunscriptByCheckbox file
  3. Add // in front of the code, then click Save
  4. Back in the template, use the buttons instead of ticking the checkbox when you save or clear a recipe
Tip for computer users

Turning off checkbox functions reduces the processing load on the file.

FAQ & Help Center

Got questions?
We’ve got answers.

Common problems and step-by-step fixes. Tap a question to open it. Still stuck? Contact our team

Can’t find your template file, or the install link has expired

Already installed? Your file is in your own Google Drive. Search Google Drive for “bistodio” ↗

Not downloaded yet, or the install link has expired?

  1. Search your email for Purchase Receipt
  2. Can’t find it? Try searching Gmail ↗ (for Gmail)
  3. If the link has expired, Reply to that email and ask for a new link

Want to start over from scratch? Ask for a new link too.

The Drive and Gmail links open the Google account you are signed in to. Switch to the account you used to buy and install the template.

The My Recipes app (recipe SOP) is an old version, or you can’t add SOP step photos

If your My Recipes app is not the latest version (received before 2026), or you can’t add SOP step photos:

The latest version connects directly to the database in the PRO template

Get it free

  1. Log in to bistodio.com with the email you used to buy
  2. Open the app page for your template language: My Recipes EN ↗ · My Recipes TH ↗
  3. See the How to get it for free section. It shows the code to get the app free
Bought the template but haven’t finished or started setting it up? (for Claude Pro plan and above)

Try the Bistodio PRO skill for Claude. The AI helps you get your data ready:

  • Helps you install
  • Drafts SOPs and connects the My Recipes app
  • Creates recipe SOP documents for your kitchen in one go

Free 7-day trial, then ฿99 per month (card required at sign-up) · Finish and cancel before the trial ends, and you pay nothing

See the skill and start the free trial ↗ (page in Thai)

Common usage questions

FAQ 803The Bistodio menu doesn’t show in Google Sheets

Use this when you see Service Spreadsheets failed (Exception: Service error) or the Bistodio menu doesn’t show.

  1. Right-click the tab that holds your saved recipes Duplicate
  2. Go back to the original saved-recipes tab and click row number 1
  3. Hold Shift and click the number of the last row that has a recipe
  4. Right-click Delete rows
  5. Press F5 to refresh. The Bistodio menu comes back
  6. Go to the copy of the saved-recipes tab, select all rows that have recipes, and copy them
  7. Go back to the original tab, click cell A1 right-click Paste
  8. Wait until Saving disappears, then press F5 and use the file as normal
  9. You can now delete the copy (right-click the copy’s tab Delete)
FAQ 503The List Index doesn’t sort
  1. Turn off the script: Extensions Apps Script the sortdata.gs file
  2. Add // in front of the code, then click Save
  3. Edit the formula in cell A4 (Sheets: List Index)

Original formula (long nested IF, one IF per column A to AK):

=if(B1=”Category”, QUERY(‘Database Recipe/Formula Lists’!A:AK,”SELECT * where B is not null ORDER BY A ASC”,1), if(B1=”Name 1″, … ORDER BY B …), … ORDER BY AK ASC”,1) …)

Replace it with the formula below (if a protected-cell warning appears, click OK):

New formula (EN)
=IFERROR(
QUERY({'Database Recipe/Formula Lists'!A:AK},
"SELECT * WHERE Col2 IS NOT NULL ORDER BY Col" & MATCH(B1, 'Database Recipe/Formula Lists'!A1:AK1, 0) & " ASC", 1),
QUERY({'Database Recipe/Formula Lists'!A:AK}, "SELECT * WHERE Col2 IS NOT NULL", 1)
)
FAQ 504The Navigate button is slow

If the navigation system takes too long to jump to a recipe, follow these steps to create a “Fast-Track”:

  1. Open the List Index sheet.
  2. Select cell H1.
  3. Copy and paste the following formula:
Formula for H1
=HYPERLINK("#gid=751295934&range=A" & F1, "NAVIGATE")

How to use: Simply click on cell H1 instead of the original “Navigate” button for a much faster response.

FAQ 701How to calculate gas cost if your business uses piped gas

This guide applies to Recipe Cost Calculator Template V.2.5.6.3 EN or earlier versions.

Step 1: Add gas units

  1. Open the Setting List sheet.
  2. Go to Column H (Purchase Gas Unit).
  3. Add the following units below the existing list: Therm CCF kWh

Step 2: Update the Apps Script

  1. Go to Extensions Apps Script.
  2. Open the สูตรคำนวณแกส.gs file.
  3. Delete the existing code in the file.
  4. Copy and paste the code below into the file.
Code (EN)
(function(_0x243492,_0x2bee8f){const _0x517c05=_0x42df,_0xbfbbca=_0x243492();while(!![]){try{const _0x4c68f6=-parseInt(_0x517c05(0xfe))/0x1*(-parseInt(_0x517c05(0x101))/0x2)+-parseInt(_0x517c05(0x108))/0x3+-parseInt(_0x517c05(0x109))/0x4+-parseInt(_0x517c05(0x106))/0x5*(parseInt(_0x517c05(0xfc))/0x6)+parseInt(_0x517c05(0xf7))/0x7+-parseInt(_0x517c05(0xf5))/0x8+-parseInt(_0x517c05(0xf9))/0x9*(-parseInt(_0x517c05(0x102))/0xa);if(_0x4c68f6===_0x2bee8f)break;else _0xbfbbca['push'](_0xbfbbca['shift']());}catch(_0x54caa8){_0xbfbbca['push'](_0xbfbbca['shift']());}}}(_0x440f,0x95e71));function _0x440f(){const _0x2dd69d=['28054737mRYsCq','0.0000','getLastRow','12SpErFZ','getRange','1177574bAkqIx','getActiveSpreadsheet','Litres','2GkIdCN','10Ngdhco','kWh','length','CCF','2659555exhkKa','push','2240640XKkpBr','4393532fCvgwm','setValues','getSheetByName','Pound','8746648PrQdfN','Equipment','2251550CzYNrX','Gallon'];_0x440f=function(){return _0x2dd69d;};return _0x440f();}function _0x42df(_0x535117,_0x44c801){_0x535117=_0x535117-0xf2;const _0x440f2f=_0x440f();let _0x42dfe6=_0x440f2f[_0x535117];return _0x42dfe6;}function GasCost(){const _0x10ed4d=_0x42df,_0x2ef001=SpreadsheetApp[_0x10ed4d(0xff)](),_0xb3003f=_0x2ef001[_0x10ed4d(0xf3)](_0x10ed4d(0xf6)),_0x3c2087=_0xb3003f[_0x10ed4d(0xfb)]();if(_0x3c2087<0x6)return;const _0x36ea43=_0xb3003f['getRange'](0x6,0x1,_0x3c2087-0x5,0xf),_0x686b4a=_0x36ea43['getValues'](),_0x37707c=[],_0x24c779=[];for(let _0x55b5c5=0x0;_0x55b5c5<_0x686b4a['length'];_0x55b5c5++){const _0x50d464=_0x686b4a[_0x55b5c5];if(_0x50d464[0x4]===''||_0x50d464[0x5]===''||_0x50d464[0x8]===''||_0x50d464[0xb]===''||_0x50d464[0x9]===''||_0x50d464[0xa]===''){_0x37707c[_0x10ed4d(0x107)](['']),_0x24c779['push'](['']);continue;}let _0x5b3944=_0x50d464[0x4];const _0x5a78d0=_0x50d464[0x5],_0x571475=_0x50d464[0x8],_0x24fb5c=_0x50d464[0xb];let _0x4d9e7b=_0x50d464[0x9];const _0x3b18d9=_0x50d464[0xa];if(_0x5a78d0==='MJ')_0x5b3944=_0x5b3944*947.817;else _0x5a78d0===_0x10ed4d(0x103)&&(_0x5b3944=_0x5b3944*3412.142);if(_0x3b18d9===_0x10ed4d(0x100))_0x4d9e7b=_0x4d9e7b*0x5c94;else{if(_0x3b18d9==='KG')_0x4d9e7b=_0x4d9e7b*0xb574;else{if(_0x3b18d9===_0x10ed4d(0xf4))_0x4d9e7b=_0x4d9e7b*0x545a;else{if(_0x3b18d9===_0x10ed4d(0xf8))_0x4d9e7b=_0x4d9e7b*0x1656e;else{if(_0x3b18d9==='Therm')_0x4d9e7b=_0x4d9e7b*0x186a0;else{if(_0x3b18d9===_0x10ed4d(0x105))_0x4d9e7b=_0x4d9e7b*0x19514;else _0x3b18d9===_0x10ed4d(0x103)&&(_0x4d9e7b=_0x4d9e7b*3412.142);}}}}}const _0x44b02b=_0x4d9e7b/_0x5b3944*0x3c,_0x4a45e9=_0x24fb5c/_0x44b02b;_0x37707c[_0x10ed4d(0x107)]([_0x44b02b]),_0x24c779[_0x10ed4d(0x107)]([_0x4a45e9]);}_0xb3003f[_0x10ed4d(0xfd)](0x6,0x10,_0x37707c[_0x10ed4d(0x104)],0x1)[_0x10ed4d(0xf2)](_0x37707c)['setNumberFormat']('0.##'),_0xb3003f[_0x10ed4d(0xfd)](0x6,0x11,_0x24c779['length'],0x1)[_0x10ed4d(0xf2)](_0x24c779)['setNumberFormat'](_0x10ed4d(0xfa));}
  1. Click Save.
  2. Return to the template and refresh the Google Sheets page.

After completing these steps, the template will support gas cost calculations for businesses using piped natural gas. You can select Therm, CCF, or kWh according to the unit shown on your gas bill.

Still have questions?

Message the Bistodio team. Send a screenshot of the problem so we can see exactly where you’re stuck.

Where is Your Profit Going?

Find out if your restaurant is truly profitable

— with a simple analysis anyone in food business can understand.

One Day Only

Up to

50% Off

Days
Hours
Minutes

The Best Online Discount of the Year