Agassi
-
How select records from related table not older then 3 months
Hello! Actually the subject says it all. I searched for a similiar question here, but did not find... In table Treatments i need to have an average cost of a product i bought in a period (lets say 3…
-
Formula column in List view question
Hello! I got tables Appointments, Treatments, Products. Each Appointment can have one or more Treatment. In each treatment i can use one or more product.…
-
How to use in a formula a value of a specific record from a separate table
Hello! I would like to have a table that contains variables. For example, i'll have a variable there called 'Second_product_discount_var'.So i can use it in formulas.…
-
Create subrecord automaticaly
Hello!I got "Appointments" table and its subtable "Treatments".Most records in "Appointments" have one or more subrecords in "Treatments". But for records that dont have any subrecord i want to…
-
Copy text value of local field to a linked field
Hi!I got a table Stock with a text field "Supplier_Name". I saved the name of supplier in that field. Then i decided to create a table Suppliers to have all the data of suppliers in there and link a…
-
What is "Handle file as" in Image field properties
Hello! In this "Handle file as" selector there are options like: Size Small, Medium, Large, Original size. What do they do really? I thought that selector compresses the uploaded image or keeps its…