Jhon Doe

Yes, sorry about it, i realized that after made this post, i'm going to check your idea, thank you for your help.

Yes, that's Right, but there is a difference, instead of services table, is a contract table where the services are describe, so each client could have many contracts but one contract is only related to one client. Each contract has an ID and boolean fields for services acquires. This is the part I could filter, identify the clients who have certain services.

Thanks for your answer. Saddly I cannot share the file with you, the fact is that i want to show in a portal tickets related to clients that have specific services. I create a self join on Services to filter the clients who have some services but I cannot connect these results with the tickets database, how can I do that? The idea is put a lot of portal with different criteas, so i discarded the idea of create a script.

Hi, I hope you having a wonderful day, Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one: There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships: tickets DB ------ Clients ------ Services (I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join relationship of Services to filter those clients who have the services i want to filter, next, i put this relationship into a portal in a layout based on the Services database and it works, but if i put into the portal a field related with the client's name, the portal doesn't match the results of the self join relationship whit the correct client, neither with the tickets that it supposed are related with the results of the self join relationships, how can I created a query in Filemaker taking into account more that one database? I made the self-join in the manage/database/relationships menu.

Hi everyone,i have an issue, maybe one of you could guide me, I have grouped a set of records into a portal (it could be more than 1000 records), each row has a pop-over button that display some actions over the record, but the popover is too slow when i try to open it, does anyone know the reason of this behavior? how can i solve it? Thanks, Jhon

yes, I was on mistake that was the first thing I thought because i didn't realize what the error was.

Thank you once again, I've seen what was my mistake, you have to remove the line : data:image/png;base64 !!!!

sorry for my explanation, yes you right i've done that, but I want to show the image itself, and with this code, the container shows me a png icon and not the content of the text field containing base64 encoded image data. I don't know whether I 'm doing something wrong when I pass the data to that command or my data in base64 is bad encoded or damaged. Base64Decode ( YourTextField ; "name.png" ) Thank you for your help, I've figured out a way to resolve this problem, I've save the images that i need to show directly in the container field without use the text encoded in base64.

Hi, I tried that code Base64Decode($(ImageInBase64),"name.png"), but since the $(ImageInBase64) is an image in base64 the container only shows me a "?" image.

Hi everyone i'm new in filemaker, i'm using filemaker 17 and currently i'm involve in a proyect but i have a problem that i can't resolve, maybe someone of you have had the same problem. I'm saving images in base64 format in a database to show them in a layout with web viewer,that doesn't has any problem, the problem is that i'm using a portal and i didn't know that portals don't support web viewer. I have to display those images but i can't remove the portal since i didn't do that layout and it has scripts using it along with the portal, is there a way to show images saved in base64 without use web viewer? (I've already tried to use container field but it only show a "?" image 😓 ) My English is not the best but I tried my best ,Thanks for your help

Thank you for your help bcooney, let me see if i understand, you're telling me that i have to be sure that the cvs file has to have a field that matches with the "parent" table in order to related both tables?. I'm going to check it and i will tell you how it is going.

Hi everyone, I'm a beginner in FM, and i'm trying to develop a solution that allows me to import data from a csv file. I have two related tables Customer ("parent") and Alerts ("child"), each one has a primary key and the Alerts table has a foreign key to conect with the Customer table. I have to populated the alerts table from a cvs file that could have lots of records so I want to relate this new data to the right customers automatically when i import it, the new data does not have a field with the customer ID (primay key) only has its name. Could you please give me any advice with that?