-
Trigger on presence of image
How do I make an icon appear in a formula field if a given image field has an image uploaded (i.e. is not blank)?
-
Color Code a Formula
Hello, I would like to color code a formula I have that is subtracting the value from two existing number fields. In this formula, for example named 'Total Demand' I want it to change color based on…
-
Can I send a email with the attached file from a specific record
Hello I used the function importFile (see example code) and that works well!In a other step I want to send emails to the customer with the attached file of a specific record (see previous action).…
-
Ways to list views
I'm developing a site where multiple users can work on records in the same table, and I'm trying to keep the navigation simple by directing them to views that list the columns each person needs to…
-
Hide Expired Entries
Each entry on my table has an expiry date set 2 weeks after the date it’s created. How do I set expired entries to hide automatically upon their expiry date?
-
Can I show a dialog window to the user and let them enter values in a field or variable?
Hello support Is there a possibility to show a dialog window to the user so that the user can enter a value in a field / variable and then confirm it? I want to use the entered value into a…
-
Hide a record?
How do I hide a record?
-
select and concatenate
I have two fields: 'name' and a 'yes/no' choice. How do I select and concatenate the names marked as 'yes'?
-
How do you move a number field data point from several tables to a master table field.
Ie. example 1. Price field from several vendor tables to one Price field in the master Inventory field table Also, all are connected thru a separate key field. Sku field
-
Parse Multi-line box
Hello again, I would like to paste a static chunk of text into a multi-line box and, on Trigger, have it take a substring from the first line and place it in my customer name field,…
-
How can change color font in table
How can change color font in table
-
Is it possible to clone choice fields in a table?
I have a long choice field that I need to duplicate (same choices) for different functions. Can be done manually, but cloning and renaming an existing field would be more efficient.…
-
Change To-Do list option if button click
Hello. I have a To-Do multiple choice. It have 6 options. I want the script in a button to, when click on it, if the desired options is selected, then unselect it.…
-
Trigger based on multiple fields
I have a proofer who may be called to work on several projects, and I want a single choice column that I can use to alert her that one of these projects need proofing.…
-
I am trying to populate an email field with the same email from another email field.
I have School table with contact details, I then have a bookings table. I am trying to populate the bookings table email field with the email from the school email field.
-
Can a date be triggered.
Can a date be triggered when a service contract is due for renewal ? I'm wanting an alarm when a Contract is due for service / renewal Many Thanks Best Rgards Phil Coley
-
Help Please
I’m trying to set up a very simple database to help me with a two-weekly task. Firstly, I need my first field to contain a consecutive number for each entry.…
-
Expiry date
I have a date field which records today’s date and I need the next field (expiry date) to show the date 2 weeks from now. Which formula would I use and in which fields?
-
Find Date?
How to I search to find a date?
-
Automatically updating a field
I have a table with 2 subtables. The main table contains MEMBERS of an organization. One of the subtables (DUES) contains their membership dues payments and the date paid.…
-
change single items of an array
Hi, i would like to know how i change single items of an array. Let's say if have an array := [a,b,c] and i want to change item 2 [b] to f. The final array will look like [a,f,c].…
-
Anyone know where to find support info on buttons?
What can I use them for? Can they call up views or subtables or fields as popups? What sort of script makes them work? Sorry, can't find anything in the manual.
-
Relate tables between different databases?
Hello, It is possible to relate tables between different databases? Thanks!
-
Script to combine view fields in the column f(x) function
In my record form I'm using tabs to break down the record's fields into different project areas. To track each of these project areas I've created identical choice fields that show 8 stages - A to H.…
-
How to show hours spend on something
Ok, I know how to do a 'sum' to get all time spend on a project added up.But when it exceeds 24 hours, I get (for example) '1 Days 8:30' wich is actually 32:30 hours.…
Answer questions and share your knowledge