Button to make record

Еhere is a table where all clients are written, and in this table there are several more sub tables. We created a button separately from all tables through it we make entries in all tables.…

• Answered

Time format in Formula field

I need to duration from start to finish. For this I have two fields both "date+Time". To count the time and create a formula field and he thinks everything, The problem is in the display.…

Copy and open new record

for duplicate last record im us formula let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]); if x = "Yes" then let c := duplicate(this); let t := this; c.…

• Answered

Using tags for searching

I have a table where the data of the zazny department is recorded. The name of the department is formed by tags, tag1 + tag2 + tag3. I want to create a table and separate fields for tags,…

In Out Button

Ш need to create a table where the in/Out of goods will be marked. Access to the table will be closed and the record can be done through the button. There will be two In and Out formula for In button:…

Multiply for formula fields

Hi The table has formula fields "Formula 1" and "Formula 2", which, for their part, take information from other tables. I need to multiply "Formula 1" by "Formula 2".…

• Answered

Automatic table cleaning after one year

in my database there is a table that collects information about discounts. But they are valid only for a year. How to make sure that all information in the table is deleted after a some time,…

• Answered