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
Pivot Charts work as a Creator USER but not a customer portal USER
Can someone explain why I get beautiful charts ( even if my form data is multi-select) as a Creator USER ... but when I access the Chart as a customer portal user - it just won't work? Seems to me that if I can create a chart and view it as the administrator - I ought to be able to make this available to my portal users - ( or am I being totally unreasonable?) Thanks in advance for your response, Craig
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
Calculating the number of days between a date field and the current date
Can someonce check my formula I am looking to count the number of days from the current date - back to a count field Here is my formula ((zoho.currentdate – Initial_Contact) / (1000 * 60 * 60 * 24)) Initial_Contact - is a date field entered by the user. I modified the formula found on this page - https://www.zoho.com/creator/help/fields/configuring-a-formula-field.html#Script_Actions Thanks in advance
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
Deluge, not easy?
Hi all, really looking forward to getting more into this product, its great so far! I am definitely struggling with scripting though. The help manual says the following "Should I have programming experience to code in Deluge? Definitely not. Zoho Creator/Deluge primarily addresses the needs of a large number of people who have a requirement for a web application but do not know to build it on their own. You need not be aware of Java, JSP, PHP, JavaScript, HTML or CSS. You just need to have a clear
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
Scripting lookup from another application
This is from one of your demo apps empRow = Sales_Reps [Email == zoho.loginuserid]; if (empRow.ID != null) { input.Account_Owner = empRow.ID; } I would basically like to do the same thing but my Sales_Rep field is in a different application.I was trying to do something like below but it doesnt let me access the other app through script but it does in look up. empRow = Employyes.Sales_Reps [Email == zoho.loginuserid]; if (empRow.ID != null) { input.Account_Owner = empRow.ID; } I
Where are my apps
When logging into Creator I am presented with only a blenk screen of "shared apps". My apps are not shown. The apps still work via iphone app and URLs but I can not get to edit any of them. I am just gone live with the first app and now am completely stuck. HELP!
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
Maximum Authtokens
Is there a way to increase the amount of tokens for an account? I'm getting an error that the maximum amount has been exceeded. Zoho should take into account how many PAID for services per account are being utilized . I currently pay for CRM, Creator, Campaigns, Invoice and Projects. I also use Docs. Factor in the iphone / ipad apps plus the service to service integrations and you see quickly you need many more than 10. I need at least 10 for Creator alone. I'm at a standstill right now in Creator
Help with data fetching
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 I'm 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 :)
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,
Record locking mechanism?
I'm making an application that is essentially going to be a community queue where users grab individual records and when make a decision for it. I need to make sure 2 users cannot open the same record at the same time. I'd like some kind of record locking mechanism that checks if someone else has a record open in which case the 2nd user would receive an error message saying the record is locked already. Is this possible? Has anyone done this before?
Display int with commas in html view
I have an html view that shows several numeric fields (forumla values) from a form. When displayed in the html view the take the following format: 1234.00 I would like them to be in the following format: 1,234.00 Is there away to get zoho to show the number value with commas? Thanks Matthew Steele
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
calculated forms values before submit
when I need suggestive value of the field ItemID is calculated based on the form values specified for the Model and Serial# I use this : on add { on validate { input.ItemID = input.Model + " " + input.Serial# it is work to add record, but I need see the value as suggest before submit, because I want to modify before submit Omar
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"
Zoho Creator with SQL Server connector
I have a few SQL Server instances running. I need Zoho Creator to connect to them for read/write CRUD CREATE READ UPDATE DELETE. Can you guys recommend a good SQL server hosting service, plus a good connector /middleware between Zoho Creator and SQL Server? thanks.
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!
Bulk Edit does not trigger "On Validate" event
I have a logic On Edit/On Validate whenever decision box is checked to recalculate another field "Status". When I edit single record it works fine, but in bulk edit mode it does not work
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!
How do I know that email is bounced?
Hi, how could I know using Zoho Creator that my email has failed? Have you any solution to know that some of send emails were bounced by email server?
Zoho Creator website not loading
I've been unable to load any Zoho Creator pages since this morning. The site hangs & I get a connection error in multiple browsers. My internet connection is fine. Any idea how to resolve?
Next Page