Mark Gimpaya

Hello Guys, Can you help me? i am a beginner in filemaker and this is the script i created, i have a script step that finds a multiple record and if found, next step is looping, to compare the value of amount field from one table to another. If it not equal it will update the value. hope you understand guys. thanks

what should i do to update an existing record in a portal/layout, if i also update the connected record from another table/layout

Hello everyone, I am just a beginner, can you help me? In this image, I have the same field for the subject but they are in different semesters. What I want to achieve is to get the total amount of the subject per semester separately, even though they are in the same field. For example: Total amount of the subject for Semester 1 Total amount of the subject for Semester 2 I don't know if this can be done through calculation or a script. Thank you.

Hello, I'm just a beginner. I would like to have a function where it's optional to add a new tab to an existing tab. Is it possible to add a new tab using a button with a script? If it's not possible, are there any alternative ways to achieve this?

hello i am a beginner how to make this in filemaker script. i have a dropdown field for vouchers; ESC, NON-ESC, Public Voucher, and Private Voucher. and i have also a dropdown field for selection of grade/section. the ESC voucher is for grade 7-10, Private and Public Voucher is for grade 11-12. what i want to happen is, if i selected the Grade 11 in the dropdown field for selection, the prompt or a dialog box will appear, it says that i must choose the appropriate voucher for the selected grade

Hello everyone. I am from Philippines and i'm just a beginner in filemaker and I want to ask how to achieve this process I have a record here in 'Books Tab' in portal from another layout . What i want to happen is when i click the 'Proceed' button above, i want to display these records automatically in another portal in also another layout whether it is one record, two record or even more record. This is the layout where i want to display automatically the records of Books and also the amount. I don't have sufficient knowledge on how to do it in Looping. Thank you

I'm so sorry for being rude. Yes, I have a table for Plan and table for Voucher This is Layout A, where I select a Voucher, and the selected Voucher should be applied to only one Plan, where the Voucher amount will be deducted from the Plan amount. This will happen once I confirm the selected Grade/Program from the dropdown field on the right side. And this is Layout B, where the selected Voucher from Layout A will be deducted from the total amount of the selected Plan. Thank you

Please help me i am a beginner I have a voucher selection in layout A, and what I want to happen is that when I select a voucher (ESC Voucher, Public Voucher, or Private Voucher) in that layout, the name of the selected voucher will automatically appear in layout B. Then, the corresponding voucher amount will be deducted from the amount displayed in layout B. What steps should I take to achieve this process? Thank you!

Hello, I'm a beginner. I just want to ask on how to get the ID of a field using PatternCount. I have an Item field that display a record "Tuition Fee" and then i want to get the ID of that record and set it to another table. Can you help me guys thanks.

Here is my table that i want to create a search function. I have a variable field in Main table. and also here is my script. But it is not working. When I search for any text that isn't in the portal, the portal empties. However, when I search for a specific account name, it doesn't appear. What could possibly be wrong with my work here?

how to create a script that finds or search a record in a portal?

Here are my script, but i cant set an amount in second (2) sem. Maybe i am wrong for finding the field for 2nd sem in Else If step that is why it did'nt work Here

I want to create a script that finds a category "Tuition Fee" in a portal and then when i add a subject the summary amount of added subjects will divide into two (2) and then set to the two "Tuition Fee" fields. What i mean is the divided amount will set to the two fields also named "Tuition Fee"

I have an semester field. I want to display a text "required" if the field is empty, and hide the text if the field is not empty

There is a change in the process that we need to achieve. Please help me I'm struggling with the process I want to achieve. Here is the process for setting the amounts in my Plan B: I have a field for the Enrolment Fee with an amount of 715, which I will subtract from the Total School Fee of 21,605. Which is the total difference is 20,890 then it will be divided by 8, resulting in 2,611.25. Let's assume this amount is 2,620. Now, this 2,620 needs to be set for the month of September. Like this: The next step, to set the amount for the month of October, is to subtract the amount of September ( 2,620 ) from the Miscellaneous Fee that has an amount of 3,400. So the total difference is 780. So here's what i want to happen, I want to set an amount of 2,610 for the months of October to May. Therefore, I need to subtract an amount from the Tuition Fee that has an amount of 16,440 and add it to the 780 to make it 2,610. Then repeat the process of subtracting the amount from the Tuition Fee until the amount of 2,610 is set for each month from October to May. What calculation or script that I need to get this process perfectly? Thanks in advance.

Help me, I'm struggling with the process I want to achieve. Here is the process for setting the amounts in my Plan B: I have a field for the Enrolment Fee with an amount of 715, which I will subtract from the Total School Fee of 21,605. The total difference of 20,890 will be divided by 8, resulting in 2,611.25. Let's assume this amount is 2,620. Now, this 2,620 needs to be set for the month of September. Like this: The next step, to set the amount for the month of October, is to subtract the amount of September ( 2,620 ) from the Miscellaneous Fee that has an amount of 3,400. So the total difference is 780. So here's what i want to happen, I want to set an amount of 2,610 for the months of October to May. Therefore, I need to subtract an amount from the Tuition Fee that has an amount of 16,440 and add it to the 780 to make it 2,610. Then repeat the process of subtracting the amount from the Tuition Fee until the amount of 2,610 is set for each month from October to May. What calculation or script that I need to get this process perfectly? Thanks in advance.

Is there an alternative way that does not use repeating fields but still functions the same as the example you provided? "Because we have two different kinds of plans in our system. Plan A is used for full payment, which means the calculation is done as a whole amount. Meanwhile, Plan B is divided into 9 months, but we don't use repeating fields to split the payment into 9. Is there an alternative way that does not use repeating fields but still functions the same as the example you provided?"

Thanks buddy. We'll try that later

Apologies, but I'm not using repeating fields. Are there any other functions that can be used instead of Extend?

Let me revise and clarify my situation. Total School Fees = 16,108.20 Enrollment Fee = 695 Scholarship = 9,050 Total = 6,363.2 The total will be divided by 9 6,363.2 / 9 = 707.02 SEPTEMBER = 707.02 OCTOBER = 707.02 NOVEMBER = 707.02 DECEMBER = 707.02 JANUARY = 707.02 FEBRUARY = 707.02 MARCH = 707.02 APRIL = 707.02 MAY = 707.02 The amount of month October to May should be exact 700 only. So, what i want to happen is the excess amount from month of October to May is will always be added to the first month, which is September. What calculation or function in FileMaker should I use to achieve this process?

I have four categories in my Year Level portal in FileMaker: Enrollment Fee, Miscellaneous Fee, Tuition Fee, and Other Fee. Each one of them has a dedicated amount: Enrollment Fee has an amount of 695, Miscellaneous Fee has 2,194, Tuition Fee has 11,349.20, and Other Fee has 1,870. What I want to happen is to create a plan where the Total Fee of the four categories, which is 16,108.20, will be subtracted from the Entrance Fee with an amount of 9,808.20, and from the Scholarship with a dedicated amount as well. Then, the total will be divided by 9. What calculation or function in FileMaker should I use to achieve this process?