emtau

Thanks comment and bcooney, you right, its just the matter of right clicking the script and choosing "Grant Full Access Privileges". For security measures, I just assign no access to other users to this script except the one who's gonna use it. Thanks again.

Is there any way I can assign a user (non-administrator) to create other users? I want to keep the admin account, but I want to allow a certain user his role to create other user accounts and not giving him the full admin right? I have a working script to create users but it seems to be ONLY working when logged in as an Administrator. I was just wondering if it's possible to just allow this privilege to a non-admin. Thanks.

Thanx Matt for the steps provided. If it works, then that's great!! I will definitely try it. In the meantime Im still looking for alternatives. I was hoping for a faster/easier step that doesn't rely on other external utilities/software or timings... maybe a filemaker plugin?

I was just wondering if there is a way to set my image container field to launch the webcam on my PC and capture the image (take photo) instead of manually inserting a photo? If there is a way to do this I would appreciate it if you could tell me or point me to where I can find the solution for it. Much appreciated. Using Filemaker Pro 18 on Windows 10 Pro

You're right, I've decided to just put it blank, since the layout is gonna be printed anyway he/she (Office Manager) can fill in her name manually and sign it since she can also be temporarily replaced by other supervisors if he/she did not come to work that day. Thank you for you help and I will also consider your suggestion (calculation etc..) for other requirements I might need. Very much appreciated.

There can only be 1 Office manager at a time... but in time he/she might move to another office or resigns and be replaced by a new Office Manager. We don't want to delete records and so we mark them as ex-officers by putting another date field where he/she left office... this applies to all employees.

I think I get what you're trying to say... but I'm a bit confused, first of all I never knew about the self-join relationship so thanks for pointing this out. Admin officer is "Office Manager" to be exact and it is from a field called "Job Title", this field is also populated with other Employees like IT Specialist, Accountant, Registry Clerks, etc... So if you look at the layout provided... John Wick is an Assistant IT Specialist (from "Job Title" field) and I want the Admin Officer to be the Office Manager also from the "Job Title" field.. but I don't want the job title to be shown I want the Employee's name. I've created a simple small sample filemaker file of what I meant which I'm sure you understand already, I'm just a bit confused on how the same field will work on this... if you could please help me out just demonstrate on the sample file how that would work. I hope I will never bother anyone again about self join relationships. Thank you. selfjoin.fmp12

so on this record... I want to show another value from another record if that other record meet the requirement. please check picture and I'll explain more... So the picture shows the record of John Wick... Under Admin Officer I want to put the name of the Admin Officer which is another record on the same table, but the record/user needs to be assigned a job title as Admin Officer (like John Wick job title: Assistant IT Specialist) in order to automatically put his/her name in the provided "Full Name:" spot. I tried creating a new field calculation field to put there but I'm lost what to calculate... I'm thinking, if user = Admin officer, get his name.. that's what I'm thinking hehe sorry. Would really appreciate your help on this Thank you.

Thanks for the tip.. I'll try that

So I want to create a button that will open up the sorting window... but instead of showing all the options for sorting to the user, I want to limit what is shown in the sorting window to a specific table with only a few selected fields to be available for sorting... instead of showing everything. Is this possible? what is the best way to do this? Thank you.

Okay thanks I've decided to just leave it as it is and get rid of the "Remaining balance" summary on top. Thanks a lot.

I do have a list view report where a user can use the "Leave" button to filter Print/View just a single type of leave for their perusal.Check picture below; But out of convenience I would like to make it easy for users to just view their remaining balances where "Remaining Balance" is as I mentioned.. instead of clicking few buttons to get to see the whole summary report when they could just see it beforehand if possible. Can I get those last leave balances on the User Profile layout (Where "Remaining Balance" is)? If not then I will just leave it like that. Thank you again. I don't want to show it in the portal... the portal shows it btw but rather mixed up with other leave types and previous leave records etc... I want to show it in the User Profile table just right above the portal check first picture.

So I have a Table "Daily Leave" related to "User Profile" table. I created a "Daily Leave" portal on the User Profile layout and started adding other fields to this portal; Year, Type of Leave, Leave Entitlement, start leave, resume work etc... please check attached picture. So the Leave Type field is a popup menu which let you choose the type of Leave you want to take e.g. Annual Leave, Sick Leave, Compassionate Leave, Leave without pay or Maternity Leave. So based on the this field "Leave Type" I want to show their last "Balance" like shown in the picture. I am able to show the Annual last balance which is 16 but its only because it is the last in the list so if I add a Sick leave after that it will change and not stay at 16 since Sick Leave has a different remaining Balance than Annual leave. So how can I do something like that? Show only the last values of the "Balance" field based on the "Leave Type" field? Thank you.

Thank you for clearing this out.. so you can do it in-directly using the method below. I have a lot to learn. Thanks a lot... its exactly what I need.

Greetings, So I have a date field which contain lots of date records. I want a button to perform a script to find only dates for this year only on the mentioned field. I am having difficulties trying to Specify a Find Request on what criteria to put.. I can easily put 2020 as a find criteria but I don't want to do this every year, so I need something like "Year(Get(Currentdate)" as a find criteria but it won't allow me giving me the error "The Value of this field must be a valid date in the range of years 1 to 4000 and should look like 25/12/2013". So I guess my question is how to put the find criteria as today's year? How can I do this?