The most powerful no-code platform

29:null 2a:["$","title",null,{"children":"Get data types, option sets and process them | Andrew Agostini | Observable"}] 2f:T8bb9,option_sets = { const option_set = { "months": { "%d": "Months", "values": { "may": { "%d": "May", "sort_factor": 5, "month_number": 5 }, "july": { "%d": "July", "sort_factor": 7, "month_number": 7 }, "june": { "%d": "June", "sort_factor": 6, "month_number": 6 }, "april": { "%d": "April", "sort_factor": 4, "month_number": 4 }, "march": { "%d": "March", "sort_factor": 3, "month_number": 3 }, "august": { "%d": "August", "sort_factor": 8, "month_number": 8 }, "january": { "%d": "January", "sort_factor": 1, "month_number": 1 }, "october": { "%d": "October", "sort_factor": 10, "month_number": 10 }, "december": { "%d": "December", "sort_factor": 12, "month_number": 12 }, "february": { "%d": "February", "sort_factor": 2, "month_number": 2 }, "november": { "%d": "November", "sort_factor": 11, "month_number": 11 }, "september": { "%d": "September", "sort_factor": 9, "month_number": 9 } }, "attributes": { "month_number": { "%d": "Month Number", "%v": "number" } } }, "deal_type": { "%d": "Deal Type", "values": { "contract": { "%d": "Contract", "sort_factor": 1 }, "assignment": { "%d": "Buy Assignment", "sort_factor": 2 } } }, "tab_group": { "%d": "Tab Group", "values": { "core": { "%d": "Core", "sort_factor": 1 }, "deals": { "%d": "Deals", "sort_factor": 2 }, "transaction_management": { "%d": "Transaction Management", "sort_factor": 3 } } }, "templates": { "%d": "Templates", "values": { "investor_bulk_upload_template": { "%d": "Investor Bulk Upload Template", "file": "//s3.amazonaws.com/appforest_uf/f1629816420849x465809085173183550/REA%20Bulk%20Investor%20Upload%20Template.xlsx", "sort_factor": 1 } }, "attributes": { "file": { "%d": "File", "%v": "file" } } }, "user_role": { "%d": "User: Role", "values": { "aa": { "%d": "AA", "full_name": "Acquisitions Agent", "sort_factor": 4 }, "gm": { "%d": "GM", "full_name": "General Manager", "sort_factor": 2 }, "sa": { "%d": "SA", "full_name": "Sales Agent", "sort_factor": 3 }, "owner": { "%d": "Owner", "full_name": "Owner", "sort_factor": 1 }, "frozen": { "%d": "Frozen", "full_name": "Frozen", "sort_factor": 6 }, "archived": { "%d": "Deleted", "full_name": "Deleted", "sort_factor": 5 } }, "attributes": { "full_name": { "%d": "Full Name", "%v": "text" } } }, "deal__exit": { "%d": "Deal: Exit", "values": { "assignment": { "%d": "Assignment", "sort_factor": 1 }, "double_close": { "%d": "Double Close", "sort_factor": 2 } } }, "tabs__deal": { "%d": "Tabs: Deal", "%del": true, "values": { "buyside": { "%d": "Buyside", "slug": "buy", "sort_factor": 1 }, "sellside": { "%d": "Sellside", "slug": "sell", "sort_factor": 2 } }, "attributes": { "slug": { "%d": "Slug", "%v": "text" } } }, "deal__stage": { "%d": "Status (Deal)", "values": { "%del": { "%d": "Deleted", "sort_factor": 15 }, "inactive": { "%d": "Inactive", "sort_factor": 14 }, "buy_contract_dead": { "%d": "Buy Contract Dead", "color": "#FF0000", "closed_": true, "buy_sell": "Closed", "sort_factor": 9, "deal_actions": true }, "closed_and_funded": { "%d": "Closed and Funded", "step": 7, "closed_": false, "buy_sell": "Closed", "sort_factor": 13, "deal_actions": true }, "buy_contract_signed": { "%d": "Buy Contract Signed", "%del": true, "step": 3, "buy_sell": "Buy", "sort_factor": 3 }, "preparing_buy_offer": { "%d": "Preparing Buy Offer", "step": 1, "buy_sell": "Buy", "sort_factor": 1 }, "close___mls_or_rehab": { "%d": "Pending MLS", "step": 4, "color": "#00ff00", "closed_": true, "buy_sell": "Closed", "sort_factor": 8, "dashboard_view": true }, "buy_contract_submitted": { "%d": "Buy Contract Submitted", "step": 2, "buy_sell": "Buy", "sort_factor": 2 }, "wholesale_deal_pending": { "%d": "Pending Wholesale", "step": 4, "buy_sell": "Closing", "sort_factor": 7, "dashboard_view": true }, "wholesale_package_prep": { "%d": "Wholesale Package Prep", "step": 1, "buy_sell": "Prep", "sort_factor": 4 }, "wholesale_deal_bs_closed": { "%d": "BS Closed (Wholesale)", "%del": true, "step": 5, "buy_sell": "Sell", "sort_factor": 11 }, "wholesale_deal_fs_closed": { "%d": "FS Closed (Wholesale)", "%del": true, "step": 6, "buy_sell": "Sell", "sort_factor": 12 }, "wholesale_deal_showing_scheduled": { "%d": "Deal Showing Scheduled (Wholesale)", "%del": true, "step": 3, "sort_factor": 6 }, "wholesale_deal_active___free_for_all": { "%d": "Available", "step": 2, "buy_sell": "Sell", "sort_factor": 5, "dashboard_view": true }, "wholesale_last_minute_real_equity_closing": { "%d": "Wholesale Last Minute Real Equity Closing", "buy_sell": "Closed", "sort_factor": 10, "deal_actions": true } }, "attributes": { "step": { "%d": "Step", "%v": "number" }, "color": { "%d": "Color", "%v": "text" }, "closed_": { "%d": "Closed?", "%v": "boolean" }, "buy_sell": { "%d": "Phase", "%v": "text" }, "sidebar_": { "%d": "Sidebar? - deleted", "%v": "boolean", "%del": true }, "deal_actions": { "%d": "Deal Actions", "%v": "boolean" }, "dashboard_view": { "%d": "Dashboard View", "%v": "boolean" } } }, "territories": { "%d": "Territory", "values": { "austin": { "%d": "Austin", "phone": "18333379289", "state": "Texas", "re_entity": "Real Equity TX LLC", "sort_factor": 1, "signing_name": "Brad", "signing_email": "austinsigner@realequity.com", "bs_template_id": "djaGxHVC72rvZaPgyMsKr8", "test_geography": "", "signing_last_name": "Marine", "rea_entity_address": "13915 N Mopac Suite 410 Austin, TX 78728", "fs_pandadocs_template": "bsxs9UP5T5MHeEzHctvQpU", "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647341236x915196114054565000/2%20RE%20TX%20Purchase%20Agreement.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647427896x204050423357680770/5%20RE%20TX%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "t92xT8FVBLWSgDd79836Qc", "fs_pd_id_1_seller_pre_signed": "i6R8728246SQ76EViYfZNK", "fs_pd_id_2_seller_pre_signed": "xkNs2mksojALFEsed7Mwnk", "bs_pd_template_id_2_investors": "hvZpkWcbXxmcnTh4fvUkkN", "fs_pd_template_id_1_seller_gm_only": "6jjuQWg8wYGzXaeySfK3w8", "fs_pd_template_id_2_seller_gm_only": "V3vY6RP9Q8cBXv4VfGf9v9" }, "houston": { "%d": "Houston", "phone": "18333401818", "state": "Texas", "re_entity": "Real Equity TX LLC", "sort_factor": 2, "signing_name": "Melvin", "signing_email": "houstonsigner@realequity.com", "bs_template_id": "djaGxHVC72rvZaPgyMsKr8", "test_geography": { "lat": 31.9685988, "lng": -99.9018131, "address": "Texas, USA", "placeId": "ChIJSTKCCzZwQIYRPN4IGI8c6xY", "components": { "state": "Texas", "country": "United States", "state code": "TX", "country code": "US" } }, "signing_last_name": "Ruiz", "rea_entity_address": "2500 Summer Suite 2110 Houston, TX 77007", "fs_pandadocs_template": "bsxs9UP5T5MHeEzHctvQpU", "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647468628x746556979990190700/2%20RE%20TX%20Purchase%20Agreement.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647482018x307802931394346240/5%20RE%20TX%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "t92xT8FVBLWSgDd79836Qc", "fs_pd_id_1_seller_pre_signed": "i6R8728246SQ76EViYfZNK", "fs_pd_id_2_seller_pre_signed": "xkNs2mksojALFEsed7Mwnk", "bs_pd_template_id_2_investors": "hvZpkWcbXxmcnTh4fvUkkN", "fs_pd_template_id_1_seller_gm_only": "6jjuQWg8wYGzXaeySfK3w8", "fs_pd_template_id_2_seller_gm_only": "V3vY6RP9Q8cBXv4VfGf9v9" }, "killeen": { "%d": "Killeen", "state": "Texas", "re_entity": "Real Equity TX LLC", "sort_factor": 10, "signing_name": "Brad", "signing_email": "brad@realequity.com", "bs_template_id": "djaGxHVC72rvZaPgyMsKr8", "signing_last_name": "Marine", "fs_pandadocs_template": "bsxs9UP5T5MHeEzHctvQpU", "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1650647401583x417848364960803800/2%20RE%20TX%20Purchase%20Agreement.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1650647425300x353020718795491480/5%20RE%20TX%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "t92xT8FVBLWSgDd79836Qc", "fs_pd_id_1_seller_pre_signed": "i6R8728246SQ76EViYfZNK", "fs_pd_id_2_seller_pre_signed": "xkNs2mksojALFEsed7Mwnk", "bs_pd_template_id_2_investors": "hvZpkWcbXxmcnTh4fvUkkN", "fs_pd_template_id_1_seller_gm_only": "6jjuQWg8wYGzXaeySfK3w8", "fs_pd_template_id_2_seller_gm_only": "V3vY6RP9Q8cBXv4VfGf9v9" }, "orlando": { "%d": "Orlando", "state": "Florida", "re_entity": "Real Equity FL LLC", "sort_factor": 9, "signing_name": "Daniel", "signing_email": "orlandosigner@realequity.com", "signing_last_name": "Dealejandro", "rea_entity_address": "5764 N. Orange Blossom Trail Suite 331 Orlando FL 32810" }, "titleco": { "%d": "TitleCo", "%del": true, "sort_factor": 5 }, "columbus": { "%d": "Columbus", "phone": "18333382487", "state": "Ohio", "re_entity": "Real Equity OH LLC", "sort_factor": 8, "signing_name": "Rayan", "signing_email": "columbussigner@realequity.com", "bs_template_id": "MknbFz5GATLFZRpThBM5d8", "signing_last_name": "Ismail", "rea_entity_address": "700 W Pete Rose Way #339 Cincinnati, OH 45203", "fs_pandadocs_template": "aeWv3sPkoRe2tftqz6Hxd5", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1639514070969x692175909646393700/6%20RE%20OH%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "SEYyCyeigKKppZu2MrJp24", "fs_pd_id_1_seller_pre_signed": "qAjfJt7S4XfnXNNX9kTWYQ", "fs_pd_id_2_seller_pre_signed": "irQthZ3eCpwCNnJEqRMBGE", "bs_pd_template_id_2_investors": "jyWh8vpQH6mvWYmWc6RuEV", "fs_pd_template_id_1_seller_gm_only": "YXp7JNGchSSEu8EQxVX2Ak", "fs_pd_template_id_2_seller_gm_only": "kj2vXcjmsE3Kn3SFyKwdQm" }, "kentucky": { "%d": "Northern Kentucky", "phone": "18333382487", "re_entity": "Real Equity OH LLC", "sort_factor": 4, "signing_name": "Daniel", "signing_email": "kentuckysigner@realequity.com", "bs_template_id": "JFd7rU6GSPDF7mDXJibMuD", "test_geography": "", "signing_last_name": "Dealejandro", "rea_entity_address": "729 Crescent Ave. Covington, KY 41011", "sister_territories": { "0": "cincinnati" }, "fs_pandadocs_template": "aeWv3sPkoRe2tftqz6Hxd5", "territory_specialzone": { "0": "Cincinnati" }, "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1637092419748x761016532789298100/3%20RE%20OH%20Buy%20Contract.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647667248x855938986790970100/7%20RE%20KY%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "SEYyCyeigKKppZu2MrJp24", "fs_pd_id_1_seller_pre_signed": "qAjfJt7S4XfnXNNX9kTWYQ", "fs_pd_id_2_seller_pre_signed": "irQthZ3eCpwCNnJEqRMBGE", "bs_pd_template_id_2_investors": "SRXYzeZju5Gv3xgybeKsX5", "fs_pd_template_id_1_seller_gm_only": "YXp7JNGchSSEu8EQxVX2Ak", "fs_pd_template_id_2_seller_gm_only": "kj2vXcjmsE3Kn3SFyKwdQm" }, "westeros": { "%d": "Westeros", "%del": true, "sort_factor": 6, "territory_specialzone": { "0": "Nightwatch" } }, "cincinnati": { "%d": "Cincinnati", "phone": "18333382487", "state": "Ohio", "re_entity": "Real Equity OH LLC", "sort_factor": 3, "signing_name": "Rayan", "signing_email": "cincinnatisigner@realequity.com", "bs_template_id": "MknbFz5GATLFZRpThBM5d8", "test_geography": "", "signing_last_name": "Ismail", "rea_entity_address": "700 W Pete Rose Way #339 Cincinnati, OH 45203", "sister_territories": { "0": "kentucky" }, "fs_pandadocs_template": "aeWv3sPkoRe2tftqz6Hxd5", "territory_specialzone": { "0": "Northern Kentucky" }, "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647547821x461786488309299260/3%20RE%20OH%20Buy%20Contract.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1624647600830x876101912250949200/6%20RE%20OH%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "SEYyCyeigKKppZu2MrJp24", "fs_pd_id_1_seller_pre_signed": "qAjfJt7S4XfnXNNX9kTWYQ", "fs_pd_id_2_seller_pre_signed": "irQthZ3eCpwCNnJEqRMBGE", "bs_pd_template_id_2_investors": "jyWh8vpQH6mvWYmWc6RuEV", "fs_pd_template_id_1_seller_gm_only": "YXp7JNGchSSEu8EQxVX2Ak", "fs_pd_template_id_2_seller_gm_only": "kj2vXcjmsE3Kn3SFyKwdQm" }, "nightwatch": { "%d": "Nightwatch", "%del": true, "sort_factor": 7, "territory_specialzone": { "0": "Westeros" } }, "san_antonio": { "%d": "San Antonio", "state": "Texas", "re_entity": "Real Equity TX LLC", "sort_factor": 11, "signing_name": "Dealejandro", "signing_email": "sales@realequity.com", "bs_template_id": "djaGxHVC72rvZaPgyMsKr8", "signing_last_name": "Daniel", "fs_pandadocs_template": "bsxs9UP5T5MHeEzHctvQpU", "fs_pdf_contract_template": "//s3.amazonaws.com/appforest_uf/f1650647999536x414950247474387300/2%20RE%20TX%20Purchase%20Agreement.pdf", "pdf_bs_contract_template": "//s3.amazonaws.com/appforest_uf/f1650647987499x389169888217830460/5%20RE%20TX%20Sell%20Contract.pdf", "fs_pd_template_id_2_sellers": "t92xT8FVBLWSgDd79836Qc", "fs_pd_id_1_seller_pre_signed": "i6R8728246SQ76EViYfZNK", "fs_pd_id_2_seller_pre_signed": "xkNs2mksojALFEsed7Mwnk", "bs_pd_template_id_2_investors": "hvZpkWcbXxmcnTh4fvUkkN", "fs_pd_template_id_1_seller_gm_only": "6jjuQWg8wYGzXaeySfK3w8", "fs_pd_template_id_2_seller_gm_only": "V3vY6RP9Q8cBXv4VfGf9v9" } }, "attributes": { "phone": { "%d": "Phone", "%v": "text" }, "state": { "%d": "State", "%v": "text" }, "titleco": { "%d": "TitleCo - deleted", "%v": "text", "%del": true }, "re_entity": { "%d": "REA Entity", "%v": "text" }, "signing_name": { "%d": "Signing First Name", "%v": "text" }, "signing_email": { "%d": "Signing Email", "%v": "text" }, "bs_template_id": { "%d": "BS PD Template ID 1 Investor", "%v": "text" }, "test_geography": { "%d": "Test Geography - deleted", "%v": "geographic_address", "%del": true }, "signer_initials": { "%d": "Signer Initials - deleted", "%v": "text", "%del": true }, "signing_last_name": { "%d": "Signing Last Name", "%v": "text" }, "rea_entity_address": { "%d": "REA Entity Address", "%v": "text" }, "sister_territories": { "%d": "Sister Territories", "%v": "list.option.territories" }, "fs_pandadocs_template": { "%d": "FS PD ID 1 Seller", "%v": "text" }, "territory_specialzone": { "%d": "Territory:SpecialZone", "%v": "list.text" }, "fs_pdf_contract_template": { "%d": "PDF FS Contract Template", "%v": "file" }, "pdf_bs_contract_template": { "%d": "PDF BS Contract Template", "%v": "file" }, "fs_pd_template_id_2_sellers": { "%d": "FS PD ID 2 Sellers", "%v": "text" }, "fs_pd_id_1_seller_pre_signed": { "%d": "FS PD ID 1 Seller Pre Signed", "%v": "text" }, "fs_pd_id_2_seller_pre_signed": { "%d": "FS PD ID 2 Seller Pre Signed", "%v": "text" }, "bs_pd_template_id_2_investors": { "%d": "BS PD Template ID 2 Investors", "%v": "text" }, "fs_pd_template_id_1_seller_gm_only": { "%d": "FS PD ID 1 Seller GM Only", "%v": "text" }, "fs_pd_template_id_2_seller_gm_only": { "%d": "FS PD ID 2 Seller GM Only", "%v": "text" } } }, "change_event": { "%d": "Event Type", "values": { "agent_change": { "%d": "Agent Updated", "db_value": "agent_change", "sort_factor": 1 } }, "creation_source": "editor" }, "confirmation": { "%d": "Confirmation", "values": { "no": { "%d": "NO", "sort_factor": 3 }, "yes": { "%d": "YES", "sort_factor": 2 }, "unspecified": { "%d": "UNSPECIFIED", "sort_factor": 1 } } }, "person__type": { "%d": "Person: Type", "values": { "realtor": { "%d": "Realtor", "sort_factor": 2 }, "investor": { "%d": "Investor", "sort_factor": 1 } } }, "investor_type": { "%d": "Investor Type", "values": { "cmTNM": { "%d": "Landlord", "db_value": "landlord", "sort_factor": 1 }, "cmTNN": { "%d": "Flipper", "db_value": "flipper", "sort_factor": 2 } }, "creation_source": "editor" }, "offer__status": { "%d": "Offer: Status", "%del": true, "values": { "sent": { "%d": "Sent", "%del": true, "sort_factor": 1 }, "closed": { "%d": "Closed", "%del": true, "sort_factor": 4 }, "signed": { "%d": "Signed", "%del": true, "sort_factor": 2 }, "accepted": { "%d": "Accepted", "%del": true, "sort_factor": 3 } } }, "dashboard__tabs": { "%d": "Tabs: Dashboard", "values": { "all": { "%d": "All", "%del": true, "slug": "all", "sort_factor": 14, "deal_statuses": { "0": "wholesale_package_prep", "1": "buy_contract_dead", "2": "buy_contract_submitted", "3": "close___mls_or_rehab", "4": "closed_and_funded", "5": "preparing_buy_offer", "6": "wholesale_deal_active___free_for_all", "7": "wholesale_deal_pending", "8": "wholesale_last_minute_real_equity_closing" } }, "closed": { "%d": "Closed", "slug": "closed", "group": "deals", "sort_factor": 13, "feather_icon": "octagon", "deal_statuses": { "0": "closed_and_funded", "1": "buy_contract_dead" } }, "buy_side": { "%d": "Acquisitions", "slug": "acquisitions", "group": "deals", "sort_factor": 8, "feather_icon": "home", "deal_statuses": { "0": "preparing_buy_offer", "1": "buy_contract_submitted", "2": "wholesale_package_prep" } }, "all_deals": { "%d": "All Deals", "slug": "all-deals", "group": "deals", "sort_factor": 15, "feather_icon": "inbox", "deal_statuses": { "0": "wholesale_package_prep", "1": "wholesale_last_minute_real_equity_closing", "2": "wholesale_deal_pending", "3": "wholesale_deal_active___free_for_all", "4": "preparing_buy_offer", "5": "inactive", "6": "closed_and_funded", "7": "close___mls_or_rehab", "8": "buy_contract_submitted", "9": "buy_contract_dead", "10": "deleted" } }, "dashboard": { "%d": "Dashboard", "group": "core", "top_level_": true, "sort_factor": 1, "feather_icon": "send" }, "add_a_deal": { "%d": "Add a Deal", "%del": true, "slug": "add-deal", "sort_factor": 11, "feather_icon": "star" }, "my_profile": { "%d": "Profile", "slug": "my-profile", "group": "core", "top_level_": true, "sort_factor": 5, "feather_icon": "user" }, "leaderboard": { "%d": "Leaderboard", "%del": true, "slug": "leaderboard", "group": "core", "hidden": true, "hidden0": true, "top_level_": true, "sort_factor": 7, "feather_icon": "award" }, "my_realtors": { "%d": "My Realtors", "slug": "my-realtors", "group": "core", "hidden0": true, "top_level_": true, "sort_factor": 4, "feather_icon": "briefcase" }, "my_investors": { "%d": "My Investors", "slug": "investors", "group": "core", "top_level_": true, "sort_factor": 2, "feather_icon": "dollar-sign" }, "pending_deals": { "%d": "Pending Wholesale", "slug": "pending-wholesale", "group": "deals", "sort_factor": 10, "feather_icon": "refresh-cw", "deal_statuses": { "0": "wholesale_deal_pending" } }, "my_performance": { "%d": "My Performance", "%del": true, "slug": "my-performance", "top_level_": false, "sort_factor": 3, "feather_icon": "pie-chart" }, "available_deals": { "%d": "Available Deals", "slug": "available-deals", "group": "deals", "sort_factor": 9, "feather_icon": "tag", "deal_statuses": { "0": "wholesale_deal_active___free_for_all" } }, "title_companies": { "%d": "Title Companies", "slug": "title-companies", "group": "transaction_management", "sort_factor": 16, "feather_icon": "file-text" }, "background_tasks": { "%d": "Background Tasks", "slug": "background-tasks", "group": "core", "sort_factor": 6, "feather_icon": "activity" }, "close___mls_rehab": { "%d": "Pending MLS", "slug": "mls", "group": "deals", "sort_factor": 12, "feather_icon": "tool", "deal_statuses": { "0": "close___mls_or_rehab" } } }, "attributes": { "slug": { "%d": "slug", "%v": "text" }, "group": { "%d": "Group", "%v": "option.tab_group" }, "hidden": { "%d": "hidden - deleted", "%v": "boolean", "%del": true }, "hidden0": { "%d": "hidden", "%v": "boolean" }, "top_level_": { "%d": "Top Level?", "%v": "boolean" }, "feather_icon": { "%d": "Feather Icon", "%v": "text" }, "deal_statuses": { "%d": "Deal Statuses", "%v": "list.option.deal__stage" } } }, "property_access": { "%d": "Property Access" }, "developer_contact": { "%d": "app", "values": { "%em": { "%d": "configurations", "contact": "rea_developer@scious.io", "sort_factor": 1 } }, "attributes": { "contact": { "%d": "developer_email", "%v": "text" } } }, "pandadoc_template": { "%d": "Pandadoc Template", "%del": true, "values": { "template_id": { "%d": "Investor Disclosure", "sort_factor": 1, "contract_name": "N4KjyGzDMiD6cRFTDFBgs5" }, "contract_name": { "%d": "contract_name", "%del": true, "sort_factor": 2 }, "sale_agreement": { "%d": "Sale Agreement", "sort_factor": 3 }, "purchase_agreement": { "%d": "Purchase Agreement", "sort_factor": 4 } }, "attributes": { "template_ids": { "%d": "template_ids", "%v": "list.text" }, "contract_name": { "%d": "template_id - deleted", "%v": "text", "%del": true } } }, "tab__selling_deal": { "%d": "Tab: Selling Deal", "%del": true, "values": { "offers": { "%d": "Offers", "%9i": "pen-tool", "sort_factor": 3 }, "messages": { "%d": "Messages", "%9i": "mail", "sort_factor": 2 }, "property": { "%d": "Property", "%9i": "home", "sort_factor": 1 } }, "attributes": { "%9i": { "%d": "Icon", "%v": "text" } } }, "pandadocs_template": { "%d": "PandaDocs Template", "%del": true, "values": { "bs_ohio": { "%d": "BS Ohio", "sort_factor": 5 }, "bs_texas": { "%d": "BS Texas", "sort_factor": 4 }, "fs_texas": { "%d": "FS Texas", "sort_factor": 1 }, "bs_kentucky": { "%d": "BS Kentucky", "sort_factor": 6 }, "fs_cincinnati": { "%d": "FS Cincinnati", "sort_factor": 2 }, "fs_buy_assignment": { "%d": "FS Buy Assignment", "sort_factor": 3 } }, "attributes": { "folder_id": { "%d": "Folder ID", "%v": "text" }, "template_id": { "%d": "Template ID", "%v": "text" } } }, "re_pdf_contract_template": { "%d": "RE PDF Contract Template", "values": { "buy_assignment": { "%d": "Buy Assignment", "file": "//s3.amazonaws.com/appforest_uf/f1624647799988x701780936815177700/4%20RE%20Buy%20Assignment.pdf", "sort_factor": 1 } }, "attributes": { "file": { "%d": "file", "%v": "file" } } } } return option_set }30:T7a5d,payload = {const payload = { "%e1": { "%d": "Event", "%f3": { "description_text": { "%v": "text", "%d": "Description" }, "type_custom_event": { "%v": "custom.event", "%d": "Type - deleted", "%del": true }, "investor_custom_investor": { "%v": "custom.investor", "%d": "Investor" }, "type_option_change_event": { "%v": "option.change_event", "%d": "Type" } } }, "deal": { "%d": "Deal", "%f3": { "aa_user": { "%v": "user", "%d": "Acquisitions Agent (AA)" }, "pin_text": { "%v": "text", "%d": "PIN" }, "etag_text": { "%v": "text", "%d": "etag" }, "bs_arv_number": { "%v": "number", "%d": "BS: ARV" }, "closing_date_date": { "%v": "date", "%d": "FS: Closing Date" }, "home__beds_number": { "%v": "number", "%d": "BS: Bedrooms" }, "sales_price_number": { "%v": "number", "%d": "FS: Sales Price" }, "bs_pandadoc_id_text": { "%v": "text", "%d": "BS: PandaDoc ID" }, "bs_sqfootage_number": { "%v": "number", "%d": "BS: SqFootage" }, "buy__pd_doc_id_text": { "%v": "text", "%d": "BUY: PD_Doc ID - deleted", "%del": true }, "fs_pandadoc_id_text": { "%v": "text", "%d": "FS: PandaDoc ID" }, "fs_template_id_text": { "%v": "text", "%d": "FS: Template ID" }, "panda_document_file": { "%v": "file", "%d": "Panda Document - deleted", "%del": true }, "fs_send_count_number": { "%v": "number", "%d": "FS Send Count - deleted", "%del": true, "default_val": 0 }, "home__garage_boolean": { "%v": "boolean", "%d": "Home: Garage - deleted", "%del": true }, "fs_assignor_name_text": { "%v": "text", "%d": "FS: Seller Name (BA)" }, "home__year_built_date": { "%v": "date", "%d": "Home: Year Built - deleted", "%del": true }, "kpi_headers_list_text": { "%v": "list.text", "%d": "email_kpi_headers" }, "sales_agent__sa__user": { "%v": "user", "%d": "Sales Agent (SA)" }, "sell__mls_packet_file": { "%v": "file", "%d": "BS: MLS Packet" }, "bs__deal_contract_file": { "%v": "file", "%d": "BS: Deal Contract" }, "bs__offer_price_number": { "%v": "number", "%d": "BS: Offer Price - deleted", "%del": true }, "buy__option_fee_number": { "%v": "number", "%d": "FS: Option Fee", "default_val": 0 }, "deal_option_fee_number": { "%v": "number", "%d": "Deal Option Fee" }, "exit_option_deal__exit": { "%v": "option.deal__exit", "%d": "Exit - deleted", "%del": true }, "fs__option_days_number": { "%v": "number", "%d": "FS: Option Days" }, "fs_assignor_phone_text": { "%v": "text", "%d": "FS: Assignor Phone" }, "home__bathrooms_number": { "%v": "number", "%d": "BS: Bathrooms" }, "legal_subdivision_text": { "%v": "text", "%d": "Legal Subdivision" }, "buy__deal_contract_file": { "%v": "file", "%d": "FS: Deal Contract" }, "buy__seller_s_name_text": { "%v": "text", "%d": "FS: Seller's Name - deleted", "%del": true }, "email_bullets_list_text": { "%v": "list.text", "%d": "email_bullets" }, "fs_contract_signed_text": { "%v": "text", "%d": "FS-contract-executed" }, "home__year_built_number": { "%v": "number", "%d": "BS: Year Built" }, "listing_agent_name_text": { "%v": "text", "%d": "Listing Agent Name" }, "bs__signed_contract_file": { "%v": "file", "%d": "BS: Signed Contract" }, "buy__seller_s_email_text": { "%v": "text", "%d": "FS: Seller's Email - deleted", "%del": true }, "buy_assignment_date_date": { "%v": "date", "%d": "Buy Assignment Date" }, "fs_assignor_address_text": { "%v": "text", "%d": "FS: Assignor Address" }, "listing_agent_email_text": { "%v": "text", "%d": "Listing Agent Email" }, "listing_agent_phone_text": { "%v": "text", "%d": "Listing Agent Phone" }, "listing_broker_firm_text": { "%v": "text", "%d": "Listing Broker Firm" }, "offers_list_custom_offer": { "%v": "list.custom.offer", "%d": "Offers" }, "bs_blank_pandadoc_id_text": { "%v": "text", "%d": "BS Blank PandaDoc ID - deleted", "%del": true }, "buy__earnest_money_number": { "%v": "number", "%d": "FS: Earnest Money", "default_val": 0 }, "buy__signed_contract_file": { "%v": "file", "%d": "FS: Signed Contract" }, "fs_contract_sent__boolean": { "%v": "boolean", "%d": "FS: Contract Sent?", "default_val": false }, "signed_by_seller__boolean": { "%v": "boolean", "%d": "FS: Signed by Seller 1?", "default_val": false }, "status_option_deal__stage": { "%v": "option.deal__stage", "%d": "Status" }, "address_geographic_address": { "%v": "geographic_address", "%d": "Property Address" }, "fs__blank_pandadoc_id_text": { "%v": "text", "%d": "FS Blank PandaDoc ID - deleted", "%del": true }, "fs__legal_description_text": { "%v": "text", "%d": "FS: Legal Description" }, "kpi_header_units_list_text": { "%v": "list.text", "%d": "email_kpi_header_units" }, "property_address_text_text": { "%v": "text", "%d": "Property Address Text" }, "sellers_list_custom_seller": { "%v": "list.custom.seller", "%d": "Sellers" }, "accepted_offer_custom_offer": { "%v": "custom.offer", "%d": "Accepted Offer" }, "investor_sales_price_number": { "%v": "number", "%d": "BS: Investor Cash Price" }, "occupancy_at_closing_number": { "%v": "number", "%d": "Occupancy at Closing - deleted", "%del": true }, "buy__contract_signed_boolean": { "%v": "boolean", "%d": "BUY: Contract Signed - deleted", "%del": true, "default_val": false }, "fs__occupancy_per_lease_text": { "%v": "text", "%d": "FS: Occupancy per Lease - deleted", "%del": true, "default_val": " " }, "territory_option_territories": { "%v": "option.territories", "%d": "Territory" }, "titleco_custom_title_company": { "%v": "custom.title_company", "%d": "FS: TitleCo" }, "bs_monthlyrentexpected_number": { "%v": "number", "%d": "BS: MonthlyRentExpected" }, "deal_buy_earnest_money_number": { "%v": "number", "%d": "BS: Downpayment" }, "fs__occupancy_at_closing_text": { "%v": "text", "%d": "FS: Occupancy at Closing - deleted", "%del": true, "default_val": " " }, "bs_closed__wholesale___boolean": { "%v": "boolean", "%d": "Closing_ BS Closed?", "default_val": false }, "fs__contract_executed__boolean": { "%v": "boolean", "%d": "FS_Contract_Executed - deleted", "%del": true, "default_val": false }, "fs_closed__wholesale___boolean": { "%v": "boolean", "%d": "Closing_ FS Closed?", "default_val": false }, "fs_download_requested__boolean": { "%v": "boolean", "%d": "FS Download Requested? - deleted", "%del": true, "default_val": false }, "fs_signed_by_seller_2__boolean": { "%v": "boolean", "%d": "FS: Signed By Seller 2?", "default_val": false }, "signed_by_all_sellers__boolean": { "%v": "boolean", "%d": "FS: Signed By All Sellers?", "default_val": false }, "signed_by_real_equity__boolean": { "%v": "boolean", "%d": "FS: Signed by Real Equity?", "default_val": false }, "bs__occupancy_per_lease_boolean": { "%v": "boolean", "%d": "BS: Occupancy per Lease - deleted", "%del": true, "default_val": false }, "buy__deal_type_option_deal_type": { "%v": "option.deal_type", "%d": "FS: Deal Type" }, "fs__occupancy_per_lease_boolean": { "%v": "boolean", "%d": "FS: Occupancy per Lease - deleted", "%del": true, "default_val": false }, "sell__property_description_text": { "%v": "text", "%d": "BS: Property Description" }, "bs__occupancy_at_closing_boolean": { "%v": "boolean", "%d": "BS: Occupancy at Closing - deleted", "%del": true, "default_val": false }, "bs__titleco_custom_title_company": { "%v": "custom.title_company", "%d": "BS: TitleCo" }, "fs__occupancy_at_closing_boolean": { "%v": "boolean", "%d": "FS: Occupancy at Closing - deleted", "%del": true }, "sell__property_images_list_image": { "%v": "list.image", "%d": "SELL: Property Images - deleted", "%del": true }, "bs__occupancy_at_closing__boolean": { "%v": "boolean", "%d": "BS: Occupancy at closing?" }, "fs__occupancy_at_closing1_boolean": { "%v": "boolean", "%d": "FS: Occupancy at Closing", "default_val": true }, "fs__assignment_additional_terms_text": { "%v": "text", "%d": "FS: Assignment Additional Terms" }, "pandadocs_fs_template_option_pandadocs_template": { "%v": "option.pandadocs_template", "%d": "PandaDocs FS Template - deleted", "%del": true }, "sell__property_images_list_custom_property_images": { "%v": "list.custom.property_images", "%d": "BS: Property Images" } }, "privacy_role": { "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } }, "user_signed_in_": { "%c": { "%n": { "%n": { "%a": { "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "aa_user" }, "%x": "InjectedValue" }, "%d": "User Signed In", "permissions": { "view_all": true, "search_for": true, "auto_binding": true, "binding_fields": { "0": "sales_price_number", "1": "aa_user", "2": "address_geographic_address", "3": "status_option_deal__stage", "4": "buy__deal_contract_file", "5": "buy__earnest_money_number", "6": "buy__option_fee_number", "7": "closing_date_date", "8": "deal_buy_earnest_money_number", "9": "deal_option_fee_number", "10": "exit_option_deal__exit", "11": "investor_sales_price_number", "12": "sales_agent__sa__user", "13": "buy__seller_s_name_text", "14": "buy__seller_s_email_text", "15": "sell__property_description_text", "16": "sell__property_images_list_image", "17": "home__year_built_number", "18": "home__beds_number", "19": "home__bathrooms_number", "20": "sell__property_images_list_custom_property_images", "21": "sell__mls_packet_file", "22": "fs__option_days_number", "23": "fs__legal_description_text", "24": "listing_agent_email_text", "25": "listing_broker_firm_text", "26": "listing_agent_phone_text", "27": "listing_agent_name_text", "28": "buy_assignment_date_date", "29": "fs_assignor_name_text", "30": "fs__occupancy_per_lease_text", "31": "fs__occupancy_at_closing_text", "32": "fs__assignment_additional_terms_text", "33": "pin_text", "34": "fs_assignor_phone_text", "35": "fs_assignor_address_text", "36": "territory_option_territories", "37": "fs__occupancy_at_closing1_boolean", "38": "fs__occupancy_per_lease_boolean", "39": "bs_monthlyrentexpected_number", "40": "bs_arv_number", "41": "bs_sqfootage_number" }, "view_attachments": true } } } }, "user": { "%d": "User", "%f3": { "name_text": { "%v": "text", "%d": "First Name" }, "phone_text": { "%v": "text", "%d": "Phone" }, "qr_svg_text": { "%v": "text", "%d": "QR_svg - deleted", "%del": true }, "last_name_text": { "%v": "text", "%d": "Last Name" }, "red_account_number": { "%v": "number", "%d": "RED Account" }, "role_option_user_role": { "%v": "option.user_role", "%d": "Role" }, "textmagic_api_key_text": { "%v": "text", "%d": "textmagic_api_key" }, "textmagic_user_id_text": { "%v": "text", "%d": "textmagic_user_id" }, "textmagic_username_text": { "%v": "text", "%d": "textmagic_username" }, "flag_exrole_option_user_role": { "%v": "option.user_role", "%d": "Flag-exRole" }, "annual_units_sold_goal_number": { "%v": "number", "%d": "GOAL: Annual Units Sold" }, "annual_sales_volume_goal_number": { "%v": "number", "%d": "GOAL: Annual Sales Volume" }, "textmagic_phones_list_custom_phone": { "%v": "list.custom.phone", "%d": "textmagic_phones" }, "territories_list_option_territories": { "%v": "list.option.territories", "%d": "Territories" }, "pinned_conversations_custom_conversation1": { "%v": "custom.conversation1", "%d": "pinned conversations - deleted", "%del": true }, "pinned_conversations_list_custom_conversation1": { "%v": "list.custom.conversation1", "%d": "pinned conversations" }, "pinned_conversations1_list_custom_conversation1": { "%v": "list.custom.conversation1", "%d": "pinned conversations - deleted", "%del": true }, "_1234567890_________________________________text": { "%v": "text", "%d": "pkpkp - deleted", "%del": true } }, "privacy_role": { "gm_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "GM", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } }, "everyone": { "%d": "everyone", "permissions": { "view_all": false, "search_for": true, "view_fields": { "0": "email", "1": "role_option_user_role" }, "auto_binding": false, "view_attachments": false } }, "archived_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "archived" }, "%x": "OneOptionValue" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "archived" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Deleted", "permissions": { "view_all": false, "search_for": false, "auto_binding": false, "view_attachments": false } }, "owner_admin_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Owner/Admin", "permissions": { "view_all": true, "search_for": true, "auto_binding": true, "binding_fields": { "0": "name_text", "1": "phone_text", "2": "role_option_user_role", "3": "territories_list_option_territories", "4": "annual_sales_volume_goal_number", "5": "annual_units_sold_goal_number", "6": "red_account_number", "7": "textmagic_api_key_text", "8": "textmagic_username_text" }, "view_attachments": true } }, "counter_deleted_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "aa" }, "%x": "OneOptionValue" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "sa" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Counter Deleted", "permissions": { "view_all": true, "search_for": true, "view_fields": { "0": "role_option_user_role", "1": "territories_list_option_territories", "2": "last_name_text", "3": "name_text", "4": "phone_text", "5": "email" }, "auto_binding": false, "view_attachments": true } } } }, "offer": { "%d": "Offer", "%f3": { "buy_as_text": { "%v": "text", "%d": "Buy As - deleted", "%del": true }, "contract_file": { "%v": "file", "%d": "Deal Contract" }, "sales_agent_user": { "%v": "user", "%d": "Sales Agent" }, "closing_date_date": { "%v": "date", "%d": "Closing Date" }, "occupancy_boolean": { "%v": "boolean", "%d": "Occupancy At Closing? - deleted", "%del": true, "default_val": false }, "option_fee_number": { "%v": "number", "%d": "Option Fee - deleted", "%del": true }, "showing_date_date": { "%v": "date", "%d": "Showing Date" }, "downpayment_number": { "%v": "number", "%d": "Downpayment" }, "offer_price_number": { "%v": "number", "%d": "Offer Price" }, "earnest_money_number": { "%v": "number", "%d": "Earnest Money - deleted", "%del": true }, "signed_contract_file": { "%v": "file", "%d": "Signed Contract" }, "additional_terms_text": { "%v": "text", "%d": "Additional Terms" }, "legal_description_text": { "%v": "text", "%d": "Legal Description - deleted", "%del": true }, "panda_document_id_text": { "%v": "text", "%d": "PandaDoc ID", "%del": false }, "investor_custom_investor": { "%v": "custom.investor", "%d": "Investor 1 - deleted", "%del": true }, "bs_buy_as_co_list_boolean": { "%v": "list.boolean", "%d": "BS:Buy-as Co - deleted", "%del": true }, "proof_of_downpayment_file": { "%v": "file", "%d": "Proof of Down Payment" }, "investor_2_custom_investor": { "%v": "custom.investor", "%d": "Investor 2 - deleted", "%del": true }, "signed_by_investor__boolean": { "%v": "boolean", "%d": "Signed By Investor 1?", "default_val": false }, "downpayment_verified_boolean": { "%v": "boolean", "%d": "Down payment verified", "default_val": false }, "signed_by_investor_2__boolean": { "%v": "boolean", "%d": "Signed By Investor 2?", "default_val": false }, "signed_by_real_equity__boolean": { "%v": "boolean", "%d": "Signed By Real Equity?", "default_val": false }, "signed_by_all_investors__boolean": { "%v": "boolean", "%d": "Signed By All Investors?", "default_val": false }, "offer_status_option_offer__status": { "%v": "option.offer__status", "%d": "Offer Status - deleted", "%del": true }, "r_lst_investors_list_custom_investor": { "%v": "list.custom.investor", "%d": "BS:Investors" } }, "privacy_role": { "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": false, "auto_binding": false, "view_attachments": false } }, "visible_to_creator_": { "%c": { "%n": { "%n": { "%a": { "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "Created By" }, "%x": "InjectedValue" }, "%d": "Visible to creator", "permissions": { "view_all": true, "search_for": true, "auto_binding": true, "binding_fields": { "0": "signed_contract_file", "1": "proof_of_downpayment_file", "2": "downpayment_verified_boolean" }, "view_attachments": true } } } }, "phone": { "%d": "Phone", "%f3": { "agent_user": { "%v": "user", "%d": "agent" }, "number_text": { "%v": "text", "%d": "number" }, "phone_id_text": { "%v": "text", "%d": "phone_id" }, "remaining_texts_number": { "%v": "number", "%d": "remaining_texts", "default_val": 500 } } }, "seller": { "%d": "FS Seller", "%f3": { "__number": { "%v": "number", "%d": "#" }, "name_text": { "%v": "text", "%d": "First Name" }, "email_text": { "%v": "text", "%d": "Email - deleted", "%del": true }, "phone_text": { "%v": "text", "%d": "Phone" }, "email1_text": { "%v": "text", "%d": "Email" }, "address_text": { "%v": "text", "%d": "Address - deleted", "%del": true }, "last_name_text": { "%v": "text", "%d": "Last Name" }, "address_geographic_address": { "%v": "geographic_address", "%d": "Address - deleted", "%del": true } }, "privacy_role": { "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } }, "user_is_logged_in_": { "%c": { "%n": { "%x": "Message", "%nm": "logged_in" }, "%x": "CurrentUser" }, "%d": "User is Logged In", "permissions": { "view_all": true, "search_for": true, "auto_binding": true, "binding_fields": { "0": "email_text", "1": "phone_text", "2": "name_text", "3": "address_text", "4": "email1_text", "5": "last_name_text" }, "view_attachments": true } } } }, "investor": { "%d": "Person", "%f3": { "pof_file": { "%v": "file", "%d": "POF File" }, "name_text": { "%v": "text", "%d": "First Name" }, "agent_user": { "%v": "user", "%d": "Agent" }, "email_text": { "%v": "text", "%d": "Email" }, "notes_text": { "%v": "text", "%d": "Details / Notes" }, "phone_text": { "%v": "text", "%d": "Phone" }, "raport_text": { "%v": "text", "%d": "Raport" }, "company_text": { "%v": "text", "%d": "Company" }, "sign_as_text": { "%v": "text", "%d": "Sign As - deleted", "%del": true }, "attitude_text": { "%v": "text", "%d": "Attitude" }, "timezone_text": { "%v": "text", "%d": "Timezone" }, "last_name_text": { "%v": "text", "%d": "Last Name" }, "locked_boolean": { "%v": "boolean", "%d": "locked", "default_val": false }, "territory_text": { "%v": "text", "%d": "Territory - deleted", "%del": true }, "experience_text": { "%v": "text", "%d": "Experience" }, "is_hot__boolean": { "%v": "boolean", "%d": "Is Top Investor?", "default_val": false }, "pof_flag_boolean": { "%v": "boolean", "%d": "POF Flag", "default_val": false }, "pof_amount_number": { "%v": "number", "%d": "POF Amount" }, "closed_deals_number": { "%v": "number", "%d": "Deals Closed" }, "sms_bounced_boolean": { "%v": "boolean", "%d": "SMS bounced", "default_val": false }, "pending_deals_number": { "%v": "number", "%d": "Deals Pending" }, "contact_document_file": { "%v": "file", "%d": "Contact document" }, "email_bounced_boolean": { "%v": "boolean", "%d": "Email bounced", "default_val": false }, "subscribed_email_text": { "%v": "text", "%d": "Subscribed Email - deleted", "%del": true }, "top_buying_areas_text": { "%v": "text", "%d": "top buying areas - deleted", "%del": true }, "true_dialogue_id_text": { "%v": "text", "%d": "true_dialogue_id - deleted", "%del": true }, "filter_beds_max_number": { "%v": "number", "%d": "filter_baths_max" }, "filter_beds_min_number": { "%v": "number", "%d": "filter_beds_min" }, "territory_count_number": { "%v": "number", "%d": "territory_count" }, "top_buying_areas1_text": { "%v": "text", "%d": "Top buying areas" }, "current_holdings_number": { "%v": "number", "%d": "Holdings" }, "filter_beds_min1_number": { "%v": "number", "%d": "filter_baths_min" }, "filter_beds_min2_number": { "%v": "number", "%d": "filter_beds_max" }, "filter_price_max_number": { "%v": "number", "%d": "filter_price_max" }, "filter_price_min_number": { "%v": "number", "%d": "filter_price_min" }, "filter_sr_ft_max_number": { "%v": "number", "%d": "filter_sq_ft_max" }, "filter_sr_ft_min_number": { "%v": "number", "%d": "filter_sq_ft_min" }, "true_dialogue_id_number": { "%v": "number", "%d": "true_dialog_contact_id" }, "events_list_custom_event": { "%v": "list.custom.event", "%d": "Events" }, "investor_disclosure_file": { "%v": "file", "%d": "Investor Disclosure" }, "sign_as_company__boolean": { "%v": "boolean", "%d": "Sign As Company?", "default_val": false }, "subscribed_email_boolean": { "%v": "boolean", "%d": "Subscribed Email?", "default_val": true }, "type_option_person__type": { "%v": "option.person__type", "%d": "Type", "default_val": "investor" }, "unsubscribed_sms_boolean": { "%v": "boolean", "%d": "Subscribed SMS?", "default_val": true }, "filter_zipcodes_list_text": { "%v": "list.text", "%d": "filter_zipcodes" }, "territory_custom_territory": { "%v": "custom.territory", "%d": "Territory - deleted", "%del": true }, "filter_year_built_max_number": { "%v": "number", "%d": "filter_year_built_max" }, "filter_year_built_min_number": { "%v": "number", "%d": "filter_year_built_min" }, "filter_neighborhood_list_text": { "%v": "list.text", "%d": "filter_neighborhood" }, "true_dialog_account_id_number": { "%v": "number", "%d": "true_dialog_account_id" }, "filter_beds_count_number_range": { "%v": "number_range", "%d": "filter_beds_count - deleted", "%del": true }, "territory_list_option_territories": { "%v": "list.option.territories", "%d": "Territories" }, "investor_disclosure_signed_boolean": { "%v": "boolean", "%d": "Investor Disclosure Signed", "default_val": false }, "investor_type_option_investor_type": { "%v": "option.investor_type", "%d": "investor_type" }, "investor_disclosure_signed_2_boolean": { "%v": "boolean", "%d": "Investor Disclosure Signed 2 - deleted", "%del": true } }, "privacy_role": { "admin_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%x": "CurrentUser" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "agent_user" }, "%x": "InjectedValue" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Admin", "permissions": { "view_all": true, "create_api": false, "delete_api": false, "modify_api": false, "search_for": true, "auto_binding": true, "binding_fields": { "0": "agent_user", "1": "name_text", "2": "sign_as_company__boolean", "3": "email_text", "4": "last_name_text", "5": "company_text", "6": "phone_text", "7": "territory_list_option_territories", "8": "notes_text", "9": "top_buying_areas_text", "10": "raport_text", "11": "pof_amount_number", "12": "top_buying_areas1_text", "13": "experience_text", "14": "current_holdings_number", "15": "attitude_text", "16": "investor_disclosure_file", "17": "filter_beds_count_number_range", "18": "filter_beds_max_number", "19": "filter_beds_min_number", "20": "filter_price_min_number", "21": "filter_year_built_max_number", "22": "filter_beds_min1_number", "23": "filter_neighborhood_list_text", "24": "filter_sr_ft_max_number", "25": "filter_year_built_min_number", "26": "filter_beds_min2_number", "27": "filter_price_max_number", "28": "filter_sr_ft_min_number", "29": "filter_zipcodes_list_text", "30": "investor_type_option_investor_type" }, "view_attachments": true } }, "creator_": { "%c": { "%n": { "%x": "Message", "%nm": "logged_in" }, "%x": "CurrentUser" }, "%d": "Logged In", "permissions": { "view_all": true, "create_api": true, "delete_api": false, "modify_api": false, "search_for": true, "auto_binding": false, "binding_fields": { "0": "investor_disclosure_file" }, "view_attachments": true } }, "everyone": { "%d": "everyone", "permissions": { "view_all": true, "create_api": false, "delete_api": false, "modify_api": false, "search_for": true, "auto_binding": true, "binding_fields": { "0": "unsubscribed_sms_boolean", "1": "subscribed_email_boolean" }, "view_attachments": false } } } }, "messages": { "%d": "Message", "%f3": { "message_text": { "%v": "text", "%d": "messageText" }, "image_attachment_image": { "%v": "image", "%d": "image attachment" }, "creator_email__for_search__text": { "%v": "text", "%d": "creator email (for search)" }, "conversation_custom_conversation": { "%v": "custom.conversation", "%d": "conversation - deleted", "%del": true }, "conversation_custom_conversation1": { "%v": "custom.conversation1", "%d": "Conversation" }, "recepient_email__for_serach__text": { "%v": "text", "%d": "recepient email (for serach)" } }, "privacy_role": { "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } }, "logged_in_": { "%c": { "%n": { "%x": "Message", "%nm": "logged_in" }, "%x": "CurrentUser" }, "%d": "logged in", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } } } }, "email_blast": { "%d": "email blast log", "%f3": { "emails_sent_number": { "%v": "number", "%d": "emails_sent" } } }, "conversation1": { "%d": "Conversation", "%f3": { "conversationparts_list_user": { "%v": "list.user", "%d": "conversationParts" }, "has_unread_messages_list_user": { "%v": "list.user", "%d": "has unread messages" } } }, "title_company": { "%d": "Title Company", "%f3": { "contact_name_text": { "%v": "text", "%d": "Contact First Name" }, "business_name_text": { "%v": "text", "%d": "Business Name" }, "contact_email_text": { "%v": "text", "%d": "Contact Email" }, "contact_phone_text": { "%v": "text", "%d": "Contact Phone" }, "contact_last_name_text": { "%v": "text", "%d": "Contact Last Name" }, "wiring_instructions_file": { "%v": "file", "%d": "Wiring Instructions" }, "address_geographic_address": { "%v": "geographic_address", "%d": "Address" }, "default_territory_option_territories": { "%v": "option.territories", "%d": "Default Territory - deleted", "%del": true }, "wiring_instructions_verified_boolean": { "%v": "boolean", "%d": "Wiring Instructions Verified" }, "default_territories_list_option_territories": { "%v": "list.option.territories", "%d": "Operating Territories" }, "default_for_territory_list_option_territories": { "%v": "list.option.territories", "%d": "Default for territory" } }, "privacy_role": { "owner_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Owner", "permissions": { "view_all": true, "search_for": true, "auto_binding": true, "binding_fields": { "0": "address_geographic_address", "1": "contact_last_name_text", "2": "wiring_instructions_verified_boolean" }, "view_attachments": true } }, "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } } } }, "background_jobs": { "%d": "Background Job", "%f3": { "agent_user": { "%v": "user", "%d": "owner" }, "end_time_date": { "%v": "date", "%d": "end_time" }, "progress_number": { "%v": "number", "%d": "progress" }, "complete_boolean": { "%v": "boolean", "%d": "complete", "default_val": false }, "description_text": { "%v": "text", "%d": "description" }, "acknowledged_boolean": { "%v": "boolean", "%d": "dismissed", "default_val": false }, "completion_message_text": { "%v": "text", "%d": "completion message" } }, "privacy_role": { "admins_": { "%c": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "owner" }, "%x": "OneOptionValue" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%p": { "option_set": "option.user_role", "option_value": "gm" }, "%x": "OneOptionValue" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%n": { "%a": { "%n": { "%n": { "%a": { "%x": "CurrentUser" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "agent_user" }, "%x": "InjectedValue" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "or_" }, "%x": "Message", "%nm": "equals" }, "%x": "Message", "%nm": "role_option_user_role" }, "%x": "CurrentUser" }, "%d": "Admins", "permissions": { "view_all": true, "create_api": true, "modify_api": true, "search_for": true, "auto_binding": false, "view_attachments": true } }, "everyone": { "%d": "everyone", "permissions": { "view_all": true, "search_for": true, "auto_binding": false, "view_attachments": true } } } }, "property_images": { "%d": "Property Image", "%f3": { "image_image": { "%v": "image", "%d": "Image" }, "order___number": { "%v": "number", "%d": "Order #" } }, "privacy_role": { "everyone": { "%d": "everyone", "permissions": { "view_all": false, "search_for": false, "auto_binding": false, "view_attachments": false } } } } } return payload}31:T255c,html = ` Bubble | No-code apps element.constructor == Object)){ if (_array.every(element => Object.keys(element).includes('field'))) { if (_array.every(element => Object.keys(filtered_data_types).includes(element['field']))) { let array_descending_specified = _array.filter(_dict => Object.keys(_dict).includes('descending')); if (array_descending_specified.every(_dict => (typeof(_dict['descending']) == 'boolean' | ['yes','no'].includes(_dict['descending'])))) { return [true, "The 'Sort by' field passed all validation checks"] } else return [false, "The 'Sort by' field has at least one dictionary with a 'descending' value that is not of type boolean. Please provide any of the following values: true, false, yes, no."] } else return [false, "The 'Sort by' field has at least one dictionary with a 'field' value that referrs to a non-existant sort field in your Bubble app. Please check capitalization of the provided field names."] } else return [false, "The 'Sort by' field has at least one dictionary that's missing a 'field' key. Please add field keys to all dictionaries provided."] } else return [false, "The 'Sort by' field contains something other than a list of dictionaries."] }34:T458,function process_sort_fields(sort_by_object, search_provider, option_fields) { // Assuming that all fields provided are actually available (to be validated above) function set_sort_defaults(_object){ return { descending: _object.descending || true, ..._object } } function stringify_descending(_boolean) { return _boolean ? 'desc':'asc' } function convert_option_field(field){ if (option_fields.includes(field)) { return field + '_sort' } else return field } // TODO select _sort column to sort if requested column to sort is for an option. // TODO validate object sort_by_object = sort_by_objects.map(e => set_sort_defaults(e)) if (search_provider == 'Typesense'){ sort_by_object = sort_by_object.slice(0,3) //Take up to at most 3 sort fields let sort_by_string = '' for (const key in sort_by_object) { sort_by_string = `${sort_by_string},${convert_option_field(sort_by_object[key].field)}(missing_values: last):${stringify_descending(sort_by_object[key].descending)}` } return sort_by_string.replace(',','') } }35:[] 2d:{"id":"31c2376d5bfce27b","slug":null,"title":"Get data types, option sets and process them","thumbnail":"9fbd0cf6d99edf3555a48e8c73a763b2406438dff35a0e951fc065932f44f2d4","access_level":"public","create_time":"$D2022-12-19T17:55:19.711Z","update_time":"$D2022-12-30T21:16:28.529Z","view_time":null,"first_public_time":"$D2022-12-19T17:55:19.711Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"da7b4e36c3f89005","login":"zeluspudding","name":"Andrew Agostini","avatar_url":"https://avatars-next.observableusercontent.com/28d9c8bd8fac1732bdb9d9b16cfa6c394441dc6edc87b8c68e5fff9eda7d413d","tier":"starter_2024"},"version":712,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"37287bb81d17aa43","login":"zeluspudding","name":"Andrew Agostini","avatar_url":"https://avatars-next.observableusercontent.com/28d9c8bd8fac1732bdb9d9b16cfa6c394441dc6edc87b8c68e5fff9eda7d413d","tier":null}],"members":[{"type":"individual","id":"37287bb81d17aa43","login":"zeluspudding","name":"Andrew Agostini","avatar_url":"https://avatars-next.observableusercontent.com/28d9c8bd8fac1732bdb9d9b16cfa6c394441dc6edc87b8c68e5fff9eda7d413d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Get data types, option sets and process them","cells":[{"id":0,"value":"# Get data types, option sets and process them","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"result = {return {}}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"function sort_options(dict) {\n var sorted_object = Object.fromEntries(\n Object.entries(dict).sort((a, b) => a[1] - b[1])\n );\n for (const [index, [key, value]] of Object.entries(Object.entries(sorted_object))) {\n sorted_object[key] = index;\n }\n return sorted_object\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"//option_sets_clean_1 = { dict(v)['%d']:dict(v)['values'] for k,v in option_sets.items() if 'values' in dict(v).keys()}\n{for (const [k, v] of Object.entries(option_sets)) {\n if (Object.keys(v).includes('values')) {\n var temp_object = {}\n for (const [k_inner, v_inner] of Object.entries(v['values'])) {\n if (!Object.keys(v_inner).includes('%del')) {\n temp_object[v_inner['%d']] = v_inner['sort_factor']\n }\n }\n let sorted_options = sort_options(temp_object)\n if (Object.keys(sorted_options).length > 0) {\n result[k] = sorted_options\n }\n }\n}}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"result","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"name = \"Background Job\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"function trim(x) {\n return x.replaceAll(/[^0-9a-zA-Z ]/g,'_').replace(/^\\s+|\\s+$/gm, '') // replace non alpha numeric then trim leading and trailing whitespace \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"trim('Background Job '.replaceAll(/[^0-9a-zA-Z ]/g,'_'))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"Object.entries(payload).map( e => trim(e[1]['%d']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"Object.entries(payload).map( e => e[1]['%f3'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"data_dict = {return {}}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"{for (const [k, v] of Object.entries(payload)) {\n if (Object.keys(v).includes('%f3')) {\n var temp_object = {}\n for (const [k_inner, v_inner] of Object.entries(v['%f3'])) {\n if (!Object.keys(v_inner).includes('%del')) {\n temp_object[v_inner['%d']] = v_inner['%v']\n }\n }\n data_dict[v['%d']] = temp_object\n }\n}}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"Object.values(data_dict).map( e => Object.values(e))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"html.match(/\\/package\\/dynamic_js.*\\/dynamic\\.js/)[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"app_option_sets = {return {\"role\":{\"Owner\":\"0\"},\"test\":{\"PASS\":\"0\",\"FAIL\":\"1\",\"NOT_RUN\":\"2\"},\"colors\":{\"Passing Green\":\"0\",\"Fail Red\":\"1\",\"Paused Grey\":\"2\"},\"scratch\":{\"ffgf\":\"0\"},\"categories\":{\"media\":\"0\",\"location\":\"1\",\"technical\":\"2\",\"social network\":\"3\",\"news\":\"4\",\"web scraping\":\"5\",\"input forms\":\"6\",\"video\":\"7\",\"email\":\"8\",\"visual elements\":\"9\",\"health & fitness\":\"10\",\"payment\":\"11\",\"analytics\":\"12\",\"data (things)\":\"13\",\"testing\":\"14\",\"small business\":\"15\",\"productivity\":\"16\",\"mobile\":\"17\",\"customer support\":\"18\",\"internationalization\":\"19\",\"blog\":\"20\",\"ecommerce\":\"21\",\"compliance\":\"22\",\"containers\":\"23\",\"energy\":\"24\"},\"search_filter\":{\"Show All\":\"0\",\"Open Source\":\"1\",\"Premium\":\"2\"},\"option_example\":{\"Option1\":\"0\",\"Option2\":\"1\"}}}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"Return date_columns = []","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":386,"value":"function filter_data_types(app_schema, bubble_table, bubble_column_names) {\n let bubble_table_schema = Object.values(app_schema[bubble_table])[0]\n if (bubble_column_names.length == 0) {\n return bubble_table_schema\n } else {\n return Object.keys(bubble_table_schema).filter((key) => bubble_column_names.includes(key)).reduce((cur, key) => { return Object.assign(cur, { [key]: bubble_table_schema[key]})}, {});\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"// bubble_column_names = ['Modified Date']\n// bubble_column_names = ['Modified Date','deleted','all_versions_rating','Slug','role']\n// bubble_column_names = ['Modified Date','deleted','all_versions_rating','Slug']\nbubble_column_names = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"bubble_table = \"user\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"filtered_data_types = filter_data_types(app_data_types, bubble_table, bubble_column_names)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":286,"value":"Return the set of option enumeration that users wants to sort on","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":429,"value":"function filter_option_sets(sort_column_names, app_option_sets, filtered_data_types){\n var sortable_option_fields = Object.keys(filtered_data_types).filter(function(key) {\n if (filtered_data_types[key].includes('option.') & sort_column_names.includes(key)) {\n return key;\n }\n })\n return Object.keys(app_option_sets)\n .filter((key) => sortable_option_fields.includes(key))\n .reduce((cur, key) => { return Object.assign(cur, { [key]: app_option_sets[key]})}, {});\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":458,"value":"sort_column_names = ['Modified Date','deleted','all_versions_rating','Slug','role']\n// sort_column_names = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":434,"value":"filter_option_sets(sort_column_names, app_option_sets, filtered_data_types)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":487,"value":"## Process sort options / set defaults","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":489,"value":"sort_by_objects = [\n // {\n // \"field\": \"field_to_sort\",\n // // \"descending\": false,\n // },\n // {\n // \"field\": \"another_field\",\n // \"descending\": true,\n // },\n {\n \"field\": \"role\",\n \"descending\": 'yes',\n },\n // {\n // \"field\": \"role\",\n // // \"descending\": true,\n // },\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"validate_sort_array(sort_by_objects, filtered_data_types)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":580,"value":"option_fields = Object.keys(Object.keys(app_data_types.user.User).reduce((p, key) => { \n if (app_data_types.user.User[key].includes('option.')) p[key] = app_data_types.user.User[key];\n return p;\n}, {}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":593,"value":"process_sort_fields(sort_by_objects, 'Typesense', option_fields)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"sort_by_object = `[\n {\n \"field\": \"usage_count\",\n \"descending\": true,\n }\n]`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 2e:"$2d:body"