What’s New in Scriptcase
Discover What’s New in Scriptcase 10
Scriptcase 10 is now available, bringing new features designed to make application development faster, more integrated, and more intelligent. The main highlights include artificial intelligence integration, automated generation of related applications, automatic identification of table relationships, and improvements to application creation and configuration. Scriptcase AI Scriptcase AI is an assistant integrated into the development environment that can help create, analyze, and correct code directly within application events. The assistant can use the project context to: - create and adjust PHP, SQL, JavaScript, and HTML code; - analyze the code of the currently open event; - identify possible errors and suggest corrections; - transform SELECT statements into Grid applications; - suggest the next steps during the conversation; - retain conversation history and relevant information across different chats. Scriptcase AI is compatible with API keys from OpenAI and Google Gemini. Access can be configured individually for each project. When connection access is enabled, the assistant can access only the database structure, such as tables, fields, and relationships. The data stored in the tables is not accessed. AI-Powered Project Translation Scriptcase AI can also assist with translating project elements. When adding a new language, AI can automatically translate: - data dictionary entries; - field labels; - descriptions; - language messages; - custom interface content. This feature can be used during project creation, when synchronizing the data dictionary, or when adding a new language to an existing project. Additional Applications The new Additional Applications feature allows you to create related applications from a main table. Scriptcase identifies existing database relationships and can automatically generate: - Grid applications; - Form applications; - links between applications; - queries with the required relationships. The applications are created and linked without the need to manually configure global variables for communication between them. Auto Join Auto Join identifies fields related through foreign keys and automatically updates the Grid application’s SELECT statement. With this feature, Scriptcase can: - identify foreign key columns; - add the required JOIN clauses to the SELECT statement; - display descriptions instead of numeric IDs; - sort records using the value displayed on the screen. This reduces the need to manually create lookups to display information from related tables. New Font Awesome Field Scriptcase 10 also introduces a new field type for displaying Font Awesome icons. You can configure: - the icon to be displayed; - whether the icon should be displayed as a button; - the button background color; - the use of the field to open related applications. Improvements to Modal Links Applications opened through Modal links can now have their width and height configured using pixels or percentages. You can also set the width to 100%, allowing the linked application to use all available screen space. Compatibility and Upgrade Scriptcase 10 can be used in the same environments supported by Scriptcase 9, including PHP 7.3, PHP 8.1, and PHP 8.2. Customers with an active license subscription can upgrade to Scriptcase 10 at no additional cost. To explore all the new features, watch demonstration videos, and learn more, visit: Discover Scriptcase 10
API Configuration for Use with Scriptcase AI
Scriptcase AI uses APIs to communicate with artificial intelligence models, helping developers create, maintain, and evolve projects developed in Scriptcase. To use Scriptcase AI, it is not necessary to purchase a standard subscription, such as ChatGPT Plus, Google AI Pro, or any other equivalent plan. These subscriptions are not required to use the API, their purpose is to allow access to the paid version of the AI assistant directly through the provider's own website. When using Scriptcase AI with an API key, billing is based on demand, considering factors such as the model used, the volume of requests made, and the number of tokens processed. However, in the standard subscription plans, the amount will be charged regardless of usage during that month. It is not necessary to purchase a standard subscription, such as ChatGPT Plus or Google AI Pro, to use Scriptcase AI through the API. How values are calculated This consumption is measured in tokens, which represent small parts of the content sent to and received from the AI, such as texts, instructions, questions, code snippets, and responses generated by the model. In each interaction, the API counts the input tokens, referring to the content sent to the AI, and the output tokens, referring to the generated response. In practice, common tasks, such as generating suggestions, translating content, reviewing small excerpts, explaining errors, adjusting parts of code, or assisting in the creation of applications, tend to consume a reduced number of tokens. Example of values by model and token The values below, obtained on 06/11/2026 from the official pages**,** refer to API usage and are intended only to demonstrate the cost difference between models. Prices may change, so it is recommended to always check the official pages before purchasing. ChatGPT (OpenAI API Pricing): https://developers.openai.com/api/docs/pricing Gemini API Pricing: https://ai.google.dev/gemini-api/docs/pricing 1 million tokens represents approximately between 600,000 and 750,000 words, depending on the language and the type of content processed. | Provider | Model | Input | Output | Notes | | -------- | ---------------------- | ---------------------- | ----------------------- | -------------------------------------------------------------------------------------- | | OpenAI | gpt-5.5 | US$ 5,00 per 1M tokens | US$ 30,00 per 1M tokens | Most capable model, with higher cost | | OpenAI | gpt-5.4-nano | US$ 0,20 per 1M tokens | US$ 1,25 per 1M tokens | Lightweight, cost-effective model. Primarily used for Scriptcase AI intelligent tasks. | | Gemini | Gemini 3.1 Pro Preview | US$ 2,00 per 1M tokens | US$ 12,00 per 1M tokens | Most capable model | | Gemini | Gemini 2.5 Flash-Lite | US$ 0,10 per 1M tokens | US$ 0,40 per 1M tokens | Lightweight, cost-effective model. Primarily used for Scriptcase AI intelligent tasks. | Generate an API Key GPT / OpenAI To use GPT models in Scriptcase A, you need to access the OpenAI developer platform and generate an API key. Step-by-step 1. Access the OpenAI Platform. 2. Log in with an OpenAI account. 3. If the user already uses ChatGPT, they can use the same login. However, API usage has separate configuration and billing from the ChatGPT subscription. 4. Access the Billing area. 5. Configure the payment method or add credits for API usage. 6. The OpenAI API works with consumption-based billing. Added credits are consumed as requests are made. 7. Access the API Keys area. 8. Create a new API key. 9. Copy the generated key and store it in a safe place. 10. The key must be saved at the time of creation. For security reasons, the platform may not display the full key again afterward. 11. In Scriptcase, access the Scriptcase AI configuration. 12. Select the OpenAI/GPT provider. 13. Enter the generated API key. 14. Save the configuration and perform a connection or AI usage test. Monitoring API Usage The platform dashboard provides detailed metrics on costs, request volume, and rate limits. 1. Access the OpenAI Platform website and sign in. 2. In the left-side menu, go to Usage to view a detailed breakdown of daily token consumption by model (such as GPT-5.5 or GPT-5.4 Nano) and accumulated costs. You will see a detailed dashboard containing all information related to your API usage. Generate an API Key Gemini / Google To use Gemini models with Scriptcase AI, you must access Google AI Studio or configure a project in Google Cloud and generate an API key. Step-by-Step 1. Access Google AI Studio. 2. Sign in with a Google account. 3. Accept the Terms of Service if this is your first access. 4. Go to the API Keys section. 5. Create a new API key. On future accesses, Google AI Studio may automatically create a default project linked to your account. You can also use or import an existing Google Cloud project. 6. Copy the generated API key. 7. If you need paid features or higher limits, configure billing for the project. 8. In Scriptcase, access the Scriptcase AI settings. 9. Select Gemini as the provider. 10. Enter the generated API key. 11. Save the configuration and perform a connection or AI usage test. Monitoring API Usage 1. Access the Google AI Studio Usage Dashboard. 2. Sign in with your Google account. There, you will find detailed charts showing daily usage, rate limits, and token consumption for each Gemini model. You will see a detailed dashboard containing all information related to your API usage. To access the API consumption view, you need to have the payment method configured. Recommendations Treat the API key as a password. Do not share it in chats, repositories, public pages, or places accessible to end users. Whenever possible, use a dedicated key for Scriptcase AI, monitor API usage, and configure usage limits in the provider. If you suspect the key has been exposed, replace it immediately and remove old keys that are no longer in use.
Getting a ChatGPT (OpenAI) API Key for Scriptcase AI
In this tutorial, you will learn how to create an API key on the OpenAI platform and configure it in Scriptcase AI to use the intelligent features available in your projects. Obtaining the OpenAI API key 1. Access the OpenAI platform with your account. 2. After logging in, access the API keys area. 3. Click the option to create a new API key. 4. Define a name and click Create secret key. The name is optional, but we recommend using an identification that makes it easier to manage it later in the list of keys. For more details about creating and managing API keys, see the official OpenAI documentation. 5. After generating the key, copy the displayed code and store it in a safe place. Save the secret key, as it will not be possible to view it again. Keep it protected, since anyone with your API key can make requests on your behalf. If you lose it, you will need to generate a new one. API Key Management On the API Keys screen, it is possible to manage the created keys. In the column highlighted in the image below, you can access the key management options, such as editing permissions or deleting the key. The complete key is only displayed at the time of creation. If you lose or do not save the key, you will need to create a new one and update the configuration in Scriptcase AI. Configure Scriptcase AI 1. After logging in with an administrator account in Scriptcase, access the Tools > Scriptcase AI menu. 2. Copy the generated API key and paste it into the API Key field. In this step, enable the option to create and translate applications automatically and select the OpenAI Provider, as well as the Chat Model and Smart Tasks Model. 3. Project access permissions In the project list, define the access permissions of Scriptcase AI for each project. Enable Code View and grant access to the connections so that Scriptcase AI can analyze the code of the open event and access the structure of the database tables and fields. Scriptcase AI accesses only the database structure, such as tables and fields. It does not access or read the data stored in the database. 4. After entering the information, click save settings. The chat and smart tasks are now available. See more details about the options on the configuration screen in our documentation.
Getting a Gemini API Key for Scriptcase AI
In this tutorial, you will learn how to create a Gemini API key in Google AI Studio and configure it in Scriptcase AI to use intelligent features in your projects. Obtaining the Gemini API key 1. Access Google AI Studio with your Google account. 2. After logging in, access the API keys area. 3. On the API Keys screen, click Create API key. 4. Enter a name and click Create key. Create the API key using the Gemini default project or select an existing project. 5. After generating the key, copy the displayed code and store it in a safe place. Do not share, publish in repositories, or send the key to third parties. API key management On the API Keys screen, the created keys can be managed. In the highlighted column shown in the image below, you can copy the API key and monitor the usage of that specific key. Quote Whenever possible, use a dedicated key for Scriptcase AI. This makes it easier to control usage, identify consumption, and replace the key if necessary. Configure Scriptcase AI 1. After logging in with an administrator account in Scriptcase, access the menu Tools > Scriptcase AI. 2. Copy the generated API key and paste it into the API Key field. In this step, enable the option to create and translate applications automatically and select the Google provider, as well as the Chat Model and Smart Tasks Model. 3. Project access permissions In the project list, define the access permissions of Scriptcase AI for each project. Enable Code View and grant access to the connections so that Scriptcase AI can analyze the code of the open event and access the structure of the database tables and fields. Scriptcase AI accesses only the database structure, such as tables and fields. It does not access or read the data stored in the database. 4. After entering the information, click save settings. The chat and smart tasks are now available. See more details about the options on the configuration screen in our documentation.