how to load current user's data in single form

[MeAppBuilder]

Hello,

sorry that I have to ask this, but I can't figure it out.

I have a FORM MODULE for contact details. I am trying to load user's data, based on his Joomla ID. I can add a single data line for one user, but form won't refresh with this data line.

I have tried to set

row id = -1
Use key: id_uk_user -> this is where Joomla ID will be in contact detail table

When I refresh the form, I get an error:

1054
Unknown column 'fabrik_user_contact.id' in 'field list'

I have tried to refresh, but it didn't work.
Thankful for any help

 

[troester]

didyou try to enable or disable the Ajaxfy setting?
is id_uk_user the correct element name? (I'm not sure if usekey needs it with or without the table name)

Gesendet von meinem SM-G930F mit Tapatalk

 

[MeAppBuilder]

tried enabled and disabled...same error.
Looks like the module will not take my custom primary key, which is INT 11 + pk in MySQL.

What could cause this?

 

[cheesegrits]

Does it work if you try the same thing either in a Fabrik form component menu link, or just doing it on the URL ...

index.php?option=com_fabrik&view=form&formid=123&rowid=-1&usekey=id_uk_user

Obviously change the formid to suit.

Looks like the module will not take my custom primary key, which is INT 11 + pk in MySQL.

Not sure what you mean by "INT 11 + pk".

-- hugh

 

[MeAppBuilder]

...some more testing...