-
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?
-
remapping values on a chart
I wanted to re-map sensor values on a chart. I can do it by using a formula, then charting that value. But it would be nice if this type of option was built into the chart.…
-
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].…
-
Suggestion: stop the double click on inline editing triggering the form pane
At the moment, revealing a dropdown menu in inline editing mode requires two clicks - BUT if you double click too fast, the table flips to form editing mode and the form pane jumps in from the right.…
-
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.
-
Fatal Error when compiling a code
I have a database with registered clients. Among all, I try to get the total payments, filtered by date. That is, for example, how much I got between September 1 and September 30.…
-
Relate tables between different databases?
Hello, It is possible to relate tables between different databases? Thanks!
-
sum and count function?
Is there sum and count function for column
-
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.…
-
Email Automatisierung
Ich würde gerne eine automatische Email senden, wenn der Lagerwert auf 0 geht. Ist das möglich ?
-
Pulling capital letters out of a string
My wife has this funny file system where we use the year, a sequential number, and the first letters of two peoples names. Is there any chance I can have a string fill with just the Capital Letters…
-
Search with configurable fields to show
The search options only shows the first 7-8 fields in a database. Please, add the ability to select what fields to show