Search the Community
Showing results for tags 'excel'.
-
Hello I run into an issue with a a container and the navigation: we have a documentation of cases, and in that we carry PDFs, pictures, Word and Excel files (plus some others) There is a button to open the attached file. While it works with all tested format, it doesn't for .xlsx (.xl...
-
Hey everyone, Just looking to see if anyone has come across a good solution to for this. I have a set of records with multiple fields that I need to export to Excel, I'm exporting via script and everything works great with the exception of one of my fields "columns". This field has a... -
Hello, I am trying to get Scribe360 to import time values (e.g 08:00) from Excel to Filemaker. In Excel the cells are formatted as hh:mm. In Filemaker I have defined the field as time but instead of getting 08:00, I get 00:00:8 which is wrong. In addition, when I try and format the fi...
-
Gents, there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved? Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option. pr...
-
New Major Version Release: Scribe 4! We are excited to announce a new major version of a popular 360Works plug-in, introducing Scribe 4! 360Works Scribe is the ultimate document automation plug-in for FileMaker; it allows integration with Word, Excel, and PDF documents. In this releas... -
I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child. For Inst... -
I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker. Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked! And woul...
-
Unfortunately, the EXCEL data storage within xml-files is very complex, and as noted by others, it is virtually impossible to handle complex (and even very simple) data without the program EXCEL itself. I just discovered a new CAVEAT relating to the scribe plugin. Reading an EXCEL document with Scri... -
Dear 360 Works Team In our FileMaker Solution we want to create an Excel report including text, numbers (dates) and images via Scribe. The FileMaker export of text and numbers works fine. But we have a problem with the export of images in the xlsx. After the Creation of the Exc...
-
Hello, we use your plugin Scribe for editing Excel files in our Filemaker solution. Since a few days we get an error message when calling the method "ScribeDocLoad" (see appendix) for newer Excel files. Older Excel files from the beginning of 2018 are not affected. So we wanted to ask if...
-
Hi, I am going to be doing a mini project with FileMaker where an excel sheet is going to be distributed to bidders for some work. My plan is to then import the data from completed spreadsheets into FileMaker using Scribe. The Excel sheets aren't going to be the most complex Excel ever...
-
Hi Guys I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards. I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2... -
Hey Guys, Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue) My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I ca...
-
Hi there, I am making cutom import and export from/to excel documents. Is there any way to merge excel cells in scribe? I can easly find out which fields are merged when importing. two nested loops and if second col or row is empty while reading i consider it merged. Problem...
-
Good afternoon everyone. I need to open a .xlsx file by pressing a button I have tried with a script, where I establish a variable $ filename = e: \ Works \ Josram \ Presup \ AAVSA \ slopes 345 7 Apr 14.xlsx And using the command "Send DDE Execute" The service name = "c: \ Progr...
-
Hi There, First of all many thanks to creators for amaizng plugin. What is the syntax for inserting images to excel? ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) Do not work for xlsx with error about invalid cell name (first param...
-
I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample: Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"... -
I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script: Perf...
-
I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores). Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records The fields in the 4 Tables have different names and contain similar...
-
I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK. However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Gr... -
I recently imported records from an excel sheet into my filemaker solution. I just noticed that the dates in the excel sheet were entered in this format 1996-04-19 and as a result, all my date calculations are not working. For example, the Age and other functions. Manually changing the date to... -
Hello, I have a small problem before importing an Excel file in Filemaker As I run a macro on Windows all goes well the work is done corectement to use the file to import into Filemaker But on Mac that does not work I tried with several Excel and of course Windows Excel for Mac I th... -
Hi All, Sorry if the title is a bit confusing, I wasn't sure how to explain it. Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters) the problem...
-
So the company I am working for just picked up a huge contract with a cruise line, where we are going to be surveying some of their hardware and other equipment, guess who has two thumbs and is the lucky son of a gun to make the database for this project? This guy! Anyways, I can't really go int... -
Hi I’m new in Filemaker, but I see lot of advantages using this solution. I have two similar excel one is work schedule and next one is order schedule. I would like to have them in FM. My problem Is to build database which keep the visual and functionality of excels WORK SCHEDULE: The...
