Alright, let's get started! Open up Glide and kick off your app using a new or existing Google Sheet. Make sure your data is neat and tidy, with columns clearly labeled for the items you want to price in different currencies.

Next, in your Google Sheet, set up separate columns for each currency you need. For instance, you might have columns named "Price_USD," "Price_EUR," and "Price_GBP." Pop in the price values for each item in the right columns.

Glide has this cool feature where you can create user-specific columns that only the individual user can see. Use this to make a dropdown menu for users to pick their preferred currency.

1. Click on the "Data" tab in Glide.
2. Add a new column, and choose "User-specific" as the column type.
3. Name the column "Preferred Currency" or something similar.

Now, head over to your app layout and add a "Choice" component. This will let users select their preferred currency.

1. Go to the "Layout" tab.
2. Add a new "Choice" component.
3. Set the "Data" to the "Preferred Currency" user-specific column.
4. Add the currency options (e.g., USD, EUR, GBP) that match the columns you set up in your Google Sheet.

Time to create "If-Then-Else" columns to show the correct price based on the user’s currency choice.

1. Go to the "Data" tab.
2. Add a new column, and select "If-Then-Else" as the column type.
3. Define the logic:
   • If "Preferred Currency" is "USD," then set the value to "Price_USD."
   • If "Preferred Currency" is "EUR," then set the value to "Price_EUR."
   • If "Preferred Currency" is "GBP," then set the value to "Price_GBP."
4. Name this column "Display Price" or something similar.

Finally, let's make sure your items show the right price based on the user's choice.

1. Go to the "Layout" tab.
2. Find the component displaying the price (e.g., Text, Rich Text).
3. Bind the component’s data to the "Display Price" column.

This setup ensures that each user sees the price in their chosen currency.

Now, give your app a test run to make sure everything's working smoothly. Change the currency in the dropdown and check that the prices update correctly.

• Use the "Preview As" feature in Glide to see how different users will experience the currency selection and display.
• Make any tweaks if needed.

And there you have it! A step-by-step guide to setting up multi-currency support in Glide.