Add a button for websites

Hello @JDodd and welcome to our forums

Can you please give a more specific example of what you are trying to do? I mean if you can add the code that you were using on the older versions that worked for you and what you have tried that doesn’t work should help.

Regards
Johnny

Hello @JDodd and first of all happy new year

Ok, now I am getting the frustration that you had. I will try to update the documentation as this is a very common question that I have and it is not clear at the documentation. so your code will look similar to this (but there is a hint):

$crud->columns(['customerName','phone','your_field_name']);
$crud->setActionButton('your_field_name', 'fa fa-plus', function ($row) {
    return "SITE/maps?q=" . $row->lat . "," . $row->lng;
});

However, this will not work as the lat and lng will not be available for your datagrid. In short, for performance and security reasons I’ve removed the * from the SELECT of all the columns that I had before from 2.8.0 and later. Now you simply have to specify the columns as invisible columns. So your example will look like this:

$crud->columns(['customerName','phone','your_field_name', 'lat', 'lng']);
// By using the fieldTypeColumn you specify that the `invisible` 
// field type will only be on the datagrid columns
$crud->fieldTypeColumn('lat', 'invisible');
$crud->fieldTypeColumn('lng', 'invisible');

$crud->setActionButton('your_field_name', 'fa fa-plus', function ($row) {
    return "SITE/maps?q=" . $row->lat . "," . $row->lng;
});

I hope this will work for you.

Hello @JDodd , sorry my mistake, I thought that you were referring to Grocery CRUD Enterprise edition. I will check the same for the community edition and let you know.

Regards
Johnny

So @JDodd I’ve investigated the issue and on community edition the first argument is the value but the $row is on the second parameter. So your example will look like this:

$crud->setActionButton('Avatar', 'fa fa-plus', function ($value, $row) {
     return "SITE/maps?q=" . $row->lat . "," . $row->lng;
});

I will try to also update the documentation.

Let me know if that worked for you.

Regards
Johnny

Hello @JDodd ,

The closest that we have for that is the setRelation. You can see an example at the datagrid here: setRelation | Grocery CRUD - A PHP CRUD Generator Library

Just scroll right to see the “City” quick search.

We also have the fieldType ‘dropdown_search’ that does pretty much the same.

If you are looking about an ajax search implementation then this is not available yet in Grocery CRUD Enterprise.

Regards
Johnny

You can implement this using multiple checkboxes or multi-select dropdowns.