7 posts in this topic
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.
By Philip Jenks
I have a script trigger in a field inside a portal on 'Layout 1'.
The script goes off to a related table (same file), does some calculations, then returns to Layout 1.
When it returns, I want it to scroll down TO THE PORTAL ROW IT STARTED FROM, so that that portal row is visible and active, and the user can see that the calculations have been done. Some records have 25 lines in the portal, so it’s tiresome for the user if the script comes back and display portal row 1 instead of (say) portal row 16, because he/she then has to hunt for the correct portal row.
My script in the original layout starts:
Set Variable [$ActivePortalRow; Value: Get(ActivePortalRowNumber)]
and then when it gets back to Layout 1, it says:
Go to Portal Row [Select ; no dialog ; $ActivePortalRow]
the choice of portal row being defined as a calculation and the calculation simply being: $ActivePortalRow.
It’s not working! The script successfully returns to Layout 1, but doesn’t go to the original portal row and, in fact, doesn't seem to go to any portal row. I’ve tested by changing to ‘Go to portal row [Last]’’ and that doesn’t work either. It just does not seem to want to take any instruction on 'Go to portal row' at all.
I’ve tried various things. e.g. inserting a step saying ‘Go to Object’ where the object is the portal name. I’ve also inserted a 'Go to field' step, using a field which is inside the portal (and only inside the portal). Again, no joy.
Any know where I'm going wrong?
Newbie here. I am trying to create a remotely hosted FileMaker 11 script that has the following attributes:
1. Imports a folder full of image files.
2. The folder is never the same, it can be a different folder, on a different drive, etc.
3. Need to allow the user to select the folder they want.
4. Do NOT want the user to be presented with any other dialogue boxes, especially Import Field Order, or "Auto enter?" and so on.
I've tried and tried, but every combination of options on the Import script step, in one way or another, does not meet all four criteria listed above at the same time. I can get it to do one-or-the-other, but not all of the above at the same time.
How would one go about this?
using a "count of id" summary field in the enclosing layout/table I can get the current total number of rows in the portal based on the portal relationship. But I have three or four filters defined in the portal so that the portal only shows a subset of this total.
How can I possibly get the correct number of portal rows that are displayed at any time — outside of the portal on the enclosing layout? Preferably in a global field?
I can insert a Record Number Symbol on each portal row that displays the current record number down to the last number. That works fine. But I can't get this value into the enclosing layout/table, whatever means I try.
I could probably use a couple of ExecuteSQL queries (one for each case), but because my filters are quite complex these would be also very complex and cumbersome, especially because SQL treats the data a little bit differently than FileMaker (empty fields vs NULL fields, etc.).
Any suggestions how to achieve this?
Thanks a lot!