How can access zoho pepole employee form from Creator
Hi We are bulding an application wich needs info from our employes, this info we have into ZOHO PEPOLE ¿how can acces the info in zohp pepole form zoho creator?
logs - to admin email?
hi! how to send all error logs to admin email?
how in form make verification of data in other report?
hi! there are 2 forms - form1 and form2 and there is report1 which made on entries of form1 how can i link in form2 verification report1's entries? example if in report1 there are entries with "input.datadostavki >= zoho.currentdate.addDay(3)" then in form2 there is alert =========== if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert"); }
I would put a filter for a single month without putting a specific day.
ML_01_Last = Stock1[Fecha == '01-Jan-2014'].count(); I would put a filter for a single month without putting a specific day. ML_01_Last = Stock1[Fecha == 'Jan-2014'].count(); The filter should be something, but I'm not sure how.
eMail template with a lookup field
I am trying to develop an email template for a form per "on submission success" action. The "submit success" action triggers this email. In designing the template, I found that the "lookup field" defined as <%=LOOKUPFIELD%> shows a value of the ID of the related form. How can I make it shown the other values of the same row on the related form? Thanks.
Viewing Reports in a form
Is it possible to view a report in a form, much the way sub form can be seen? If so how can this be done? Thanks!
Will Zoho Creator ever provide customizable layouts for forms?
One of the most wanted features for me and my clients is the ability to have better layout options for forms. The rigid 2-column vertical layout is not enough for many situations, and looks rather primitive and not elegant like many commercial applications.
Html Table Container
Hello I have 2 tables in HTML, I want to know how do I put one beside the other, I have the following code //CONDICIONES AMBIENTALES if (CondicionesAmbientalesNoVacio != null) { output = output + "<div class='invHead2'>Condiciones Ambientales</div>"; output = output + "<table class='tableSize2' border='1' cellspacing='0' style='border-color:#EEE;margin-bottom:5px;'>"; output = output + "<tr class='rowHead'><td>Zona</td><td>Hora</td><td>HR</td><td>TA(°C)</td><td>TS(°C)</td><td>TD(°C)</td><td>TS(°C)-TD(°C)</td></tr>";
Automation of User invites in Customer Portal
Hi, I want to know if it exists a way to automate the user invite in the Customer Portal via a custom Form, via api call or other via without user interaction. I would like, for example, create "Students" in my database using a Form and add them automaticaly in my Customer Portal. As I can Allow Self-Registration in the Customer Portal and set the default profile (in this case one that filter the info related to the Students), I thought I could create to every Student an account to my Portal just
Help! Anyone know how can I get user to choose a unique ID name?
Thanks for any help you can offer folks. I have a very simple form. The only field is ID_Name. I want the user to choose a unique ID name, and I want to be able to control the responses. if(input.ID_name == "Jenny") { alert ("Sorry, this ID name is taken. Try again."); cancel submit; } This On Validate script would work perfectly if they chose the name Jenny. Basically, what I want is to say (instead of Jenny) - any name that is listed in the field called All_ID_names, which is in the View called
Export XML file with child element
Hi, I would like to export the data in Zoho Creator to XML. However, there is a child element in the XML, the XML look like this: <?xml version="1.0"?> -<Batch xsi:noNamespaceSchemaLocation="http://www.google.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="1.2" TradeId="3333"> -<Order TradersExternalReference="4456"> -<ShippingInformation> <FirstName>John</FirstName> <Address>road 25</Address> <Country_ISO2>US</Country_ISO2> </ShippingInformation> -<Products> <Product
Adding the value of items in a picklist
I am creating a simple equipment builder, where I have a catalogue of components, with costs, which are pulled into a form in a multiselect picklist. As each item is selected, I would like to fetch the cost of each item, and add them to a running total.
Restricting numbers in a decimal field
Hi there, I, like many others, am really surprised that Zoho Creator doesn't cater for a time field (hh:mm) to capture time spent on certain tasks. So I've opted to use a decimal field and ask people to round up to the nearest half an hour. I would like to restrict the allowable numbers after the decimal point so that they can only enter .5 or .0 and nothing else. If they try to enter anything other than a 5 or a 0 after the decimal point then a message will display - "please enter time to the
Send information from one form to another via OnSuccess
Hey guys, We are making a multi-part form where our guys will fill out some base information and then select a category to be taken to a particular form based on the selection. We need a way to transfer the information from the fields in the first form to the form they are sent to. Thanks in advance!
Generate Part Number
Hello, How can I Generate Part Number From another fields and see it and add it to the ID part field Sample: Size: 2 1/2 Grade: Steel Weight: 23 Custom: 111 Result: 2 1/2 Steel 23 111 Thanks in advance / Omar
Lookup result not showing in export CSV files
Hello all, I have form A in which I enter a building number and save. On subsequent forms to reduce entry error I have a look up field to select the building from the already populated list. When I am checking the backups, I notice that the column which should hold that lookup result is blank. Is this a limitation or a bug? When exporting the list manually, the column shows with correct data. Just not in the combined Backup/Export version. Please help. Thanks, Scott
Problem with form mobile within an iframe in Chrome and IE
Hello When I try to open a form-mobile within an iframe I can see just the title. None of the fields are published. I happens in both, Crome and IE. In Firefox, however, it works OK. this is my page's code <html> <body> <iframe id='formulario_reservas' name='formulario_reservas' height='900px' width='100%' frameborder='0' allowTransparency='true' scrolling='no' src=https://creator.zoho.com/calterras/reservas-usategui/form-mobile/solicitar_reserva/></iframe> </html> you can try in this link http://ziaboga.com/usategui14/pzm.html
Second bigger record fetch
I have a form that contains kilometers and amount of fuel; I want extract the second bigger values from fetch for calculate: [ amount_fuel / ( bigger_kms - second_bigger_kms ) ]. My problem is find second bigger value. How can I do? Thanks
how to disable save entry on alert?
hi! just made alert On User Input example: if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert!"); } how can i disable save entry when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" ? in this time user can see alert, close it and save changed entry i need when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" - disable to user to save entry. please help to make this.
Zoho Creator Calendar View
Hi, I am trying to create an electronic Vacation Request form, but creating a Report in Calendar view does not seem to be working the way I want it to. If someone approves the vacation, it is then shown on the calendar, but say, the vacation starts on March 2nd and returns to work on March 14th, it only shows up on March 2nd with the details. Is there any way for it to show up on every day, including March 13th? Thank you in advance! Joy
Workflow Script to Reload a Form with Saved Field Values for Selected Fields
I'm new to Creator, and Deluge, and I'm trying to develop a workflow which I thought would be basic, but I need some help. When a user inputs values to one of the forms I've designed, I want the user to be able to select certain fields that do not reset their input values when the form is Submitted. Is there a field property somewhere that I can set so the form reloads with the last input value? Or must this be done with variables by storing the user's input during Validation and then retrieving
looking at existing clients
Hi In my application, the user can add new clients while looking at existing clients. Currently I am having trouble with fetching client information from the same form. I've had a look at these links but im not really sure how to implement/use these to make them workable in my application https://www.zoho.com/creator/help/script/fetch-records.html https://www.zoho.com/creator/help/script/fetch-a-value.html Thanks :)
iterate distinct records in one form and check a check box if it matches any distinct records in another list
iterate distinct records in one form and check a check box if it matches any distinct records in another list how do i do this?
Importing Data
Hi, When I import data (csv or excel), how do I import the data of a lookup field? Do I import using the related ID or do I import using the corresponding string. If I import using ID, does the format have to be number?
Is there a way to get usage metrics such as logins, pageviews?
We are aware we can get record create/update measurements with a crosstab report run daily that counts #records with modified within the last 24hrs, by user. Are there additional metrics available? Such as login or pageview logs or metrics? Thank you!
Record Summery Template absent
Hello, I would create a record template for a report. I created the Template in Form Setting. I don't know, now, how i can apply the Template. If I select the report, not appear "summary record Template", as explained at link https://www.zoho.com/creator/help/views/record-summary.html. In FORM Setting i can see "Record Templates", but is not present the field "active" or "inactive". 1) How I can Apply the template? 2) Can I insert in the Template a lookup field for select a customer and visualize
Migrate from FileMaker Pro on Mac
HI there, I am trying to import a database from FileMaker Pro to Zoho creator. if I export as xml or csv it doesn't work as we have more than 70 columns, so wanted to try to export from FileMaker Directly. But when i try to download the migration tool, the link is dead - https://www.zoho.com/creator/help/application/ms-access-and-excel-migration-tool.html and seems to point to the MS Access tool. How can I install the migration tool on my mac? Thanks
Power a number to a Decimal X^(1/8)
Good day, I try to raise a number to a power usin power(X,(1/8)), the problem is that the script tells me that the 2nd argument only can be a BIGINT, Could you please tell me which function should I use, Best Regards,
Linking two fields and forms
I have been trying to establish a relationship like the one in this example. I want to a record from a Look up field and fetch records from another Form and into these records into fields of the Same type and Name as the related Form. i am using script with my form and app names that looks like this: string externalapps.GetType(int name) { if (Enrollment_Information[ID == input.name].count() > 0) { return Enrollment_Information[ID == input.name].Dog_s_Name_1; } return
A function sends an automatic email with information from other fields
I made a button that automatically sends the customer a quote from a mailbox, the problem is that all the information of all entries is sent to that email. How I avoid that? void CORREO.Email2(Cotizador_Multiple CM) { String1 = ""; for each r in Cotizador_Multiple { String1 = String1 + CM.Articulos.Foto + CM.Articulos.Link + CM.Articulos.Precio + "<br>"; } sendmail ( To : CM.Email From : zoho.adminuserid Subject : "Prueba"
print in the background
hello, Is it possible to trigger a print job in the background (without any print dialog boxes)? Need to trigger the print job during a save event, and also via a custom hyperlink or button. Also, we will be triggering different print jobs for background printing - print a zoho record, print an image (via url), print a webpage (outside zoho). Is this possible? Thanks!
Insert Subform row On Success Action
Hi, I would like to insert row(s) of each Subform row into a form on Success Action of Main Form. Below is the script I was trying to but it not working correctly. for each selectedValue in input.Coverage.PCM_Fips { insert into MVPD_Partial_Coverage [ Added_User = zoho.loginuser MC_TVStation = input.Coverage.PCM_TVStation MC_MVPD = input.Coverage.PCM_MVPD MC_ChannelType = "0.1" MC_Fips = selectedValue ] } Note: PCM_Fips is the MultiSelect
How do I enable decimals in my "Price" field?
I can't seem to figure out how to enable decimals on my Price field in my Product Subform. The inserted products all have prices with two decimals, but once I've selected a product in the "New order" form, it shows its respective price rounded up or downwards, depending of course if the decimal being higher or lower than 0.5. The Field Deluge Name is linked to the actual Price, though.
Record Summaries missing!
When I duplicate my program, all my record summaries vanish! Please tell me this is supported!
Allow function to run when some details are missing
Hello all I have created the attached function and I would like to run it for a collection of records, however some records are missing the inputs for the fields needed to run the function. Is it possible to code the function such that when there is no input in the field, the function skips that record and carries on to the next record? Ideally, it should also insert a comment to the form stating which record was lacking input in which field. Here is my function: float calculateKVGunder25(Client_Details
Schedule a custom Function and run it daily
Hi, I am trying to run the below function on a daily basis.It is possible by using Scheduler in Zoho Creator ? void MVPD.AddUpdateLink_SubchnnelMVPD() { for each rec in Not_1_MVPD sort by Added_Time desc range from 1 to 500 { link01 = "<a href='https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/Not_1_MVPD/record-edit/Not_1_MVPD_Report/"; link02 = rec.ID; link03 = ("' target='_blank' title='Click to Update Record'>Update Record</a>");
Updating string field based on lookup field
I have a form with a look up called "Customer" What I want to do is when a user selects a certain customer, I want the customer information that is tied to the selected customer (on the form the look up points to) to be inserted into the "Address" string field. How can I do this? Thank you in advanced
Signature Html
Good day, How do I put the signature captured in a form in a Html Page? Best Regards,
Linking data from two forms, each located in different application
Dear Creator community, Hello :) My situation is as follow: I have one application which contains a form with customer data: Application A, Form A: Row: Customer ID, First Name, Last Name Application B, Form B Row: Customer ID (look up field to Application A, Form A ,Customer ID) First Name, Last Name Application A is my master database, while application B is a secondary database created per user The desired process is as follows: I register a new user in application A database then, when i create
How do I allow duplicate entries of products?
I want to link or restrict all my individual products to their respective suppliers, so that when I select a supplier in, for instance, a purchase subform, only the products of that particular supplier show and not the entire list of products. In addition, I need to allow duplicate product entries, as several suppliers often produce a product that has the same name (in this case, a type of wine, based on the same grape), but is entirely different by nature. Many thanks in advance!
Next Page