How to Use Constraints

Hi all, Been struggling to understand how to utilise the Constraint field when i have 2 tables linked together. Table 1 is Staff details which contains everything about a certain staff member,…

Sum related field with specific criteria issue

I have a table called Projects with a reference to a table called Proposals, and there can be multiple Proposals per Project. Within Proposals I have two fields;…

Sort / Order by based on total count

That is even hard to explain. So I do use a dynamic choice box do suggest possible values based on already existing values from that column. I can sort them alphabetically but I would love it if,…

• Answered

Convert "Credit Term" to Date plus credit term

Hello. I have 2 fields. CREDIT TERM (number field) DUE (date field) If I add 30 (or any other value) into the CREDIT TERM field, I want the DUE field to auto-update to 30 days from today.…

• Answered

Picture and URL

Code for displaying picture in his field, by a trigger, via URL. Thank you.

Birthday function in tab

when clients are registered, I write down the date of birth. How do I make it so that when a birthday comes up, it will be seen in a different color in the client list. Regards

• Answered

Searching Multiple Choice Dynamic Fields

I am using the Multiple Choice Dynamic Field and it is working great from a selection standpoint. However I want to be able to list, search or filter based upon records that have certain choices…

Clear out Dynamic Multiple Choices

As I've been learning Multiple Choices (Dynamic) I've made a variety of changes, and not that I've settled on the proper approach the target record seems to have recorded the previous choices and now…

Start with date in a multi line test field

Good evening and greetings to all. I need that every time I enter a new text in a multi line text field, it automatically inserts the date before I start writing.…

• Answered

Send reminder SMS

Hi everyone I am trying to send an appointment SMS reminder referred to an DATA FIELD. How is this possibly, if it is! I look on Zapier, but can't find the right app. thanks in advance.

writable if - otherwise calculate from another field

Hello, I have a numeric field for a measurement in inches, and a second for a measurement in centimetres. When I enter one I would like it to auto-calculate the other.…

• Answered

Loop Syntax Correction

Hello. I am having a bit of trouble with this for-loop, a syntax error and would love an extra pair of eyes on this, I basically have a 'Hire Date' field,…

• Answered

Select an element of choice dynamic in formula

In table TabA I have field 'Year' (field choice dynamic) which takes from table TabB the following data (field number): 2022 2023 2024 2025 2026 2027 2028 2029 In the taba table I have a button that…

• Answered

Kanban tile layout

I've been looking around to figure out how to control which fields can be displayed in the tile when in Kansan view but can't figure it out. Hopefully someone can explain,…

Creating record from another table

Try to create a record via button from another table (T2), where values of fields (of this T2) automatically been put into respective fields in T1 ... fe.…

Different results using Checkbox vs Button to update text field with today() using the exact same code

I was having an issue with dates not storing correctly with some of my code. The code was storing dates as the next day instead of current day. While trying to figure out where my problems were…

After deleting a record the app hangs

Hi! I can't provide much information this time. After deleting a record the app hangs I can't understand why this happens. Could there be a particular reason?…

Go to a specific record

Hi! I have 4 tables: TAB1 with the respective sub-table TAB4 TAB2 with the respective sub-table TAB3 Through the links I start from the N record in TAB1,…

• Answered

How would I code/formula for a MAC address in a text field?

If I enter the following: 00107FCFD06FIs it possible to have it displayed like this: 00:10:7F:CF:D0:6F places : and force uppercase

Hiding the child table

I would like to hide the child table like 'ProjektStückliste' from the side nav. The user shall only see the child records navigating over the parent table.…

• Answered

Renaming part of title attachment

I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…

• Answered