Skip 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.

Need help with Script please

Featured Replies

This is my first post.  I tried to attach my file but for some reason I keep getting an error saying "No file was selected for upload"   I made sure to ZIP the file and it's just over 11MB's....any ideas?

Did you also then click on"Attach this File"?

  • Author

yeah...weird huh....not a good start for help when I can't even attach a file!

 

I'll try to delete some of my layouts and possibly if the file is smaller it will work.   I've tested other files that I have and they work so it might be a problem with this particular file. 

The file size when compacted is limited to 50 megs, How big is it now, 11?


Step 1

zip it.

Step 2
Use the More Reply Option 


Step 3
Click on Choose Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

  • Author

yes 11 mb after zipping

 

no luck using your steps.  I can choose the file and then when I hit "attached this file" it gives me the error "Error No file was selected for upload"

 

I'll try another zip program 

you may have to host your own file - using dropbox or some other method and then post a link there is a limit to how large the attachment can be.

Hi Vinnie, welcome to FMForums!! :laugh2:

 

I have downloaded your file.  Please describe the problem and which script you are referencing.

Removed the images from the picture fields (Picture 1, Picture 2 etc) , file size is now smaller and uploads fine.

 

I agree with LaRetta: please provide more detail about the problem.

sample audit 2 MOD.fmp12.zip

  • Author

thank you....here is what i'm trying to do

 

First - I'm new to FM and have been working on and off few a couple months to get this far.   I created the database to be used to perform audits for lighting and controls of commercial buildings.   What you see in "Layout #3" is what i'm using on the Ipad for the data entry.

 

The next step is after the data is collected then working with that data to calculate energy usage / pricing / utility rebate information etc.    What I need to figure out next is how to take the data collected and find the corresponding wattage for each record on the "Wattage Table"   The "Wattage Table" was imported from an existing Excel file from one of the utility companies.    The three pieces of information that I need from my data to find the proper wattage are the fields I have listed in the "Post Audit" table.  "Qty of lamps", "Lamp Wattage" and "Lamp Type".    

 

Right now my "Lamp Wattage" and "Qty of Lamps" fields are numeric and any number can be entered.   I'm thinking what I need to do is first change those to value lists with only the possible options that are available for each "Lamp Type" and enter them in my "Lamps" table.   Then what I need to do is figure out a way to list all of the possible combinations that would be available from those three fields.    After doing that I would then need to list next to each combination the "device code" from the "Wattage Table" to build a relationship.   

 

Am I on the right track?   Any easier way to accomplish this?  Also if this is the way to do is there an easier way to figure out the combinations that exist?  

 

Thanks for the help

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.