OR([Email Id] = USEREMAIL(),IN(USEREMAIL(), LIST("hr@mycompany.com ", "system@mycompany.com"))) Understanding AppSheet Permissions with a Practical Formula This expression utilizes two important functions: `OR()` and `USEREMAIL()`, along with the `IN()` function. Let's break down each component to see how they work together to manage permissions. Direct Email Comparison[Email Id] = USEREMAIL() Purpose: This
How to sum values from Referenced Rows in AppSheet Introduction Google AppSheet offers powerful tools for non-coders to build custom applications that leverage such capabilities. One common requirement is to sum values from rows that are related or referenced by another table or column. This blog explores how to use
Conditional Expressions to Control Visibility in AppSheet Views Introduction AppSheet offers powerful capabilities to customize the behavior of apps based on the context in which they are used. One of the key features is the ability to dynamically show or hide elements based on certain conditions. This can greatly enhance
How to calculate Total Number of Days in a Month in AppSheet Introduction In my recent project, I was tasked with creating a Salary Sheet table for an Attendance App using AppSheet. One of the key requirements was to calculate the total number of days in a month, which seemed
ISBLANK AND ISNOTBLANK FORMULA IN APPSHEET While making an AppSheet application on a Complaint Management System for a CCTV company, I had to create a slice where I had entered a complaint but had not assigned that complaint to an employee. To achieve this, I needed to filter the data
HOW TO GENERATE AUTOMATIC SERIAL NUMBERS IN APPSHEET? Generating automatic serial numbers in AppSheet is crucial for maintaining order and efficiency in business processes. Whether it's for orders, quotations, jobs, complaints, or invoices, having a systematic approach to generate these numbers can streamline operations and reduce errors. Here's a comprehensive
How to restrict editing a Row after a certain time in Your AppSheet App In any business application, controlling when and how data can be edited is crucial. AppSheet provides powerful tools to implement such restrictions easily. One common requirement is to restrict editing after a certain time, ensuring data
How to dynamically open App sheet Views with Conditional Logic As a business consultant who frequently uses AppSheet to streamline business processes, I often encounter situations where dynamic linking based on specific conditions becomes essential. Recently, I faced a scenario where I needed to create links to various forms depending
How to Calculate the Number of Days Between Two Dates in AppSheet? Calculating the number of days between two dates is a common requirement in many applications, whether it’s for tracking project timelines, managing maintenance schedules, or calculating the time between events. In AppSheet, this task can be accomplished with
How to Calculate the Number of Days Between Two Dates in AppSheet? Calculating the number of days between two dates is a common requirement in many applications, whether it’s for tracking project timelines, managing maintenance schedules, or calculating the time between events. In AppSheet, this task can be accomplished with
