What’s New in Scriptcase

6 articles Á By Álvaro Moura

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. Configuring 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.

Getting the DeepSeek API Key for Scriptcase AI

In this tutorial, you will learn how to create an API key on the DeepSeek platform and configure it in Scriptcase AI. Chat subscription vs. DeepSeek API key Scriptcase AI uses the DeepSeek API to communicate with the provider. Therefore, the subscription for DeepSeek’s standard chat plans is not used as credit for this integration. As a result, you do not need to have a standard chat plan to use DeepSeek in Scriptcase AI. To configure DeepSeek in Scriptcase AI, you need to generate an API key on the DeepSeek platform and have available balance/credit in your account for API usage. API billing is based on token consumption, and the charges are deducted from the available balance in your platform account. Getting the DeepSeek API key 1. Access the DeepSeek platform with your account: https://platform.deepseek.com/api_keys 2. After logging in, access the API keys area. 3. Click the option to create a new API key. 4. Define a name for the key and click Create key. The name is optional, but we recommend using an identification that makes it easier to manage the key later in the list of keys. 5. After generating the key, copy the displayed code and store it in a safe place. Save the API key in a secure location. Do not share it, publish it in repositories, or send it to third parties. If you lose the key, you will need to generate a new one and update the configuration in Scriptcase AI. For more details about creating and using the API key, see the official DeepSeek documentation. Configuring DeepSeek in Scriptcase AI 1 - After logging in to Scriptcase with an administrator account, access the Tools > Scriptcase AI menu. 2 - Copy the API key generated on the DeepSeek platform and paste it into the API Key field. In this step, select the DeepSeek provider, as well as the Chat Model and Smart Tasks Model that will be used by Scriptcase AI. If desired, also enable the option to create and translate the data dictionary automatically. 3 - Project access permissions In the project list, define the access permissions of Scriptcase AI for each project. Enable Code access to allow Scriptcase AI to analyze the code of the open event and assist with tasks such as explanation, review, adjustments, and code suggestions. In addition, grant access to the connections so that Scriptcase AI can query the database structure, such as tables and fields, and use this information when generating or adjusting code. Scriptcase AI accesses only the database structure, such as tables and fields. It does not access or read the data stored in the tables. 5 - After filling in the information and defining the desired permissions, click Save settings. After saving, the chat and smart tasks will be available using the DeepSeek provider in Scriptcase AI.

Getting the Anthropic API Key for Scriptcase AI

In this tutorial, you will learn how to create an API key on the Anthropic platform and configure it in Scriptcase AI. Claude subscription vs. Anthropic API key Scriptcase AI uses the Anthropic API to communicate with the Claude provider. Therefore, the subscription for Claude’s standard plans is not used as credit for this integration. As a result, you do not need to have a standard Claude plan to use Anthropic in Scriptcase AI. To configure Anthropic in Scriptcase AI, you need to generate an API key in the Claude Console and have available balance/credit in your account for API usage. API billing is handled separately, according to the API usage in the Claude Console. Getting the Anthropic API key 1 - Access Claude Console with your account: https://console.anthropic.com/ When accessing Claude Console for the first time, select how you will use the Claude API. Individual: recommended for personal use, where you create, test, and manage your own API keys and billing. Organization: recommended for companies or teams, allowing you to invite colleagues, share API access, and manage billing centrally. 2 - After logging in, on the dashboard tab, click the Get API key button. 3 - Define a name for the key. The name is optional, but it is recommended to use an identification that makes it easier to manage the key later in the list of keys. Choose the workspace where you want to create your key. The default workspace can be used, as shown in the image below. 4 - After generating the key, copy the displayed code and store it in a safe place. Save the API key in a secure location. Do not share it, publish it in repositories, or send it to third parties. If you lose the key, you will need to generate a new one and update the configuration in Scriptcase AI. For more details about creating and using the API key, see the official Anthropic documentation: https://docs.anthropic.com/ Configuring Anthropic in Scriptcase AI 1 - After logging in to Scriptcase with an administrator account, access the Tools > Scriptcase AI menu. 2 - Copy the API key generated in the Claude Console and paste it into the API Key field. In this step, select the Anthropic provider, as well as the Chat Model and Smart Tasks Model that will be used by Scriptcase AI. If desired, you can also enable the option to create and translate the data dictionary automatically. 3 - Project access permissions In the project list, define the access permissions of Scriptcase AI for each project. Enable Code access to allow Scriptcase AI to analyze the code of the open event and assist with tasks such as explanation, review, adjustments, and code suggestions. Grant access to the connections so that Scriptcase AI can query the database structure, such as tables and fields, and use this information when generating or adjusting code. Scriptcase AI accesses only the database structure, such as tables and fields. It does not access or read the data stored in the tables. 4 - After filling in the information and defining the desired permissions, click Save settings. After saving, the chat and smart tasks will be available using the Anthropic provider in Scriptcase AI.