I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value.
When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great!
But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
Any ideas how this can be solved?
Spec: Filemaker 9 on window 7 computer.
So I have some columns that need to be combine into one but I don't want to use Concatenation as a field because it creates quotes whenever I copy and paste.
Name = Nick
Field Name A - Nick A (this is produced from entering the name Nick)
Field Name B - Nick B (this is produced from entering the name Nick)
FYI - Field Name A and B must in the same record.
When I export I want Nick A to be first row and then Nick B to be second row is that possible? Right now as it sits it looks like the attached.
We have a solution to store pictures(JPEG and NEF) from a photographer. I am trying to mass import the raw files(.NEF) into containers but I have an error message saying 'This file could not be translated using the selected file type'.
It is possible to drag and drop or File->Insert the file into the container directly but I can't import them from the folder.
Is this impossible to import files from folder with extensions other than the basic ones? (jpeg, pdf, jpg, png etc)
I have a script to import an Excel file into an FM Table.
I have my FM Script setup to Import Records with Arrange by: LAST ORDER.
But it won't do this. Every time I run this script it gets the field mappings wrong. Reverts them back to before.
Ironically when I do it manually it works.
Any ideas? (I have this type of scripted import working fine for other tables)
(I tried shifting the order of the fields in the actual database table as well -- but that has no effect either.)
I am trying to open my (local) FM 14 Pro file [which has an auto-exec "Import Script"] but the script needs a variable file name.
How do I pass this variable file name into Filemaker at 1) the time of the file open or 2) at the time of running the script (if I switch to manual execution)?
Is #1 by using the fmp:// syntax from a web browser external to FM? (or is that syntax just for use when invoked from INSIDE a FM file?)
Who Viewed the Topic1 member has viewed this topic:ash1474