0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

rex0220 計算式プラグイン 文字列からテーブルセット

Posted at

計算式プラグインで、文字列からテーブルに値をセットしてみます。

概要

文字列項目にセットしたカンマ区切りの値からテーブル内項目に値をセットします。
"AA,BB,CC,DD" の文字列から、テーブルの区分に "AA","BB","CC","DD" をセット

2025-05-29_13h20_51.png

操作例

2025-05-29_13h26_26.gif

計算式プラグイン設定

「テーブル入力」の値を配列に変換後、TABLE_DATA 関数で「区分」に設定します。

2025-05-29_13h23_07.png

OPTION: 

// テーブル SUBTABLE
TABLE_DATA(ARRAY_MAP(SPLIT(テーブル入力,",",1),val,
  DIC("区分",val)
))

// テーブル.区分 SINGLE_LINE_TEXT
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?