Store Account Id of Submitting User in Submission

[grahame]

Hi

It turns out there is a little more to do to get this working productively. When the admin creates a new form, I think a 'default' view is also created. Now although the Account_ID column has been added OK, you still cannot use it in the 'default' view because the new column has not been assigned to that view.

So… again, in the ft_finalize_form,end hook, first add the new column to the form_fields table:

Code:

$table_prefix = "ft_";
$query = "INSERT INTO {$table_prefix}form_fields (form_id,field_name,
  field_size,field_type_id,is_system_field,
  data_type,field_title,col_name,
  list_order,is_new_sort_group,include_on_redirect)

  VALUES($form_id,'Account_ID',
         'medium',1,'yes',
         'string','Account ID','account_id',
          (SELECT * FROM (SELECT MAX(list_order) +1 FROM {$table_prefix}form_fields
WHERE form_id = $form_id ) AS X),'yes','no')";
@mysql_query($query);

Then you need to add the column-view assignment

Code:

$query = "INSERT INTO {$table_prefix}view_columns (view_id,field_id,list_order, is_sortable,auto_size,custom_width,truncate)
  VALUES((SELECT view_id FROM {$table_prefix}views WHERE form_id = $form_id), (SELECT field_id FROM {$table_prefix}form_fields WHERE form_id = $form_id AND col_name = 'account_id'),(SELECT * FROM (SELECT MAX(list_order) +1 FROM {$table_prefix}view_columns
WHERE view_id = (SELECT view_id FROM {$table_prefix}views WHERE form_id = $form_id) ) AS X),'yes','yes','','no_truncate')";
@mysql_query($query);

Please keep in mind, I'm a newbie at Formtools, so check everything carefully!!