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
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 parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample
I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image.
Thanks in advance.