Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Export to Excel and FMP Go Support

Featured Replies

Afternoon everyone,

Ok.. got a good one for you guys. My project is displayed on the iPad for my users. The file is housed on a Mac using FM Server Advanced 8 (i know...need to upgrade)

I want to export information to an Excel file from a script on the iPad to one path, but use a variable name.

I have the script finally grabbing the data that I want, now I want to export it out to Excel. I have a script built that is the following:

Set Variable [$filename; Value:request_db::_request.customer.info & "_" & Get (CurrentDate)]

Copy (Select; requests_db::_k_id_unique.request]

Go to Layout ["ink" (ink_db)]

Enter Find Mode []

Paste [select; ink_db::_k_id_unique.ink]

Perform Find []

Save Records as Excel [Restore; "$filename & ".xlsx""; Auto open; Records being browsed]

Show All Records

Got to Layout [original layout]

So here is the problem... the path in the Save records is my issue... if my file is hosted by FMP Server Advanced on a Mac... how do i get it to save to a shared volume on my network?

Remember.... triggering the script from an iPad... so those users can want to grab the file later, not pop up on the iPad....

1. Is this possible?

2. If I set the criteria to attach to an email instead... is that possible from the ipad?

3. How do I properly script the path in this situation if I just save the file to a location, not emailing...

4. Is my script antiquated and full of fluff I dont need?

Ok... i think that is all...

Thanks for any and all advice.

Blake

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.