Customized Quotation Management Tool Customized Quotation Management Tool Create, manage & share professional quotations in minutes—whether you run your business from a phone, tablet or office computer. Features Data Entry via AppFill a simple form; all details land safely in the system. Create Quote on Any DeviceGenerate a neat PDF
How I Used ChatGPT to Organize My Child’s School Details Organizing all the necessary details for my child’s school was a task I wasn't looking forward to. With so many pieces of information required, from personal details to medical and banking information, it could have been quite the headache. However,
How to Add a Date Filter in Google Sheets Using the QUERY Function Google Sheets is a powerful tool for data analysis, especially when combined with the QUERY function, which allows users to perform SQL-like queries to filter, sort, and manipulate data. One of the most useful features within this
How to send Google Tasks List on Email to Assignees? Introduction While assigning tasks in Google Tasks, I wondered if it was possible to send an email of Google Tasks in tabular form. Upon exploring, I found that yes, it was indeed possible. This discovery opened up a new avenue for me to manage my
How to Find the Number of Days in a Month in Google Sheets Are you tired of manually counting the days in each month in Google Sheets? I've been there too, and I've got a solution for you! Let me share how I tackled this issue. First things first, you'll need
How to Enforce Uppercase Entries in Google Sheets While reviewing a Google Sheet filled out by multiple employees, I noticed inconsistencies in how data was entered—sometimes in uppercase, sometimes not. This variation in text case can severely impact data processing and analysis. Implementing a Solution: Data Validation Google Sheets offers
How to Correct Date Formatting in Google Sheets Dropdowns When working with date formats in Google Sheets, one common issue users face is discrepancies in how dates appear in dropdown menus versus how they are displayed in the cells. Particularly, the problem arises when dates formatted as dd/mm/yyyy in cells
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
