Search found 252 matches

by wingedpotato
05 Feb 2021, 12:11
Forum: Discussion
Topic: Query Difference in app and database
Replies: 6
Views: 248

[SOLVED] Re: Query Difference in app and database

Ow,so that's where I'm wrong. 🤦‍♂️
Thank you very much
by wingedpotato
05 Feb 2021, 07:05
Forum: Discussion
Topic: Query Difference in app and database
Replies: 6
Views: 248

Re: Query Difference in app and database

'kay, Then, how do I separate a new record (still inputing in form view) with editing a record...? I tried to use AJAX Request to get the ID of the new record, it come up as 0. This means that this record is new and don't have any ID yet right...? $item_id = $_GET['item_id']; $nopol = [499]; if($ite...
by wingedpotato
22 Jan 2021, 10:36
Forum: Discussion
Topic: Query Difference in app and database
Replies: 6
Views: 248

Re: Query Difference in app and database

Oh sorry, my bad.
But I think I know now why.
So PHP Code is executed after adding or editing record right...?
That's explains it... 😅

OK, that matters solved.
So If I want to get a value while in form page,I used Ajax request. Correct...?
by wingedpotato
22 Jan 2021, 06:50
Forum: Discussion
Topic: Query Difference in app and database
Replies: 6
Views: 248

Query Difference in app and database

Hello support,

I have a curious case about querying.
This is a first time entry and the database is still empty.

When I query count directly in the database, is shows "0" records.
But when I'm using PHP Code to do the query and count, it shows "1" record.

Any idea about this...?
by wingedpotato
22 Jan 2021, 05:16
Forum: Discussion
Topic: [SOLVED] How to modify Static Text by Pattern field (PHP Code)
Replies: 12
Views: 893

Re: How to modify Static Text by Pattern field

See simple example: if(!strlen($current_field_value)) { $output_value = time(); } else { $output_value = $current_field_value; } If $current_field_value is empty we assigned some value and in other case we output exist value. Ow, OK. Just like that. I thought there something else. 😅 Thank you very ...
by wingedpotato
21 Jan 2021, 14:51
Forum: Discussion
Topic: [SOLVED] How to modify Static Text by Pattern field (PHP Code)
Replies: 12
Views: 893

Re: How to modify Static Text by Pattern field

Hello support. Thank you for the great update in PHP Code Field. I still don't get to how to use the $current_field_value. I have a code like this, $idkat = [1276]; $idgrup = [1275]; // ambil nama grup $info_query = db_query("SELECT DISTINCT name FROM app_global_lists_choices WHERE id =".$idgrup ); ...
by wingedpotato
17 Dec 2020, 05:06
Forum: Discussion
Topic: [SOLVED]Export Import Field
Replies: 6
Views: 136

Re: Export Import Field

OK, thank you for the explanation... 👍
by wingedpotato
16 Dec 2020, 14:46
Forum: Discussion
Topic: [SOLVED]Export Import Field
Replies: 6
Views: 136

Re: Export Import Field

You can import the filed to the same entity but will be imported as NEW field. Not update exist one. Yes, I also understand that it will added as a new field. So basically, I can't change anything from the export file to import in the same entity right...? I can change it after it's imported on Fie...
by wingedpotato
16 Dec 2020, 14:32
Forum: Discussion
Topic: [SOLVED]Need help or suggestion...
Replies: 4
Views: 111

Re: Need help or suggestion...

OK,I'll try and info is anything is wrong.

Thank you
by wingedpotato
16 Dec 2020, 11:32
Forum: Discussion
Topic: [SOLVED]Need help or suggestion...
Replies: 4
Views: 111

Re: Need help or suggestion...

support wrote:
16 Dec 2020, 10:16
Other solution you can open phpmyadmin and remove some indexes for table app_entity_x
so it will allows you create extra fields.
I'm trying to ask the host first.
But your 2nd solution, is it OK to just remove indexes...?
Screenshot_14.png
Is this it...?