Export to Import cycle destroys Form relationships. What is the recommended teqnique to maintain record IDs and relationships?
When a record is deleted its key ID is also deleted from any related lookup fields. How can we export to excel a record set and reimport? The import will not overwrite existing or update existing records as far as I can tell. So I deleted the records so the import could succeed. Then I find ALL my related forms via a lookup field have been cleared :( If the ID field is not honored on import what is the known work-around to keep the record keys intact on export/import? What is the best practice to
Edit bidirectional relationship form
Hello! I have created a bidirectional relationship between 2 records. Every time I click on the bidirectional link, I see the record but it doesn't let me edit it. How can I click on the bidirectional link, then edit the record that the link shows?
Pass values to pop up form after success of previous form
Hello, I have a form that pops up after the success of another form. How do I pass the values to the pop up form from the previous form? Ex: In the main form, I enter 1/1/2017 in the date field. After submitting the form, a pop up form appears and in the date field of the pop up form the value = 1/1/2017.
Zoho Creator tutorials
This looks like a good tutorial: https://www.zoho.com/creator/help/images/intro-to-deluge-workflows.pdf Wonder where are the other comprehensive Deluge/Zoho Creator tutorials? Thanks.
Filter for openURL: #View
Hello! Is there a way to automatically filter a report when opened via openURL:#View I am trying fetch_record = <fetch criteria> openUrl("#View:Report_Link?Event_ID=" + fetch_record.ID , popup window) but this opens the full report with all records.
appearing on filter name
Hi - I have a Customer form that collects First_Name and Last_Name of customers. I have a separate form for Orders, that uses a look-up field from the Customer form that combines First_Name and Last_Name, called Customer_Name. On the Order report, I have a filter for Customer_Name. The Customer_Name appears just fine on the filter, but once I select it, the Customer_Name appears as "LastName, FirstName" --- any idea why it would be adding the in there? It should read Last_Name, First_Name,
export date format in Excel
When export data in Excel, the date format is not recognized. How can I manage this? Do you know any way, even throw multiple step or other software, to convert Creator date format in Excell date format? Lucia zoholucia
URGENT Again. Account access restricted?
Hi, I logged on today and found the surprise that I can't see my applicatios but rather see what has been shared with me or my groups, as if I was not the account master/owner....??? all applications I did not share I now can not see.. Please clarfify this to me as soon as possible. Obviously as well I can't edit my own applications!!! the account I have been using: cncdelgolfo@gmail.com (nickname: practicorte) the account supposedly owner of my applications: yaxche (an old nickname) thanks for your
Map Tutorial Advanced
This is a follow up post to the following two other posts.... 1. Map Tutorial (Beginners) 2. Map Tutorial (Intermediate) In this post I am going to talk about some more advanced ideas concepts in regards to using maps and lists together. If you are reading this you are already aware of the power of using lists and maps together to create powerful DS scripts. I'm going to cover HOW TO COMBINE A ZC MAP AND A ZC LIST TO CREATE MULTI-DIMENSIONAL ARRAYS( Think form records stored in script format).
Custom-action button at beginning of line
I designed some "custom action" buttons to use for lines in a form. The button for each line/record is always placed at the end of each record display. How can I move it to the end of the line display in a report? Thanks.
Error Description Needed
<code> Possible JavaScript / XSS Vulnerability in statement "null" at line 18 </code> while using xpath in xml
How can i update more than 100 records in a report by a schedule?
I have a report that have more than 100 record, and i want to update them, why? 'cause i create a code in "On user input" to get the hour when someone add a new record and i put the hour in a Range of time-Field, something like this: but i need to implement this in the records Which were previously registered, im trying to create a schedule but it doesn't work and i dont know why, the function getHour(); doesnt work there? here is the code that im trying to implement:
How do I get the last value entered into a form to carry forward until it is changed?
Hi - I have a small manufacturing business and am working with creator to develop apps to collect data at various work stations vs filling out paper forms and manually entering the data. A lot of the entries will be repeated and do not want to have to re-enter them every measurement. For example I have an order number, width and length field - the order number and width field will be the same but the length will vary for that job. Thanks for the help.
FYI: Certain file paths on Mobile Form image upload on mobile published form fail and force Zoho Login page
When we try to save a record with an image field where we browsed the local file system for photo from the following folder name /storage/emulated/0/Pictures/IMG-766471916.jpg Saving of the record fails in Zoho and forces the log in screen. If we rename the pathname to the following, it works. We have changed “Pictures” to “test”. /storage/emulated/0/test/IMG-766471916.jpg Simply moving the image to another folder seems to work as well.
Fetch values of current form to fill values of a new entry form within
Hi, I have a form called ADD with a date field Date1. And in ADD there is a lookup field to a Create Invoice form. In Create Invoice there is a Date1 field. When I click "Add New" in the Create Invoice lookup to create a new entry, I would like the Date1 field to equal the Date_of_Event field from ADD. How do I accomplish this? (Date1 and Date_of_Event are both date fields)
Custom 'Form Variable' with OnChange Script
Hi again Zoho Creator Developers, Just as you have implemented the custom variable whose scope is only within that field. Could we have a custom 'form variable' exactly like the form fields, that is defined across the whole form/application, but does not have an input field tied to it. Just a simple variable whose scope is across the entire application. Importantly, it would have an Onchange--> action script Currently any On User Input --> Script can only be used for a form field This is a disadvantage,
Need to be able to print in the form of a "citation" or "Ticket"
Hello everyone. I have a project in which a small municipality would like to be able to log, and print and track parking tickets. I'm new to Zoho Creator, but have used similar platforms. I am able to build the form that I want, but I just can't figure out how to make it print with items such as a heading, instructions, etc. (Things that would appear on a normal parking ticket). I have attached an image of a generic parking ticket. I would ideally like to have the same format. The large "PARKING
Can a Zoho Creator Form or View receive an HTTP POST?
I have a requirement to integrate a payment gateway where the payment gateway calls my application URL to send the payment information as an HTTP POST. I know an HTML View could receive custom parameters in an HTTP GET via query string parameters. Can HTTP Post be received on a Zoho Creator Form/View? Regards Moiz Tankiwala Smart Training & IT Solutions
Zoho Creator freelancer
Hi everyone, Looking for someone to assist me with Zoho Creator app that is already establish but need some fine tuning. Willing to pay $5-$7 per hour. Regards
Multi-Currency Multi Currency Zoho Creator
I want to insert an amount and select the currency. Then I want the date-exchange rate for that currency converted automatically to USD in another row. Please help
HOW TO INTEGRATE PAYPAL INR
HOW TO INTEGRATE paypal in Indian National rupee as there is option of dollors onlys
Forms
I'm new to this. 1. Can I send a link to my clients for them to each fill out a form and send it back to me?
Calendar Report
I have attached two images. One is a screenshot of my calendar report. The other is the display after clicking on a name in the calendar report. As you can see, when I click on a name, the result is a blank screen. Why is this? Shouldn't a summary of the record be displayed? Thank you, David
Can't add a link to the form record within message in Email Notification.
I'm trying to put a generated link in my Email Notification message using values from the form. The link URL is https://app.zohocreator.com<%=zoho.appuri%>#Form:Add_project?recLinkID=<%=ID%>&viewLinkName=Dossiers_en_cours This is what I get before saving : And his is what I get after saving and then refreshing the page (to see if it committed well, because y'know, HTML getting modified against your will is a common problem with ZohoCreator) : Please implement a way to include links to the current
Adding Records to form from html form
Hi, I can't get the correct results with according to your previous answers. Will you please send me the proper url to add records to my form in the following link.... https://app.zohocreator.com/dgeorgedavid.121/my-pharmacy/#Form:New_Customer dgeorgedavid - username my-pharmacy - appname New_Customer - Formname Thanks in Advance....
Using postURL to access Zoho Invoice API
I need to add a receipt file to an expense in Zoho Invoice, which does not appear to be available as an option in the standard deluge script. I've written a function to use the API for Zoho interface, but cannot get the postURL function to work. I am able to get the getURL to work properly, so there seems to be a formatting issue with the postURL function. string invoicefunction.add_receipt() { true_var = true; customer_id = 485465000000073061; account_id = 485465000000082151; expense_id
Related data in reports
Ok - I've looked into documentation and forum responses here, and it seems like this might not be possible based on posts like https://help.zoho.com/portal/en/community/topic/combining-multiple-related-data-on-one-view-in-creator , but that was from a few years back so I'm hoping things have moved on ... Supposing I'm modelling Departments and Persons. Person is used in the app in a number of ways. Departments can have a number of Persons. So, on the Department form is a subform allowing a number
Using Google App Script to send emails through Gmail
Has anyone done this? I have scanned the Google Apps information and it looks like there are APIs for Gmail and one can use the Script Editor to create an App which can then be called using an simple URL. From Zoho Creator, I want to be able send emails with attachments (possible) from Gmail. This way they will appear to come from my domain and will appear in the relevant threads when viewing messages in Gmail. Has anyone done this?
Add number fields only if not null
How do I add number fields that are not null? So far, I have script that adds number fields, but I keep getting an error message when some of the fields are null. input.Total = Amount + Amount1 + Amount_3 + Amount_4 + Amount_5; For example, if Amount_3 is null, I will get an error message. I do not want to add 0 to any fields that are null. If they are null, I would like to keep it that way. Is there a way to only add fields that are not null?
To duplicate a row and refer back to original row
I wanted to have a simple script to duplicate a row, but the duplicated row has to refer back to the original row. So a new field called ORIGINAL_ID is created to hold the value of the ID of the original row... is there a generic ZOHO function to duplicate a row and then I can customize it?
Multiedit rows (cells)
Hi. I have spreadsheet (form) with square of landplot. I want to autofill another columns in this table with "size" of land plot. (if square < 1000 sq.m then size = S; if square > 5000 sq.m. then size = XL... etc). Is it possible? i wrote field action for report: if (input.Square < 700) { input.Size = "XS"; } else if ((input.Square >= 700) && (input.Square < 900)) { input.Size = "S"; } else if ((input.Square >= 900) && (input.Square < 1100)) { input.Size = "M"; } else if
Using the Migration tool to update records
Hi, I'm trying to use the Migration Tool to update my records, but for some reason it is not working for me. I made a Test application with 4 columns. Emloyeenumber Firstname Lastname Age This application has 4 records. After that i update my excel sheet and add 1 more record and change the age of 1 record. Than I start the migration tool and open the xls file and select "Add data to existing application" After login I select the correct Application, Select the Form. Now this is the confusing part:
Date-Time Pivot chart
Hi, my boss want to see in a grapich, how many "Altas Voluntarias Report" are there between a specific time, so how can i do to create a pivot chart to see these dates in a grapich? These are the date ranges: 6:00 am - 10:00 am 10:00 am - 2:00 pm 2:00 pm - 6:00 pm 6:00 pm - 10:00 pm 10:00 pm - 6:00 am It's no use saying that on my form I have a date-time field
Technical problem with subform, add record form modal and external applications
I've found a very specific bug that's nonetheless necessary to fix. Here's how to replicate it : We have two apps in the same account whose linknames are "v5_bons" and "v5_gestion_inventaire". v5_gestion_inventaire has a form Nouveau_Produit which represents products. v5_bons has a form Bon_fournisseur which has a blank subform which contains a Lookup field towards v5_gestion_inventaire's Nouveau_Produit form. While testing the form Bon_fournisseur, I tried to make a Nouveau_Produit using the "+
Insert image in a Form
Dear Sir / Madam I have uploaded one image in "Image Hosting site" and get a link. but when I tried to attached this image using link in my form thru ADD Notes. it is not showing Image. Link is http://i1170.photobucket.com/albums/r521/shivdutt/05b3d1a3.jpg Please check and advice me, how i can attached images in my forms.
How can i get the zohologinuserid from a global variable?
Im trying to create a page in html free-flow-scripting, and i need to get the email(zohologinuserid) of the person wich is entering to the app, how can i do it?
PSA: `input.dropdown.deselect()` breaks your scripts!
Just a fair warning for anyone who's trying to use the `.deselect()` command on a dropdown/radio field in Deluge on the onAdd -> onLoad action : DON'T DO IT. It is very broken, and almost cost us hours of work. What will happen is, you'll have a script error (if I recall, it mentionned GENERATEJS_JS as the culprit) which will prevent you from loading not only the form, but also the script itself if you decide to refresh your script!!! So yeah, don't do it. Zoho devs, please fix it!
Customer Portal Profiles/Permissions
Hi, I have 2 profiles setup for the customer portal. I have separate reports(same form) that should only be accessed based on the profile assigned. Under "Restrict Visibility" settings of a report the only option is to share with "All Customer Portal Users" - Is there a way to only share with a particular profile? Thanks, Damien Cregan Hire an Expert
Re-calculate Form if Drop Downs Are Changed
Hi, I'm trying to get a form to re-check if a user changes the options, so it can re-calculate. I can get it to work the first selection, but if they go back and change a selection it doesn't recalculate. e.g. I'm adding the Days Approved + Approval Date = Review Expiry Date Here's what I have that works first selection, but not when you change your mind if Days_Approved1 = "7" { input.Review_Or_Expiry_Date = Approval_Date.addDay(7); } if Days_Approved1 = "14" { input.Review_Or_Expiry_Date = Approval_Date.addDay(14);
Application Developers
We are looking to hire a Creator developer to build a custom application for loan processing. Where is the best place to go to find someone? Or are there any off the shelf applications for sale?
Next Page