Skip to main content
Question

Template for Field Names to Jinja

  • August 17, 2021
  • 0 replies
  • 42 views

Forum|alt.badge.img+4
Does anyone know of a template for converting the field names in a table to the correct jinja format?

e.g. Field ID 7: Order Submitted By will convert to order_submitted_by

I have tried to use a formula field and inputted some common conversions I have seen, but I doubt it is even half of it:

var text idsCheck = SearchAndReplace([Label], "IDs","i_ds");
var text low = Lower($idscheck);
var text nospace = SearchAndReplace($low, " ","_");

var text aa = SearchAndReplace($nospace,"-","_");
var text ab = SearchAndReplace($aa,"/","_");
var text ac = SearchAndReplace($ab,"_%","");
var text ad = SearchAndReplace($ac,"_#","");
var text ae = SearchAndReplace($ad,"?","");


------------------------------
Sean Connaughton
------------------------------
This topic has been closed for replies.