Need help with Script please

[vinniebigstick]

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?

[Lee Smith]

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

[vinniebigstick]

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. 

[Lee Smith]

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.

[vinniebigstick]

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 

[vinniebigstick]

I found this post http://fmforums.com/forum/topic/86818-unable-to-attach/

 

possibly this problem is back?

[Ocean West]

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.

[vinniebigstick]

OK ---- How about this

 

https://www.dropbox.com/s/bwpco01534fcxd6/sample%20audit%202%20Copy.fmp12.zip

 

 

[LaRetta]

Hi Vinnie, welcome to FMForums!!

 

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

[bruceR]

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

[vinniebigstick]

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