Jump to content

Recommended Posts

VapanPagan    0

A little background

I have a DB which keeps users logins/passwords for a business so they have all their login information for everything at work.

My Issue

I need the user to be able to click a button that creates a random password and places it into the password field when the button is clicked. I am making a button like this for each sections password field. I know I need to make a calculation, I have made these types of scripts before. However, how do I get to a calculation to perform this action with a button in filemaker? I am sure this is so obvious I will slap myself but right now I am at a loss. Maybe I have been working on these 5 solutions too long and need a break. LOL

Any help, suggestions are very welcome...Thank you! =)

Share this post


Link to post
Share on other sites
comment    1,369
1 hour ago, VapanPagan said:

 how do I get to a calculation to perform this action with a button in filemaker?

Use the Set Field[] script step:

Set Field [ YourTable::Password; << some calculation here >> ]

The actual calculation formula depends on what kind of password you want to create (how many characters, which characters to use, etc.).

 

Share this post


Link to post
Share on other sites
VapanPagan    0

So using the set field option will allow me to get to a calculation step with a button? AWESOME! See, I knew it was a simple method, just never had a need to do this before and was not sure. Knew what I needed to do, just not how to get there. Thanks! =)

Share this post


Link to post
Share on other sites
17 hours ago, VapanPagan said:

A little background

I have a DB which keeps users logins/passwords for a business so they have all their login information for everything at work.

This is a very risky proposition from the standpoint of security Best Practices.

  • How do you plan to protect this file from unauthorized access by external users?
  • How do you plan to protect the values in one user's record from being accessible by other authorized users?
  • How do you plan to protect the files these credentials activate from being manipulated and forced open?  That is to say, how do these credentials get transferred to the working files.

The FileMaker Platform has a very robust security architecture developed and refined over many versions and years.  I'd recommend you use that system and the protections it offers rather than some ersatz system.

 

Steven H. Blackwell

Share this post


Link to post
Share on other sites
VapanPagan    0

Mr. Blackwell,

What in tarnation are you talking about kind sir? What does "how to make a button produce a random password" have to do with your security issues. Trust me sir, as a UNIX Network Administrator with a $60k plus degree I am fully aware of and inpose all security measures where needed. Still not sure what this has to do with my question at all...

You are guessing at how I am using this button without having any idea...

Share this post


Link to post
Share on other sites
Josh Ormond    89

In general, storing passwords in a database is a risky proposition. We often run into users/developers who employ such a strategy without knowing how to secure the data. There are several ways to access areas of the file, in an unintended manner. And if the privilege set allows access to the data, the user can get to other records. Also, still many don't use EAR, SSL, or common sense. ( obviously not implying that is you, but it's important that others reading this thread at least have the reminder ).

:angel:

Share this post


Link to post
Share on other sites

As Joshua Ormond points out, keeping credentials as data elements in a FileMaker Pro file is not a good idea.  it can leave the information exposed and vulnerable to extraction by both authorized users and unauthorized users.

Some folks last year developed a somewhat similar system that rapidly came upon a bad end as Josh points out in his BLOG, Eye on FileMaker:

 

Additionally I have discussed some of these same items in various posts on my FileMaker Security BLOG:

https://fmforums.com/blogs/entry/1652-security-vulnerabilities-of-filemaker-platform-api’s-an-update/

https://fmforums.com/blogs/entry/1619-protecting-filemaker-platform-business-solutions/

https://fmforums.com/blogs/entry/1535-the-filemaker-platform-api’s-are-your-friends-right/


Steven

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • By enquirerfm
      I'd thought I'd solved this but looking at the background data it's not calculating properly. Any ideas much appreciated.
      I have a file with a date, bottle format, total cost and converted cost for larger formats (so, for example, 75cl might cost $20 but 1.5l costs $45. The converted cost of the 1.5l is $22.5). Assuming one beverage and just one bottle of each, I want to output a report which looks at the costs and converted costs over a specified period (eg 1/1/2016...12/31/2016) and outputs a 'premium' for, say, the 1.5l bottle.
      In this example, let's say I have 6 records:
      date1 75cl $19
      date2 75cl $19.5
      date3 75cl $20
      date4 1.5l $43
      date5 1.5l $45
      date6 1.5l $48
      Then searching between date1...date6 would give etc.
      However, it is not working out the totals correctly eg it is not calculating the premium properly for the 1.5l format - it appears to group all of the values together.
    • By Cynthia Heyman
      I have a layout where it shows a Person's information (name address etc), and it includes a Tab Control that lists all the dogs that are related to (owned by ) that particular person.
      I want to be able to click on a button that allows the user to add a new dog that is connected to the person showing. I have a Dog Details layout, I just need to pass the person key/information to the Dog Details layout so the dog is automatically added to that person.
      I've attached a screenshot of the Person Details layout with the Tab Control, and the Dog Details layout, where I'd like to have the Owner field automatically filled in when added a new dog.
      In my button control, I've tried a Single Step and the Go To Layout, and adding the Optional Script Paramater, using the Primary Key from the People Table, but it doesn't seem to be working.
      I'm very new at this and I'm sure there is an easy solution for those experienced users.
      Thanks!
      Cynthia
       


    • By rick altman
      I am creating an app for a conference. Each seminar is assigned a code -- such as 101, 102, 103, etc. -- and the app will automatically create signage and displays for us. One of the services I want to provide is to tell people not only what seminar takes place right now, but which seminar will be *next up* in a particular ballroom. I have created a field called Next, into which we would enter the code for the seminar that takes place next, but that's as far as I have gotten. How do I automatically gather the information?
      For instance, let's say that Seminar 101 is entitled "How to Think," and is being led by John. Next up in that room is Seminar 103, entitled "How to be Great," led by Jane. I want to create a calculated field that would be part of 101's record that would automatically pick up title and speaker from 103's record.
      How would I do that??
    • By dezkev
      In Matt Petrowsky's video on all things new in Fm 16 , the very first new addition is a new calculation workspace where we can see the results of our calculation. i.e. there is an additional pane in the work space where results can be previewed.( see attached pic).
      I can get to this workspace from the Data Viewer , but when I try to get to it from Define Fields dialog box, I just get the regular calculation workspace.
      What Gives ? Why is it not everywhere ?
      Thanks.
      kevin
       

    • By liamob1
      Hi, 
      Got a real strange issue....
      My button bars look fine, slightly offset, but fine on the desktop version... But as soon as I look on FM Go, one of the text boxes just floats away? - I have tried moving it around and changing the size and i just get the same issue but with different buttons? 
      See images... 
      Thanks


×

Important Information

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