dickiedyce
/ MD Table of Non-basetables.txt
Created
September 7, 2023 19:12
Create a Markdown table of table occurences that aren't bas tables in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Substitute ( | |
| ",TableName,TableID,BaseTableName,BaseFileName," & ¶ | |
| & ",----,----,----,----," & ¶ & | |
| ExecuteSQL ( | |
| "SELECT '',TableName,TableID,BaseTableName,BaseFileName,'' FROM FILEMAKER_TABLES WHERE TableName <> BaseTableName" ; | |
| "" ; | |
| "" | |
| ) ; | |
| "," ; | |
| "|" |
dickiedyce
/ MD Table of Basetable Fields.txt
Created
September 7, 2023 19:11
Create a Markdown table of fields from base tables in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Let ( | |
| baseTables = "'" & | |
| ExecuteSQL ( | |
| "SELECT TableName FROM FILEMAKER_TABLES WHERE TableName = BaseTableName" ; | |
| "" ; | |
| "','" | |
| ) & "'" ; | |
| Substitute ( | |
| ",TableName,FieldName,FieldType,FieldID,FieldClass,FieldReps,ModCount," & ¶ & | |
| ",----,----,----,----,----,----,----," & ¶ & |
dickiedyce
/ MD Table of all Tables.txt
Created
September 7, 2023 19:11
Create a Markdown table of tables in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Substitute ( | |
| ",TableName,TableID,BaseTableName,BaseFileName," & ¶ & | |
| ",----,----,----,----," & ¶ & | |
| ExecuteSQL ( | |
| "SELECT '',TableName,TableID,BaseTableName,BaseFileName,'' FROM FILEMAKER_TABLES" ; | |
| "" ; | |
| "" | |
| ) ; | |
| "," ; | |
| "|" |
dickiedyce
/ MD Table of Basetables.txt
Created
September 7, 2023 19:10
Create a Markdown table of base tables in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Substitute ( | |
| ",TableName,TableID,BaseTableName,BaseFileName," & ¶ & | |
| ",----,----,----,----," & ¶ & | |
| ExecuteSQL ( | |
| "SELECT '',TableName,TableID,BaseTableName,BaseFileName,'' FROM FILEMAKER_TABLES WHERE TableName = BaseTableName" ; | |
| "" ; | |
| "" | |
| ) ; | |
| "," ; | |
| "|" |
dickiedyce
/ MD Table of all Fields.txt
Created
September 7, 2023 19:10
Create a Markdown table of fiels in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Substitute ( | |
| ",TableName,FieldName,FieldType,FieldID,FieldClass,FieldReps,ModCount," & ¶ & | |
| ",----,----,----,----,----,----,----," & ¶ & | |
| ExecuteSQL ( | |
| "SELECT '',TableName,FieldName,FieldType,FieldID,FieldClass,FieldReps,ModCount,'' FROM FILEMAKER_FIELDS" ; | |
| "" ; | |
| "" | |
| ) ; | |
| "," ; | |
| "|" |
dickiedyce
/ MD Table of relationships.txt
Created
September 7, 2023 19:10
Create a Markdown table of relationships in a FileMaker file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| While ( | |
| [ | |
| tables = TableNames ( "" ) ; | |
| relationList = "| Source File | Related To | Options |" & ¶ & | |
| "| ---- | ---- | ---- | ---- |" | |
| ] ; | |
| ValueCount ( tables ) > 0 ; | |
| [ |
dickiedyce
/ monitor-battery.js
Created
February 13, 2022 19:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Menu: Battery Monitor | |
| // Description: Check if AC should be disconnected? Poorman's AlDente | |
| // Author: Richard Dyce | |
| // Twitter: @dickiedyce | |
| // schedule: 0,15,20,45 5-22 * * * | |
| import "@johnlindquist/kit" | |
| const result = await exec(`pmset -g batt`) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rsync -auvhp --delete --exclude=node_modules "/Users/dd/webui" "/Users/dd/Library/Mobile Documents/com~apple~CloudDocs/WebUI Work" |