2 posts in this topic
Select Entire Column
This should be a easy one to answer...
Recently imported an excel file and all of the formatting was off.
Looking at the table, I need to select everything in a field (column) so that I can center every entry in the column. How do you do this?
I tried selecting the top entry, hold down the shift key and then select the bottom entry, but that didn't work.
Lost Data FileMaker Go 12
I'm using FileMaker Go version 12.0.8 for iPad to run a database created using FileMaker Pro 12 Advanced. After collecting several days worth of data and backing up daily with no problems, I suddenly lost a day's worth of data while attempting to transfer the data to my laptop via iTunes. I could see all of the data on the iPad, but after trying to save to the laptop, all of the most recent data I collected disappeared. It's as if the most recent data was never saved on the iPad and was lost during transfer to the laptop. The only thing I can think of that might be related to this problem was an update to the iPad operating system (to version 8.4 (12H143)) that I performed prior to the last day of data collection. Now I am very nervous about using FileMaker Go to collect additional data for fear that the data will be lost. Anyone have any thought about what may have caused this or how to prevent it in the future? Thanks very much.
Printing X number of labels, where X is calculated in a field
I need to print labels for items (products), and the number of labels (copies) for each product is calculated in a field of the database.
Each record calls for a number of items to be labeled with specific instructions for packing (date, location, etc.).
Record 1 calls for 3 items type no.1
Record 2 calls for 1 item type no.2
Record 3 calls for 7 items type no. 5, and so on...
I have duplicated the number of records in a separate database just for printing, but is so tedious (I have to process one record at a time) and is error sensitive.
The databases I work with, generally have between 200 and sometimes up to 2,000 records (or more) per database. And each one can generate from 200 to 5,000 labels (or more), that's why I'm looking for a more convenient solution.
Any ideas are really appreciated.
Portal not behaving (as I think it should)
Hi! I am new to Filemaker, but have done several hours of tutorials and was pretty confident when I started to build a little portal yesterday. Essentially, my portal needs to act as a portal on an Invoice layout, where the user can add a certain quanity of specified products to a invoice list, which is then summed at the bottom.
My first try did not work, but I found a fantastic little example Filemaker Pro file that seemed to work perfectly (admittedly, it was Filemaker 7), but its portal included fields that could be edited with the number of the product, which then populated the price further along on the line, and the user was expected to enter the quantity.
What I need to do is exactly the same, but with materials and components. I think the relationships are the same and I have been very careful in setting them up with a join table between materials and components. But even when I COPY the portal from the example file to my own file, something gets lost and the nice little fields that can be entered data into are not visible in Browse mode (even after I change the table references to the appropriate name).
Would someone mind please having a look at the example portal on the Invoice layout of the attached file, and telling me what on earth I am doing wrong? I have been meticulous in checking that the settings are consistent, but I must have missed something.
(Ok, now this system won´t let me upload the fmp12 file, despite the fact that it is only 246KB in size.) I will post this message and then see if I can figure out what the problem is with the upload...
Need help with an if statement that is not working as I think it should!
I am sure my if statement should execute as 'true', but it is not.
I am on a table called SALESINVOICES. I want to check how many SALESINVOICELINES (ie, the products attached to the invoice) qualify for a special.
My 'If' statement is:
$CorS = "C" and ( SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID = SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount )
where SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID is a summary field counting the total of lines that have flagged as qualifying for the special, and
SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount the found count of products that qualify for the special, and
$CorS is a variable that shows whether a store is a customer or shipping store.
Before this If statement runs, I put a Show Custom Dialog to check whether the fields are definitely giving me what I expect of them.
The dialog box shows:
$CorS & " " & SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID & " " & Count ( SalesInvoices_PRODUCTS|toptenproducts::a_c1 ) & " " & SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount
and the output is:
C 12 12 12
So I believe the If statement on the following line should execute, as $CorS = "C", and the other two fields are identical.
Is there some other problem - will it not work out the summary field correctly in the If statement?
Any help would be appreciated, it is driving me crazy!