Object type File

[xony]

Before all, thanks for your great work.

I try to make a googlemap from a custommer list.
(form= browsing the lists, name of the lists..., subform= custommers in choosen list, name address...)

I have seen a File type in objects but there isn't any file tab.
How does it work.

Is there documentation for the nu database querying (like nuRunQuery...)?

I haven't found (I only begin with nubuilder) a way to make my googlemap works directly on my custommers subform.
I use a button and I run an activity, with a php code as procedure.
I do a mysql query direct in this php code.

When I click the button, it opens an run activities windows, the right I have choosen (record id in button), with googlemap procedure code,
but I must click to the run button to have my googlemap.
Is there a way to called it directly from a form/subform button (/runprocedure.php?x=1&dir=db/sample&ses=14bbd65d1b73ae&form_ses=14bbd65e3b0a8a&r=DEV01)


Thanks.

[steven]

xony,

Hopefully I can answer some of your questions. (not in order)

Is there documentation for the nu database querying (like nuRunQuery...)?
http://wiki.nubuilder.com/tiki-index.ph ... uRunQuery_

I have seen a File type in objects but there isn't any file tab.
At this point it doesn't do anything, in the future we plan to be able to add documents.


I haven't found (I only begin with nubuilder) a way to make my googlemap works directly on my custommers subform.
If you used a form for your customers instead of a subform you could have their google map on a separate tab (as a HTML object).

eg.

cus_detail.png (95.3 KiB) Viewed 4149 times

By creating an HTML object containing the following HTML on a new tab called map

Code: Select all

<iframe 

width="255" 
height="350" 
frameborder="0" 
scrolling="no" 
marginheight="1" 
marginwidth="1" 

src="http://maps.google.com.au/maps?f=q
&source=s_q
&hl=en
&ll=#cus_coordinator#
&spn=0.003545,0.006974
&z=14
&iwloc=A
&output=embed"

>
</iframe>

and replacing ll coordinates with #cus_coordinator# (the string in the Coordinator field on the Details Tab), you can have a google map that refects the specific location of each customer without opening another window.

The attachment cus_detail.png is no longer available

Hopefully this makes sense.


Steven

[xony]

Thanks for your answer, but I don't want to make a googlemap for one client...
I want to have all my selected custommers on the same map.
(in fact if I have to visit one custommer, I can see the other custommers that have an address nearly my cutommer...)


I have a function that reverse address postcode and city of my selected custommers to obtain coordinates
and I make for every selected custommer's coordinate an info marker (on one same googlemap)
with his name, address, postal code, city, phone and a link to go back to individual customer specifications ...

[steven]

xony,
I'm not sure what you're asking,
if its how to put pins in a map, Google Maps API will help http://code.google.com/apis/maps/docume ... rlays.html,
if its how to show a map like this in nuBuilder it would be by creating a more complex version of the html object I showed earlier.

Steven

[xony]

Thanks Steven,

I have created a more complex version of the html based.