Problem with viewing records

[lazysheepmedia]

Folks

I have an issue with creating of records

I have a form which you can see here

http://www.lettingagentsupportklub.co.uk/component/fabrik/form/29/6.html

Down the bottom will have the name of agent filling out the form.

If you now look at this one it shows a different agents name

http://www.lettingagentsupportklub.co.uk/component/fabrik/form/29/9.html

The issue I have is that when the user creates the record and they know what they are doing, they simply change the name of the id in the url and it shows another users record. I am sure a filter will solve this but I am not that conversant and so far been unable to get them to work.

Can I change the url so it shows a random id like this?

http://www.lettingagentsupportklub.co.uk/component/fabrik/form/29/1ere453455tyger.html

Thanks

 

[felixkat]

Hi Mark,

None of those links worked for me.


Can you not use something like the user element with permissions? This would lock down each record only allowing a user to view or edit his own record.

 

[cheesegrits]

What felix said. Include a 'user' element on your form, at which point you can do two things:

In the "Access" for the table, you can set 'edit rows' to 'or use ...' the user element, so users can only edit their own forms.

In the pre-filters on the list, you can add a filter:

WHERE
Field: userid(raw)
Condition: EQUALS
Value: {$my->id}
Type: text

... and apply it to an access level which makes sense for your application, so users viewing the list can only see "their" rows.

-- hugh

 

[lazysheepmedia]

good stuff thanks guys - working great now - another gold for teamFabrik!

 

[felixkat]

Great, closing this thread