Custom App Module - AG Grid Table Generator

[Roney_Dsilva]

@Audioboy

Bug:
Configure fields: If I do something like this to create a name from disparate fields : %firsrt_name% %middle_name% %last_name% and the field middle_name is null it shows as “null” in the display of the composite name. If that same middle_name field is given it’s own column in the grid this it not the case. It correctly shows as nothing.

@Audioboy

Ability to choose the display order vs it just following the order of the data fields passed in.

Above bugfix and feature have been released in @cdmx/wappler_ag_grid@1.7.4

@cdmx/wappler_ag_grid

[Roney_Dsilva]

@Audioboy

Global search: If I have a first name last name field and I combine them ( %firsrt_name% %last_name% ) into one full name for display and use the first_name column for that, then only first name is used in the search. It would be nice to control what fields are used in search vs search only working with fields that are displayed.

Added support for this - Search/Filters will now work on display manipulated data.
@cdmx/wappler_ag_grid@1.7.5

@cdmx/wappler_ag_grid

[Roney_Dsilva]

@Audioboy

The grid automatically includes all fields present in my data, and I have to remember to remove a field if the data API changes what is returned. It would have been better to allow me to control what is used by the grid vs what is not used.

It would be better to use a AC formatter for this, like the one below:

<script>
    dmx.Formatter('array', 'splitOut', function(array, exclude) {
    let excludeKeys = exclude.split(',');
    return array.map(item => {
        let newItem = {};
        for (let key in item) {
            if (!excludeKeys.includes(key)) {
                newItem[key] = item[key];
            }
        }
        return newItem;
    });
});
</script>

[Audioboy]

Roney, Thank you. I tested the field exclusion during csv export and it worked so thank you very much for the support.

Another bug maybe related or not? The grid goes into a pattern of continous redraw when I try to name the csv file:
dmx-bind:export_csv_filename="'appointments_'+var_cur_datetime.datetime+'.csv'"

Paul

[Roney_Dsilva]

Hi @Audioboy,
Am unable to replicate this issue, its working fine for me.

dmx-bind:export_csv_filename="'appointments_'+var1.datetime+'.csv'"

can you share a screenshot of what issue your facing

[Roney_Dsilva]

@cdmx/wappler_ag_grid

Released Beta support for Exporting Grid Data to PDF (Color changes included).
Added support for Class Toggles for Action Buttons.
Added 10 more buttons in Custom Action Buttons.

[TMR]

@Roney_Dsilva

@cdmx/wappler_ag_grid - npm

I updated my existing extension and now my tables are greyed out when the page loads, I'm not seeing any console errors, any ideas on what this could be?

[TMR]

Update:

It was the 'enable overlay' option. I deselected it and the table worked as normal:

I don't mind having this disabled so its not an issue for me, maybe this will help someone with a similar issue..

[Roney_Dsilva]

Thanks for the update @TMR.
Will look into this.

[Roney_Dsilva]

All bugs/Issues which had been reported have been fixed in v1.8.13

@cdmx/wappler_ag_grid

[Luis_Saldana]

Thanks for this great extension @Roney_Dsilva ¿Could you include the Spanish translation to the locale?

https://gist.github.com/HunabkuTech/edf885a43165811b1d571ea0f3cb1592

[Roney_Dsilva]

Hi @Luis_Saldana,
Sure, will add this support in the next release.

[Roney_Dsilva]

Support for Spanish(ES) released in 1.9.7

@cdmx/wappler_ag_grid

[Luis_Saldana]

Hi @Roney_Dsilva, thank for the release After updating the extension I am facing this error:

More details:

I don't know if I am doing something wrong, but, the first time I tried to update the extension using this command from terminal:

npm i @cdmx/wappler_ag_grid

I restarted Wappler and I got the error. The second attempt was from the Project Options -> Extensions, removing (restarting) and installing again (restarting) the extension, but I had the same error.

The translation appears in the menu option of the extension

Thanks for your help!!

[Roney_Dsilva]

Hi @Luis_Saldana,
Could you please try adding additional AG Grid, on same page or different page which is using the same layout, just so to trigger copy of the locale.min.js file occurs into the public/js folder, and same should get linked in head of the layout, i see that the trigger didn't happen automatically in your case post updating the AG grid.

[Luis_Saldana]

Thanks for the immediate response.

That's it, after added a new AG Grid, the system was correctly updated, thanks for the effort on this @Roney_Dsilva !!

[steveni]

Hi @Roney_Dsilva, Trying this for the first time today and very impressed! I have a question. In my table I have an image shown as a path. I would like to have that show as the image. I think I would do that using Advanced Data Manipulation but I can't work out how to do that. First, is it possible, and can you give me an example? I am using the sample data from wappler and looking at the user table with the user avatar. Field is a text field named avatar.

[Roney_Dsilva]

Hi @steveni,
This might be possible with Display Manipulation - JS Function:

Haven't tried with images before though, give it a go, below is a sample:

<script>
 function jsChanges(data) {
   const html = `
     <div>
       <img src="${data.avatar}" alt="User Avatar" style="max-width: 100px; height: auto;"/>
     </div>`;
   return html;
 }
</script>

Add your function onto the page

specify the field name in first column ex: avatar
specify the function name in the second column ex: jsChanges

[steveni]

@Roney_Dsilva

<script>
 function jsChanges(data) {
   const html = `
     <div>
       <img src="${data.avatar}" alt="User Avatar" style="max-width: 100px; height: auto;"/>
     </div>`;
   return html;
 }
</script>

Thanks @Roney_Dsilva. You are a genius. Worked perfectly!