Order by date from text field

Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that?…

• Answered

Extract year from date field in text format

Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…

PDF image color different in browser export

Hi. I have notice that the pdf exports the image with a color significantly different when generated from the browser than when generated from the macOS app. See the images.…

Convert coded text to plain text

Hi. I have this code from Zapier-Jotform [{"N. de llicència":"Ib 1234","Nom complet":"Mateo Domínguez Fuentes","Data naixament":"02/02/1983","Categoria":"Absoluta"},{"N.…

mailto on openURL not working with Outlook 2016 windows

Hi! I have this code openURL("mailto:?" + "bcc=" + CCO + "&subject=" + Asunto + "&body=" + Mensaje) to open Outlook with the BCC, Subject and Body preloaded.…

openURL(mailto) only works if 88 (or less) emails

Hey all. I have this code openURL("mailto:" + TO + "?" + "cc=" + CC + "&" + "bcc=" + BCC + "&subject=" + SUBJECT + "&" + "body=" + BODY) BCC is a textbox that loads all the emails in other table.…

Button to load emails in a textbox

Hi all. I have a contacts list with emails and specific tags from all of them. I want to create a button that copies all the emails in a selected tag, separated with ;…

Config document generator from database

Hey all. I have this doubt: I want to create a document generator that takes people's data from a database. The database is correctly linked to the generator table.…

Show button if 2 conditions

Hi all. How can I set a button to show only if 2 conditions are fulfilled? I have 3 buttons: RC & AA - show only if Selection 1 = 1 or 2 or 3 AND if Selection 2 = 1 Sin RC & AA - show only if…

Remaining to a date & style

Hi. I have this: let Countdown := 'Data d''inici' - today();styled(text(Countdown), if Countdown = -1 then"red"elseif Countdown < 0 then "Orange" else "white" endend) I want to format the f(x) like…