Search found 174 matches

by eddydeniro
13 Sep 2021, 19:07
Forum: Discussion
Topic: Allow access to records from entity field
Replies: 8
Views: 518

Re: Allow access to records from entity field

On the other hand I do not understand what you mean by "apply accessibility in operational entities, making the Company as the connector only with Record Visibility" It's exactly like Sergey's example in the docs. I added more fields to entity Users including company, position, etc. Some ...
by eddydeniro
13 Sep 2021, 16:01
Forum: Discussion
Topic: Allow access to records from entity field
Replies: 8
Views: 518

Re: Allow access to records from entity field

Hi, sorry to barge in but I had faced similar situation as yours, only I decided to apply accessibility in operational entities, making the Company as the connector only with Record Visibility. Anyway if you want to automate filling that field, maybe you can create a PHP Code field as post-input pro...
by eddydeniro
13 Sep 2021, 15:03
Forum: Discussion
Topic: [SOLVED] Copy Record PHP Code Fields.
Replies: 11
Views: 781

Re: Copy Record PHP Code Fields.

Yes, but the Auto-increment field cannot be reset yearly or with the condition that I wanted. You're right. I just checked the class, it search the min/max of entire table, not last-record field value. Only when the entity has parent will enable it to separate numbering. What I'm still lack is the ...
by eddydeniro
12 Sep 2021, 06:29
Forum: Discussion
Topic: Year on auto increment
Replies: 6
Views: 534

Re: Year on auto increment

I dont think it's possible. The year is dynamic to use as prefix. But you can combine with PHP Code and you use this field for numbering. For example: if(!strlen($current_field_value)){ //Let's say the entity id is 10, increment number field id is 200, and the date_added is the year reference, and y...
by eddydeniro
10 Sep 2021, 23:44
Forum: Discussion
Topic: Function MySQL
Replies: 6
Views: 451

Re: Function MySQL

The field [997] and [775] are both fieldtype date and, if you can see the entity table via phpmyadmin, their data type is integer (or bigint to be exact) and value [774] is not dynamic, right? Try testing the query directly in phpmyadmin to the blank field_997 record: SELECT IF(field_997>field_775,f...
by eddydeniro
10 Sep 2021, 16:05
Forum: Discussion
Topic: [SOLVED] Copy Record PHP Code Fields.
Replies: 11
Views: 781

Re: Copy Record PHP Code Fields.

The problem predictably occured because when the field value is not empty, you requery the entity instead and in editing, it will result empty value once again. I think you'd better lock the value like this: if(!strlen($current_field_value)) { $date = [date_added]; $year = date('Y',$date); //the dat...
by eddydeniro
10 Sep 2021, 14:15
Forum: Discussion
Topic: [SOLVED] Copy Record PHP Code Fields.
Replies: 11
Views: 781

Re: Copy Record PHP Code Fields.

I see. So you're making increment number that reset each year. I think you can make your code simpler so that you just access mysql once instead of 3 times, for example: $date = [date_added]; $year = date('Y',$date); $query = db_query("SELECT COUNT(*) c FROM app_entity_101 WHERE date_added < &q...
by eddydeniro
10 Sep 2021, 08:17
Forum: Bug Report version 2.9
Topic: Roles Issues Still
Replies: 5
Views: 413

Re: Roles Issues Still

That's strange.
In my 2.9.2, I can assure you that if a user has only access View, when he's assigned a role which overrides his privilege in parent entity, he'll get that access for specific subentity (create, update, delete, etc).
by eddydeniro
10 Sep 2021, 06:56
Forum: Discussion
Topic: [SOLVED] Copy Record PHP Code Fields.
Replies: 11
Views: 781

Re: Copy Record PHP Code Fields.

Well, I suggest that because I see your query is dynamic, finding for duplicates. I guess that's not the whole code, right? Because I cant see where $output_value gets its initial value. When you get any duplicate eventually, then at least one previous record will get the wrong value and you have to...
by eddydeniro
10 Sep 2021, 04:54
Forum: Suggestions
Topic: Duplicate Warning
Replies: 13
Views: 994

Re: Duplicate Warning

Yep, that's right!