-
Formula - move record to another table
Hi all I have a Quotes table and an Orderstable. I'd like to add a "Convert To Order" button to quotes. I've gotten part of the formula working, but my issue is with the line items.…
-
I have a question about using a URL field.
Is it posible to not only enter a URL into the field, but also fill in a user name and password for that website.
-
Best Practice - Forcing search results - formula vs update text field on trigger
Hi all At the moment, to make results appear how I want in search/lookup functions, I have 7 formula fields at the top of the form that contain info I want to appear in the search.…
-
Tracking User Activity
Is it possible to build a table to count individual user actions in the database as a whole? I want to implement a fun rank and title system, similar to the one on this forum (Apprentice, Ninja, Monk,…
-
Best solution to print texts with a record data if there are many of these texts?
I have a Patients table with their data (name, id number,...). Each time a patient does a different treatment he has to sign a corresponding informed consignment (IC).…
-
is it possible to program a button using statements contained in a choice pull down menu?
is it possible to program a button using statements contained in a choice pull down menu?
-
Is it possible to have small field presentation ?
Hello everyone, I have a table with different kinds of field but when it came to make a layout, they seem to have a minimum space and I cannot shrink them.…
-
Is it possible to use a dot as a decimal separator instead of a comma in a numeric field ?
I think that everything is in the title. regards
-
popup tab
Hi good morning in a table I set two different layout tab views when I try to popup this table I always popup the first, the main layout. how can I popup the second? Which is the proper grammar?…
-
How would I populate a table with random elements from several other tables when I add a record?
I have a table to use as a display and the items from it need to be randomly generated from several other tables. All. of the tables have a unique integer key so randomly generating a number based on…
-
Printout of values
Years back I programmed dBase 4 (and yes, I am very old). When troubleshooting, I could insert print statements which would let me look at calculated values.…
-
pc
is there a pc application
-
Formula comment
How do I make a part of a formula a comment rather than deleting when I am troubleshooting.
-
No attachment file in mail
Hi, I would like to send an email with attachment file, the email is sended but no file attached ! this is my code let myPdf := printAndSaveRecord(this, "DEPANNAGE"); let myName :…
-
how do I use "undefined" in a logical formula?
What is the code for "undefined" in a logical formula, for instance, if the answer to a yes / no question is missing? Thanks
-
How can I optimize a table with lot of data?
I have a table with 728,000 entries. Each entry has about 24 fields - six of which are formula fields. As you can well imagine, whenever I query this table, things tend to slow down,…
-
Increase number by decimal
I thought I posted this but, can't find it so here we go again... I have a version number field, which when I create a new record I need to automatically increase by 0.1.…
-
Change field label text depending from another field Value
In Inventory template in Clients table there is a Language field. Can i change labels of fields depending on the choice in this field? I want to do it to let a customer fill the fields in their…
-
Import issue
I have a csv file and on import via wizard the new database does not show all the fields for me to map to from the csv?
-
Not possible to edit text field
For some reason I can no longer edit the "Other" text field. How do I resolve this?
-
Can I copy and paste an image in an image field from one record to another?
You might have seen in the post "How Do I Split A Table?" that I'm trying to reorganise a very simple database which only has one table and three fields, one of which is an image field.…
-
Calculate quarterly results from two different tables.
Hello. I have a simple database for my business accountancy. The main part is a db of items I buy and seel; this let me calculate the profit and see how it gose on quartely, using the date of sale.…
-
"take picture" ability in the Image field.
The "Take Photo" option in Image field don't seems to work, at least on my iPad ( iOS 12.2, iPad Air)The camera app. is activated but, the lens is not opening, just shows a black screen.…
-
Button Formulas Help
I am creating a stock record database for all the goods stored in our warehouse. I have two fields that I am having difficulty with. I have the first field "Stock (In Single Items)" as that is how…
-
QR printing STOPPED new release
i have QR codes that are stored in image field based on import file (https import.....) since the new release the QR codes no longer print on the print layout
Answer questions and share your knowledge
Top Contributors
Last Month