WF7A

Export with filename

2 posts in this topic

Howdy, all:

I'm looking through the documentation and the forum here, but I can't see a way to export records using a scripted filename in FM Go. If I'm not mistaken, it only allows you to use the file's name.

What I'd like the user to be able to do is fire a script that exports a table's records using the table's name as the filename.

TIA for your help!

Share this post


Link to post
Share on other sites

You can set the $exportPath and give the export file any name you wish.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • By Wickerman
      I have a nifty little backgammon quizzing solution set up for FMGo that shows images of game positions and you tap on the image container to view the solution  below. This works by toggling a simple text field from empty to 'Show' when you tap the Problem image.   I've used the calculation  IsEmpty ( Positions::z_SolutionToggle ) in the 'Hide Object When' option in the inspector for three items on the layout:  A Text Field giving the simple answer, a Container Field with a picture of the proper solution, and a Web Viewer for displaying comments about the proper play. Tapping the Problem image toggles the control field empty again, hiding the 3 items.  I have an 'On Record Load' script trigger set up to clear the toggle field so when you go to the next problem the answers are hidden.
      All three items work just fine in FMP my desktop.  On the iPad in Go, however, the Web Viewer is glitching in a particular way.  The tapping to show/hide works fine - - but if I have the answers revealed and tap for the Next problem, the web viewer fails to Hide itself, while the other two objects hide  as expected.  The data in the web-viewer *does* update to the text for the fresh problem -- it just doesn't hide itself.  The other tw items vanish, but it stays there, displaying the new comments.  Tapping the Problem pictures toggles the other two items into view as planned, and another tap hides all three, and moving to the next problem, they all remain hidden as intended, so it is only when going frrom the Revealed state to the next Hidden state that the web viewer falls down.
      The contents of the web viewer are drawn from a text field using this data URL I gleaned from a thread where web-viewers were offered as an alternative to fields with scrollbars in GO because scrollbars don't work so well in GO:
      "data:text/html," & "<html><style>*{ font-family: arial, verdana, sans-serif; font-size: 16px;}</style><body>" & 
      Substitute ( GetAsCSS ( Positions::Comments ) ; "¶" ; "<br />" )
      & "</body></html>"
      I have the 'Allow Interaction' and 'Automatically encode URL' boxes ticked.
      Any suggestions for fixing this bug?  Thanks!

    • By IT_User
      I have already posted here:
      https://community.filemaker.com/thread/170677
      and have some thoughts in mind, but I will copy what I put in there, here.
       
      Avoid FMGo Connection Interrupted
      Server Timeout Disconnect
       
      In the attached links, it goes back to questions that I had that dealt with a file on an iOs device, making sure it stays live and up to date.
       
      So what I have done is worked on a local file that syncs to the one on the server.
      That seemingly works, however there is a problem that just recently came up when I was testing. When the local file tries to reach the file on the server, it doesn't always connect.
      In talking with others there is two consensus of what might be the cause:
      The Wireless access point is blocking access File security permissions are not working (File Access tab in Security) "Reset All" temporarily works (on the server file) Deauthorizing and Authorizing sometimes works (on the server file) Turning off the File Access requirement doesn't seem to help (on the server file) I do have File Access on the local file, but I haven't tried turning that off.
      Since I can't debug exactly what is going on, on the iPad this makes it harder. (I have put in some custom dialogs to see some things.)
      The local file with the syncing to the server file works on my desktop, but that is a wired connection. (I could try the same wireless connection.)
       
      It could be that I'm making a duplicate of the local file and putting that on the iPad, which makes the file not work.
      (I put on the duplicate file on the iPad newly each time for testing, because I need a file without certain info on it, which will be filled later [dealing with Get(PersistentID)].)
       
      Is there something I'm not thinking of?
       
      To my knowledge, it had been working until recently.
      I'll try a few more things, but hopefully get answers in the meantime.
      Thank you
    • By Wickerman
      I'm revisiting a Filemaker Go solution I put together a few years ago where I implemented a clumsy workaround for a problem I couldn't figure out.  I have a database that stores ARTIST records and child ARTWORKS records, and I have a layout with a bunch of searchable fields drawn from both tables so that the user can search for, say, American (Artist field) & Watercolor (Artwork field) 
      I'd like the user to be able to specify whether the Find will display a list of ARTISTS (American watercolorists) *or* ARTWORKS (Watercolors by Americans).
      Currently, I have two buttons on the layout, so when the user enters his search terms, he taps the appropriate button and a script takes him to a layout with the appropriate context and results (I put a Script Parameter on the Find Artists button).  This works okay, but it is really inelegant and non-intuitive, because in Find mode the Keyboard is on display for entering the search terms, including a big blue irrisistable "GO" button that invites the user to execute the search -- which is of course not going to do what I want it to do.
      Is there a way for me to use a Script Trigger that would intercept the Find action and perform my branching script instead of delivering the native Find based open the current context?  I haven't been able to figure it out -- perhaps an OnModeExit? I've gotten kind of confused about what happens to the search result and when a script might intervene.
      An alternative is I suppose I could just give the user a choice of two layouts to go to depending on whether he wants to search for Artworks or Artists -- adding a step to the search process.
      Suggestions?
       
    • By canton
      I'm having issues with FM Go 15 crashing when I try to enter data into a portal.  It closes FM Go and does not save any data that has been entered that day.  There is no pattern to it and sometimes it does not do it at all.  I've tried deleting the app and reloading as well recreating my FM Go file, but still no luck.  Has anyone had similar issues?
    • By canton
      I have been using FM Go on iPads for a few years for gathering field data for wildlife research.  We collect genetic samples and they are enclosed in an envelope that contains a barcode for easy entry.  It has worked perfectly until I updated to iOS 10 and FM Go 15.  The barcodes are type codabar.  Any ideas on how to fix this?