Re: AW: Multi-Select Dropdown Menu

[Scott Staley via 4D_Tech]

Oliver,

This is a bit off topic but a few years ago you shared a DataBrowser tool
(user mode replacement) that included your utilities component.  I just
wanted to note what a delightful tool that it is.  Many valuable routines
but also I was able to pick up several programming technics that I wasn't
aware of.  This turned out to be probably the most valuable resource I've
come across in my days of working with 4D.  Thanks again for making it
available.





--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

I found a few knowledge base tips regarding the use of JavaScript to
manipulate SpreadJS (the backbone of View Pro) 
https://kb.4d.com/assetid=78395 for example.

I also found the following on the SpreadJS website.

 var spread =
GC.Spread.Sheets.findControl(document.getElementById('ss'));
var sheet = spread.getActiveSheet();
sheet.options.protectionOptions = {
  allowSelectLockedCells: true, 
  allowSelectUnlockedCells: true,
  allowSort: false 
};
var option = sheet.options.protectionOptions;
   console.log(JSON.stringify(option, null, 2));

I'm going to see if I can figure out how to set this from within 4D.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

Doug,

Thanks for the advice.  I've used excel since it was created back in about
1984/85 but wasn't familiar with the underlying file structure of a current
excel file.  Just opened one with BBEdit.  A lot more to it than I thought. 
I'll see if I can figure out in the file structure where the protection info
is stored and see if I can do anything with it.  I would rather avoid a
separate plugin for this one issue.  View Pro is somewhat surprisingly
working very well for what I need.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

The subject pretty much says it all.  Anyone know how to tell View Pro to
programmatically protect a sheet.

fyi... I basically have an excel template that I import into View Pro and
then populate with data and save it back as an excel file.  The excel file
is then given to others that populate other parts of the sheet.  I would
like to turn the sheet protection on so that the data populated by 4D and
any other protected cells are not accidentally modified.  If I protect the
sheet in excel, than I can't use 4D to populate the protected cells.  I
generate several hundred files so I don't want to do it manually.

I'm using 4D v17 R6

Thanks in advance for any suggestions...



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Picture variables in object notation

[Scott Staley via 4D_Tech]

Ok... many thanks.  

Helps to know I'm not just screwing up.

I like how object notation cleans up/organizes code a bit but it's getting
confusing to figure out when to use what (ie. variables or arrays or
collections or objects) and the syntax of some of these seem pretty
temperamental.




--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Picture variables in object notation

[Scott Staley via 4D_Tech]

I’m trying to switch various variables to objects and object notation.  I’m
having some difficulties using object notation with picture values with 4D
methods that accept picture variables.  See below…


The following…

 SET LIST ITEM ICON(sBar_RecordsSelect;1000;o_Images.sidebar_All)

Results in an error:  “4D was expecting a table or a pointer”


However, the following…

 $i_sidebar_All:=o_Images.sidebar_All   
 SET LIST ITEM ICON(sBar_RecordsSelect;1000;$i_sidebar_All)

Works fine


I’ve also tried the above objects using string with bracket notation.

Another instance of it not appearing to accept picture values from objects
is when assigning a picture object value to a button variable in the
property list. It appears to be ignored.  

Using: 4Dv17R6 

Perhaps someone can tell me what I am doing wrong.
Thanks in advance...





--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Re: 4D v17r4 Windows Print To PDF ignoring PAGE SETUP

[Scott Staley via 4D_Tech]

I am also having a similar problem...

Code

   SET PRINT OPTION(Paper option;$t_Paper)
   SET PRINT OPTION(Orientation option;$l_Orientation)
   SET PRINT OPTION(Scale option;$l_Scale)
   SET PRINTABLE
MARGIN($l_margin_Left;$l_margin_Top;$l_margin_Right;$l_margin_Bottom)

   PRINT SETTINGS

The scale (50%) and margins (varies) are being respected but the paper
option (legal) and Orientation (landscape) are not.  

I've set the form page setup with the correct settings.  I've also set the
Print Settings in the property list.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Linear Regression Graph

[Scott Staley via 4D_Tech]

I use google charts to do trendlines...

https://developers.google.com/chart/interactive/docs/gallery/trendlines

Also, 

Excel can do trendlines as well so there is a good chance that View Pro can
do them.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Complex graph

[Scott Staley via 4D_Tech]

I don't and I actually created the graph in microsoft excel and then opened
it with view pro.  The data for the chart is on the spreadsheet behind the
chart and is hidden by the chart.  You can also hide the toolbar so that the
only thing that is visible is the chart.  With 4D you can update the data in
the cells.  There are several tech tips/notes that demonstrate how to
manipulate view pro cells from 4D.

I'm not very familiar with View Pro or the tool it was developed from
(SpreadJS, a javascript spreadsheet API) but one thing that I see that
hasn't been talked about much is that it brings many if not most of the
charts/graphs that are available in excel to 4D.  I tried a 3d bar chart but
it came across as a 2D version so I know all options are not supported but
given the limited graphing available in 4D this seems like a big deal. I
personally do most of my graphing in 4D using Google charts API but am glad
to have more options and the ability to print the chart.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Complex graph

[Scott Staley via 4D_Tech]

I was able to make the linked chart in View Pro...

Link to:Chart
  






--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: [BLOG] Something new in my Blog : Exporting Listboxes the easy and powerful way

[Scott Staley via 4D_Tech]

Hey Alex,

I had a chance to try out your exporting component.  Works slick... much
appreciated.

I already have some of the features and abilities built into my dbs but your
implementation is much better.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Collections in v16R4

[Scott Staley via 4D_Tech]

I saw that in the 4D Blog this morning.

http://blog.4d.com/new-type-of-variable-collections/

I've not yet come to grips with objects.  This seems like something I can
get my hands around.

I also saw the new SDI mode for windows.  My first reaction was... eehhh,
its a windows only thing and I'm a mac guy.  But I looked anyway and it
turned out to be something I was very happy to see.  Getting rid of the 4D
background window. In my opinion, 4D generally looks inferior on windows and
this will be a big help.

http://blog.4d.com/4d-introduces-sdi-mode-for-applications-on-windows/




--
View this message in context: 
http://4d.1045681.n5.nabble.com/Collections-in-v16R4-tp5753225p5753226.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Datatables Tips

[Scott Staley via 4D_Tech]

Thanks for the Tip.  

I haven't tried using Jason formatting but I've recently been introduced to
Bootstrap and Datatable  and am pretty much thrilled.  

I've struggled with ways to get my 4D data on the web and these tools have
turned out to be the answer I was looking for.  I was introduced to
Bootstrap by a comment on this mailing list about a month ago.  Probably
unlike most on this list, in my case I don't need a live link between my
data and the web.   I just need to provide it in a kiosk type format and
update it around monthly (project status reporting).

I'm not a web programmer and I was struggling with using web creation
software or trying to hand code which I'm not trained to do.  I looked at
several apps including, Blocs, Espresso, EverWeb, RapidWeaver, Sparkle and
Dreamweaver but in all cases making a simple table turned out to be a
struggle and the code generated was pretty convoluted.  I was able to make
much better formatted and cleaner coded tables by hardcoding but it became
time consuming.  

Bootstrap provides kind-of an in-between option that let's you hardcode but
simplifies (handles) most of  the formatting including resizing between
desktop and mobile sized screens.  Datatable provides the database features
such as searching, sorting, pagination, etc... so I don't need to link 4D to
the web.   Automated page creation is accomplished with 4D tags.  

I noticed in the examples on the dataTable web site that you can format the
page and data separately using Ajax format and wanted to give that a try but
haven't had a chance.  This may be more like the tip you provided.  As with
web development I don't have much experience with Jason formatting but I'll
try out your tip and see if it can help simplify my web development.

Others on this list are probably already aware of datatable and bootstrap
but for anyone who isn't I wanted to pass on my appreciation as well for
these resources.

Thanks again for the tip...



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Datatables-Tips-tp5752751p5752756.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Controlling the Menus when executing the EDIT ACCESS command

[Scott Staley via 4D_Tech]

I’m having some difficulties with menu management when converting from
version 13 or 15 to version 16.  

My problem is that in version 16 when I execute the EDIT ACCESS command I am
presented with the Design Menu.   In earlier versions I am able to manage
the menu’s and when I execute the EDIT ACCESS command the menu displayed is
the menu I set prior to executing the EDIT ACCESS command.  In version 16 it
replaces my menu with the Design Menu.  Most features in the Design Menu are
not executable (if dimmed or not).  

I’ve not seen any comments indicating others are having this issue so I
recreated a simple database with one method and one form and was able to
replicate the problem.

Any suggestions on how to keep the Design Menu from showing up when
executing the EDIT ACCESS command would be appreciated.




--
View this message in context: 
http://4d.1045681.n5.nabble.com/Controlling-the-Menus-when-executing-the-EDIT-ACCESS-command-tp5752037.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Google Address Lookup/ Autocomplete

[Scott Staley via 4D_Tech]

The 4D method user group did a presentation that included an address
validation app using google maps api.  The url to the website page that
includes the 4D sample database is shown below.  

 https://4dmethod.com/2015/07/08/next-meeting-july-30-priority-mail/

fyi... The sample database uses a key code that has expired.  Google now
requires a key code to access their apis and so you will need to get a valid
key code to use the sample.





--
View this message in context: 
http://4d.1045681.n5.nabble.com/Google-Address-Lookup-Autocomplete-tp5751116p5751117.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D v15r5 vs 16

[Scott Staley via 4D_Tech]

Randy,

I've had several issues with both 15 R5 and v16 (I don't have access to 16
HF2) and am therefore currently using v15r4 (which is certified for most
systems).  I don't remember all the issues but I know I had several problems
with menu management.



--
View this message in context: 
http://4d.1045681.n5.nabble.com/4D-v15r5-vs-16-tp5750911p5750914.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Scott Staley via 4D_Tech]

Keith,

A gentleman by the name of Flury Olivier offered a databrowser component to
this mailing list a few months back.  Here is the link to his thread.

  http://4d.1045681.n5.nabble.com/Databrowser-component-td5740863.html

The databrowser component includes another component called FSUty.  It is a
package of utilities that he uses to support the databrowser and I assume
other databases as well.  The utility component includes a group of listbox
methods and one of the methods called UtyLB_SelectionToText will copy a
selection based listbox into a text variable.  From there you can just
execute SET TEXT TO PASTEBOARD($t_theData) to put the text variable into the
clipboard.

The components can be downloaded from the above link.



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Copy-or-Drag-from-a-listbox-tp5750587p5750601.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Has anyone been using the V16 menu editor?

[Scott Staley via 4D_Tech]

I recently tried to make a jump from v13 to v16 but abandoned the effort and
went with v15.4.  I ran into several issues that work without problems in
v15.4.  Some menu issues was one of the problems (ie. when calling edit
users I would end up with the design menus and when my window management
menu would not properly check the correct item as being the front most
window.)



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Has-anyone-been-using-the-V16-menu-editor-tp5750465p5750471.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Typeahead Component

[Scott Staley via 4D_Tech]

Hey Oliver...

I'm very quickly becoming a big fan.  Appreciate your many contributions to
the community.



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Typeahead-Component-tp5750404p5750410.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**