I have different prices set up for certain jobs and are referencing them using foreign keys. I need to do calculations in another column using these. Is it possible
Unfortunately, foreign key columns cannot use calculation functions, nor can they be used in formula columns. Those columns are actually strings, and string values will be parsed as zeros.
Thanks Aleksander, I did manage to find a work-around. If you set up the formula before setting the foreign key it will use the ID number. But once the formula has been created you can then set up the forign key and the calclations work.
I have different prices set up for certain jobs and are referencing them using foreign keys. I need to do calculations in another column using these. Is it possible
Hello Bob
Thank you for your purchase.
Unfortunately, foreign key columns cannot use calculation functions, nor can they be used in formula columns. Those columns are actually strings, and string values will be parsed as zeros.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks Aleksander, I did manage to find a work-around. If you set up the formula before setting the foreign key it will use the ID number. But once the formula has been created you can then set up the forign key and the calclations work.
Not ideal but does work.
Bob
Thanks for letting me know, Bob, much appreciated.
I'm sure it will be of use to others as well.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables