Formula javascript

[VociNur]

Hey, I can’t use javascript in formula,
I have a code in "/js/test.js"

function test(){
    return "test";
}
module.exports = test;

I’m using the formula
${db.js.test()}

So my filename seems good, in setting, I activated the JS, and select the folder "js"
What is the problem ?

[RafaelGB]

It seems correct. You can check the console logs enabling them inside the developer settings section (warning level will be enough)

I will check it myself with the same example

[VociNur]

I enable all setting section, but I don’t know where the logs are
And during this time, I see something:

Settings in DB Folder are activated

But in setting table, it isn’t

And if I active them, my table disapear

[RafaelGB]

you can see the logs with ctrl+shift+i

I will investigate your issue the afternoon

[RafaelGB]

A quick test seems to work

Screen.Recording.2023-01-29.at.12.44.57.mov

[VociNur]

Sorry for the wait !

2023-01-29.13-26-52.mp4

[RafaelGB]

which version are you using? 3.3.0?

the problem of your video was resolved (I hope) with the beta of the last version.

Try to restart the Obsidian app

[VociNur]

Versions:
Obsidian: 1.1.9
Dataview: 0.5.55
DB Folder: 3.3.0

[RafaelGB]

🤕 I will check more use cases then

about the formulas, could you share your db file?

[VociNur]

This ? If you want to go on Discord I can, like this I can show you directly something if you have a question

database-plugin: basic

---

name: new database
description: new description
columns:
  __file__:
    key: __file__
    id: __file__
    input: markdown
    label: File
    accessorKey: __file__
    isMetadata: true
    skipPersist: false
    isDragDisabled: false
    csvCandidate: true
    position: 1
    isHidden: false
    sortIndex: 1
    isSorted: true
    isSortedDesc: false
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: true
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Date:
    input: calendar
    accessorKey: Date
    key: Date
    id: Date_appris
    label: Date appris
    position: 2
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Col1:
    input: checkbox
    accessorKey: Col1
    key: Col1
    id: 1st_rep
    label: 1st rep
    position: 3
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Col2:
    input: checkbox
    accessorKey: Col2
    key: Col2
    id: 2st
    label: 2st
    position: 4
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Col3:
    input: checkbox
    accessorKey: Col3
    key: Col3
    id: 3st
    label: 3st
    position: 5
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Col4:
    input: checkbox
    accessorKey: Col4
    key: Col4
    id: 4st
    label: 4st
    position: 6
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
  Next_rep:
    input: formula
    accessorKey: Next_rep
    key: Next_rep
    id: Next_rep
    label: Next rep
    position: 100
    skipPersist: false
    isHidden: false
    sortIndex: -1
    config:
      enable_media_view: true
      link_alias_enabled: true
      media_width: 100
      media_height: 100
      isInline: false
      task_hide_completed: true
      footer_type: none
      persist_changes: false
      formula_query: ${db.js.test()}
config:
  remove_field_when_delete_column: false
  cell_size: normal
  sticky_first_column: false
  group_folder_column: 
  remove_empty_folders: false
  automatically_group_files: false
  hoist_files_with_empty_attributes: true
  show_metadata_created: false
  show_metadata_modified: false
  show_metadata_tasks: false
  show_metadata_inlinks: false
  show_metadata_outlinks: false
  source_data: current_folder
  source_form_result: 
  source_destination_path: /
  row_templates_folder: /
  current_row_template: 
  pagination_size: 10
  font_size: 16
  enable_js_formulas: false
  formula_folder_path: js
  inline_default: false
  inline_new_position: last_field
  date_format: yyyy-MM-dd
  datetime_format: "yyyy-MM-dd HH:mm:ss"
  metadata_date_format: "yyyy-MM-dd HH:mm:ss"
  enable_footer: false
  implementation: default
filters:
  enabled: false
  conditions:

[RafaelGB]

I'll keep an eye on it as soon as I can, if not this afternoon, tomorrow 😀 ai will share the discord if we can not find the problem

[vagrant-psyche]

I know the reason. If you activate the JS in plugin global settings, then you open the old database that was created previously, you will find that you still don't activate the JS in database settings.

So the solution are

1. activate the JS in database settings which is in the old database created previously.
2. create a new database, you will find JS is activated the JS in database settings by default.

@RafaelGB
@VociNur

[FlipH19Switch]

@RafaelGB
@VociNur

Was this ever resolved? I'm having a similar issue where my functions are not being recognized.

I tried this on a new vault using only the Dataview and DB Folder plugins. I have JavaScript enabled in the correct places as far as I can tell.

Plugin:

Table:

Here is the code inside my "test.js" file inside of my "js" folder:

function test() {
console.log("Test");
}

module.exports = test;

And my code in the formula column:

${db.js.test()}

Yet I get this error when opening the table:

[LynetteCullens]

You have to edit the database in markdown mode to enable .js. Doing it in settings will not work.

[FlipH19Switch]

You have to edit the database in markdown mode to enable .js. Doing it in settings will not work.

My table shows these settings in markdown:

enable_js_formulas: true
formula_folder_path: js

But the console still says that db.js.test is not a function.

[LynetteCullens]

You have to edit the database in markdown mode to enable .js. Doing it in settings will not work.

My table shows these settings in markdown:

enable_js_formulas: true formula_folder_path: js

But the console still says that db.js.test is not a function.

Modifying the settings using the table interface does not work for me. Try switching between the table and markdown view to see if the settings were actually applied.