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 but there are some special things. So, we feel we need an experienced Excel person to take care of that.
So, we are looking for recommendations for an Excel consultant who might be able to help us out.
Ideal person is:
-Based, like us, in the UK. US is OK though.
-Able to stick around for bits and pieces as we go along over the coming months (and maybe years). The project is very much a developing thing.
THANKS for any recommendations.
By Little Mighty
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 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other.
I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script.
Does the above make sense, and could it be done via a script?
Thanks for the help - really appreciate it!
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 cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
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 is while exporting.
I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical).
Thanks in advance for any help.
Have a nice day.
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: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe"
But when you run it, it just does nothing
Can someone tell me that I'm doing wrong?
I don't need to import o export a file.
I only need, when i click a button Excel runs and open the .xlsx file
Thanks in advance