ibobo

here is the monitor activity and i see webviewer page "about:" who s is kept in memory, how I can I flush it ?

Hi everyone I have my database with 40 000 links, i extracting data very simple. I m using MBS mostly. When I open FileMaker fresh I have 5go of memory free, then slowly slowly after 1000 records I have only 500mo left and more it goes less it works properly (miss fields, unresponding) So I have to quite filemaker then open the database again to reset the memory. If I just close the database the memory is still low, but if I quit filemaker then it reset the memory and are full. I do not know where it come from, I used many time's such pattern to load web viewer and extr

Hi, I have a 3 field, Color, Size, and List3, some words are in English so I made a list of all unique values of all three table, translate it, then past in to a table with field English (original word) and French (translated) what I would like is match at those three field with field in table where all words are already translated. for exemple Product table Record 1 /> Color ; red - Size ; eleven - List ; proud Translated table Record 1 /> English ; red - French ; rouge Record 2 /> English ; eleven - French ; onze Record 3 /> Englis

as easy as that :))) thank you so much ! have a great day

Hi, I am extracting data (script loop) in to a portal, then make some calculation and summary fields to make calculation. So first I loop, extract data, calcul data, then I summary it, then I make another calculation based on previous steps, next loop, and so on. Problem = When I loop the extraction I can't see the result of some calculation until i cancel the calculation scrip and click on a random grey space. How can I do to get the results during the loop and not when I cancel and click somewhere. Also if I leave the layout and go back I ll have all result as needed, but I need it during

I see, so each currency in a table, linked by same time, then use summery part to sort group of for exemple 24hours for every hour thank you Steve and Comment ( I always come with weird ideas but trust my it worth it 🤠 mostly ..)

can I use summary field and select only 20 records without using find mode ? or it will select only all records ? or I have to use find 20 records to see the summary Max and Min ?

the purpose is to analyse data of a currency. I have data of 22 currency of three month , and I would like to analyse the relation between them. So there is few hundreds of period (few hundred of record of 22 field) Then I pick 20 previous period (record) of each period, then I take with a calculation field the highest and lowest value of each period, then I compare if there is relation between them. For exemple if three currency is the highest of 20 previous period what happens to others ? if something happen, the positive or negative conclusion would be the same if there is more or less p

Hi, I m trying to get data from a range of 20 previous record in a calculation field, I used the fonction : GetNthRecord ( ffffffffield ; Get ( RecordNumber ) -1)& ¶ & GetNthRecord ( ffffffffield ; Get ( RecordNumber ) -2)& ¶ & .....& ¶ & GetNthRecord ( ffffffffield ; Get ( RecordNumber ) -20) but in purpose to find the best result in my research I need to add or reduce the number of previous record, and there is 22 field with 20 previous record. So imagine the work that I had to do to edit every field. I thought maybe it s possible to make a loop ?

Hi Comment, thank you maybe a should run a script to calculate that field , I ll do as you update it. I always come with strange calculation ))))

Hi I have this fonction in a calculation field : "If ( Get ( TotalRecordCount )-Get ( RecordNumber ) >0 ; "perform record: present - (record +1)")" what I need is : if the current record is not the last then..... take the present value - next record value I also tried like this but I get "?" on every new record created. If I modify the calculation script then it run the calculation and everything work but for only old records, it s like the calculation run only one time on the creation. If ( Get ( TotalRecordCount )-Get ( RecordNumber ) >0 ; GetNthRecord ( F

thank you Comment , Have a great day ! 😀

input : 72LDs 69LDs 56LDs 48LDs 36LDs 24LDs output with Getasnumber "GetAsNumber ( List ( variante::taille ) ) " : 726956483624 what I would like is a list : 72 69 56 48 36 24 it s partly related, it s better if I open a new topic ? with a project file for exemple ? here is an exemple getasnumber.fmp12

well you see it gave me numbers one after one "726956483624" instead I need it like a list like this : 72 69 56 48 36 24

did you ever get this issu : when I run : GetAsNumber ( List ( field::field ) ) I don't have a liste, I have numbers after numbers without space :726956483624 instead of : 72 69 56 48 36 24