4 posts in this topic
By John D Sebastian
FileMaker friends, could someone please teach me a new trick
I'm building an interface for composing "counsel" documents with each sentence it's own related record
Sometimes I need to move the portal rows around, like in my "Old McDonald" example
I think they call this kind a thing a "custom search order"
Is it possible to "Drag and Drop"? If not, no problem, how about a scripted button?
What would you do?
When updating any 360works-plug-in it is deactivated after any update. Sometimes it does not even is replaced.
I have created batch-scripts to shut off FileMaker and then remove any 360works-plug-in.
After that my user(s) have to restart the application again and the new version of (any) 360works plug-in is installed correctly and activated automatically.
I also use other plug-ins by Troi, Dacons en Goya simultaniously and these work perfectly fine and also will be updated and activated when a newer version is being installed. Only the 360works-plug-ins fail to update everytime.
I use the script-step "Install plug-in file" so nothing exotic is done there.
The problems occur on windows 7, 8, 8.1, 10, 2008 and 2012. On the 32 and 64 bits versions (2012 - 64-bit only)
Any suggestions or anyone else has the same trouble?
I am using Scribe to extract text from a pdf. The pdf has a filesize of 705542 so it is fairly large. The Scribe result is fairly good but it has a serious problem: a space is inserted into words; see example of words like NE W YORK AND NEW JERSEY, airp orts, Inte rnational, Internat ional
Why does Scribe do this? Is there a way to fix it? (It is close to a dealbreaker if you can extract text but then not use the text that's extracted)
Many thanks in advance for your replies, as I certainly hope I can use Scribe since I've used 360Works products for years and Textractor before Scribe.
I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server.
I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample:
Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"
What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on. I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax:
Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value])
I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.