Search found 72 matches

by AEmpeno
2021-11-10 17:39
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 6
Views: 512

Re: Julian date

Thanks, pböttcher! It worked!
by AEmpeno
2021-10-18 18:58
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 6
Views: 512

Re: Julian date

Yes, I'm expecting as 21290 as the answer:

10/17/2021 = 21290 (21-Year, 290-10/17)
by AEmpeno
2021-10-18 03:23
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 6
Views: 512

Re: Julian date

Thanks for your reply, pböttcher. Here is what I'm getting.

2459505 = 10/17/2021 (date)

SELECT TO_DAYS(date)+1721060
FROM `brine_lot`
WHERE `brine_lot`.`id`='%ID%'
by AEmpeno
2021-10-17 04:07
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 6
Views: 512

Julian date

Hello,
I have a date field and I created a Julian date field. I would like to convert the date field into Julian date field as Julian date format. Is that possible? Has anyone tried it before? Thanks!
by AEmpeno
2021-04-19 21:29
Forum: Advanced Customizations > Others
Topic: Lookup Field Setup
Replies: 5
Views: 754

Re: Lookup Field Setup

After SAVE
by AEmpeno
2021-04-19 21:29
Forum: Advanced Customizations > Others
Topic: Lookup Field Setup
Replies: 5
Views: 754

Re: Lookup Field Setup

Here is the Before SAVE
by AEmpeno
2021-04-19 19:26
Forum: Advanced Customizations > Others
Topic: Lookup Field Setup
Replies: 5
Views: 754

Lookup Field Setup

I have three tables: Cherry -> Sort -> Ship. I set up all my field names in the "Ship" table as lookup field to "Sort", and I set up all my field names in "Sort" as lookup field to "Cherry". If I picked an id number in the "Ship" table all the lookup field names show the correct value, but once I hi...
by AEmpeno
2021-04-19 19:12
Forum: Advanced Customizations > Others
Topic: GPS coordinates
Replies: 4
Views: 723

Re: GPS coordinates

Thanks, jsezer! It works!
by AEmpeno
2021-04-12 04:47
Forum: Advanced Customizations > Others
Topic: GPS coordinates
Replies: 4
Views: 723

GPS coordinates

I have a table, map, and a field name, location. What I would like to happen is every time I hit the save button, I would like the GPS coordinates (latitude and longitude) automatically save the coordinates to the field name.

Has anyone in here made this feature to their project?
by AEmpeno
2021-04-10 22:02
Forum: Tips And Tricks
Topic: google map auto geolocation data
Replies: 5
Views: 2408

Re: google map auto geolocation data

Were you able to solve the issue? I am trying to get the GPS coordinates as well.

I have a map table and a "location" field name. What I would like to happen is every time I hit the save button I would like the GPS coordinates (latitude and longitude) automatically save the coordinates.
by AEmpeno
2021-04-06 22:40
Forum: Advanced Customizations > Others
Topic: Connecting AppGini Database to Printer?
Replies: 11
Views: 1153

Re: Connecting AppGini Database to Printer?

Thank you! I was able to connect to my local database.

Unfortunately, because I have several "lookup" fieldnames on my table so if I pick a record, it pulls/shows an "integer" number instead of the actual "name" of the product.
by AEmpeno
2021-04-02 17:08
Forum: Advanced Customizations > Others
Topic: Connecting AppGini Database to Printer?
Replies: 11
Views: 1153

Re: Connecting AppGini Database to Printer?

Sorry for the confusion. Thank you all for pointing me in the right direction, I think this is what I'm missing - "IF your printing software pulls data from the AG database, it will need credentials to access that database, and the printing should work." I have to figure out first, how to make datab...
by AEmpeno
2021-04-01 19:12
Forum: Advanced Customizations > Others
Topic: Connecting AppGini Database to Printer?
Replies: 11
Views: 1153

Re: Connecting AppGini Database to Printer?

Right now, I am doing a test mode, so the printing software is installed on my pc the same as my Appgini project database. I can print something if I'm doing it manually, input the information, or fetch data from an excel spreadsheet. I haven't tried the software to any MySQL or MariaDB format. Once...
by AEmpeno
2021-04-01 18:08
Forum: Advanced Customizations > Others
Topic: Connecting AppGini Database to Printer?
Replies: 11
Views: 1153

Re: Connecting AppGini Database to Printer?

What I would like to do is when I print a label the information would be coming from the AppGini database. For example, on my label, I have a "Lot Code" field and I would like to get that "Lot Code" from the production table in my AppGini database instead of manually typing the Lot Code.
by AEmpeno
2021-04-01 14:47
Forum: Advanced Customizations > Others
Topic: Connecting AppGini Database to Printer?
Replies: 11
Views: 1153

Connecting AppGini Database to Printer?

We have this printer software, Bartender, and it supports MySQL and MariaDB. My AppGini project is saved to a local computer in the same network. I've been trying to connect my AppGini project to this software printer using this wizard. I tried several server paths - \\127.0.0.1\jfoodsqa or \\localh...
by AEmpeno
2021-04-01 14:28
Forum: Advanced Customizations > Others
Topic: Calculated Column Not Working
Replies: 2
Views: 558

Re: Calculated Column Not Working

Thanks, landinialejandro! I will def try this out. :D
by AEmpeno
2021-03-25 15:52
Forum: Advanced Customizations > Others
Topic: Calculated Column Not Working
Replies: 2
Views: 558

Calculated Column Not Working

Hello, Will someone please help me. So, I have this page where users can print the order summary, and on the page, it has all the order items. But for some reason, the last column is not showing the right calculation. Please see the attached pic. /* grant access to all users who have access to the o...
by AEmpeno
2021-03-12 22:41
Forum: Feature Suggestions
Topic: e-signature and basic workflow engine plugins
Replies: 3
Views: 2746

Re: e-signature and basic workflow engine plugins

Yes, the e-signature plugin will be beneficial for many.
by AEmpeno
2020-12-15 16:48
Forum: Bugs/annoyances
Topic: Error 91
Replies: 6
Views: 1069

Re: Error 91

Yes, I did send the AXP file yesterday via AppGini Support <[email protected]>. Thanks!
by AEmpeno
2020-12-14 19:34
Forum: Bugs/annoyances
Topic: Error 91
Replies: 6
Views: 1069

Re: Error 91

Version 5.92
by AEmpeno
2020-12-10 17:36
Forum: Bugs/annoyances
Topic: Error 91
Replies: 6
Views: 1069

Error 91

Has anyone encountered this error message while generating the app?

Error 91:
Object variable or With block variable not set
This error took place while executing DolmportCSV.

Need help.
by AEmpeno
2020-07-08 19:51
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 24
Views: 5538

Re: Order by date if lookup field

Hello, I'm pretty sure I followed the script posted on this thread, however, I don't see any changes on my project. So I have a "Cherry" table with "ManuDate" fieldname, and then I have "Micro" table with "ProdDate" fieldname. My Micro.Proddate is set as lookup field to Cherry.Manudate. I did try th...
by AEmpeno
2019-08-05 21:39
Forum: Advanced Customizations > Hooks
Topic: Field Color based on numeric value
Replies: 11
Views: 2879

Re: Field Color based on numeric value

would you mind share with us your final script? :)
by AEmpeno
2019-04-04 18:25
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 25
Views: 10041

Re: Auto-balance field

Hello, You mentioned from previous conversation that "if you want to get calculation once the data changes, it would be best to handle this via the after-insert, after-update, after-delete functions in the respective hooks." Will you please guide me on this? It's been a year since I started this pro...
by AEmpeno
2019-03-31 14:27
Forum: Advanced Customizations > Others
Topic: Child Tables Slow Loading
Replies: 4
Views: 2050

Re: Child Tables Slow Loading

thanks pböttcher.

i went back to your first suggestion to check my SQL statement. for now, its working fine, hopefully, this fixed the problem permanently.