Search the Community
Showing results for tags 'database'.
I would like to use Alfred to query a FileMaker solution. I have a script in FileMaker that executes a query based on the contents of the Clipboard. And I have assigned the ⌘-1 keystroke as the trigger. Here is the procedure that I'm trying to build. - Invoke Alfred. - Enter "fm " to tell Alfred that this is a FileMaker query. - Enter the search string. - Press Return. Alfred would then - Copy the string to the Clipboard. - Activate Organizer.fmp12. - Wait until Organizer.fmp12 is frontmost. - Perform the ⌘-1 keystroke (which will cause FileMaker to perform the query). I have created a workflow that recognizes the keyword and copies the search string to the Clipboard. But I don't know how to proceed. Any help would be appreciated. macOS 10.13.6 Alfred 3.7 FMPA 17
Is there any way to open the clipboard.alfdb in any terminal program so that I can remove sensitive data and replace it with something like "PASSWORDREMOVED" without corrupting the data file? Is it in any certain data format? Like if it was SQLite I could make the changes through there I know you can do function-backspace to remove entries from the clipboard, however, i just want to remove the sensitive data not the whole line from the clipboard. Thank you, Jared https://jared.nyc https://devopschat.co
I would like to use Alfred to search a Numbers spreadsheet for a row based on a column query. Once a row is found I would like to display the row or rows that matched the search. For example, in the spreadsheet below, If I search for 3B8, the workflow would display: 3B8, Mauritius, 38 Numbers Spreadsheet: 1S, Spraley, 307 3A, Monaco, 39 3B8, Mauritius, 38 3C, Equatorial Guinea, 69 … … Any ideas? Fred