Relationships when importing data
We have been evaluating Zoho creator and find it has all the features we need. However we have been trying to import our data into Zoho creator from our relational database and do not see how we can recreate the relationships in Zoho with existing data? We have exported all the relevant tables to excel files and have imported them in Zoho creator, but cannot find out how we can recreate the relations between the individual files (example: between customer and addresses, or between customer and bookings).
Adding groups to non-stacked charts
I want to show a chart that shows the total amount booked for each publication date in the next week. But I want to show the publications separately. With the stacked charts I can select a stack by, but I can't see how to do that for the bar and line
Zoho.loginuserid is not fetching right Login User Email ID
Namaskaram Zoho Creator Developer Team I am using Default Send Mail functionality in Workflow. I have added "Zoho.loginuserid" for "To" address When the Email is got triggered instead of taking Login user Id it is taking Workspace Owners Email Id and
Subform Add Line Automatically
I have disabled the Add Line feature in the SubForm. But I do want to be able to add a blank line with a deluge script. How do I do that?
Adding White Space in Deluge Code.
Hi there, I've been coding in Deluge for around 7 months now. Something I usually do within my code files is adding some white space to section out parts of code. I've noticed in Creator, and other Zoho Apps, that when I save my code in functions, the
How can I add a page/dashboard defined in creator to the CRM as a tab?
See the title. We want to include our application in the CRM, and I can't work out how to add a page from the app to the CRM tabs.
How to include column total in scheduled report?
I'm sending out a monthly report as a pdf. I have the view set to total a numeric column. When I export it, the total appears at the bottom of the column. But when the scheduled report is sent the total is not shown. How can I add a total to the numeric
How to use getUrl ??
Hello how are you? I would like to know if method getUrl can set a ip public ? For example, 138.121.141.251:8080 Regards
two subforms of the same form - possible?
I have Purchase form which has a Purchase-Item subform. after the purchase Is made, the manufacturing process begins and i subtract from stock the needed items to make the desired purchase item. to keep track of the stock movement, i create on validation a purchase item of the needed component where i record a timestamp and the stock level at that point. this way, the report showing Purchase-Items can show me stock movement of different items over time. i would like to connect the needed component
Xero Integration using Zoho Creator
Hi, We have a basic application in Zoho creator that tracks our clients and workload. We have a form that tracks the work and when the task is set to complete we want to automate the process of the invoice information being sent to our Xero. Any suggestions of the best applications that could link Zoho creator to Xero and perform this function? I have looked at Zapier, if anyone has feedback on that? Thanks
Bulk uploading URL contents to Creator app
I am creating a Creator app to replace an existing on (built in knack) however I have a lot of documents stored on the old app that I need to move to Creator. The documents are stored as a url and I have exported that as a new field - but I would like
Integration with woocommerce
Hi, I want to know how to integrate woocommerce website data into zoho creator. For ex.,I have an order form in my website,once the order is submitted the data should insert into creator.
Issue when parsing XML that contains special characters more than once
Hello, I have found a bug when parsing XML that contains a URL that has GET parameters. The following example below throws an "invalid XML/JSON" error when executing (note: this is actually a small example from a response being received from an API): data = "<xml_node>https://someurl.com?rating=PG&size=35&default=mm</xml_node>"; xml = data.toXML();
Edit for the perma link in zoho creator
Through the publish function a customer is able to view the form through the perma link provided. Can this link or embedded code be edited in any way ?
Auto submit a form?
We use a form as a GPS "locator", in that we capture the user's coordinates upon submission. At the moment, they have to click the Submit button to accomplish this. Is there any way to auto submit a form when visiting it?
How do you add a Contact integration that is linked to the Account
On our booking form in creator we have an Account field where the user selects the account that this booking belongs to. How do I add a contact integration field that only shows contacts associated with that account?
How do you filter a report on zoho account id
I've added zoho CRM integration (Field name = Account) to our form, and it shows the account name on the field, and in the reports quite nicely. However, when I'm trying to make a page for that account I can't filter the reports on the Account field.
need help with a formula field
Hello, I have the following two formulas in a field I want to run the first one if the field titled Side = Long I want to run the other one if the field titled Side = Short Here are the two formulas, how would i get this formula written correctly? ((input.Closed_Price
calculating days, hours, minutes
i have the following equation worked out, but it is not subtracting the time used in days portion of it and adding that into hours in the hours part of it (((input.Closed_Time - input.Open_Time)) / (1000 * 3600 * 24)).toLong() + " Days " + (((input.Closed_Time
Adding a new field to an existing report - it doesn't appear
There are sometimes when I will develop a form and set up a report, but then need to add a new field. When I attempt to add this new field to the existing report it just isn't there - I am a developer so have full access to all view/edit/delete permissions
Moving Stateless Form Button
Is there anyway to move the buttons on a stateless form ? Rather than be below I'd rather the buttons be on the right ... is this possible
Asking user if they want to submit due to duplicate entry
Hey all, In my application, I would like to prompt the user with a question asking whether they would like to submit an entry that has duplicates in certain fields on submit. If they still want to submit it, they can and if they don't, they can cancel
How to format links in reports to be clickable URLs
Prior C5 upgrade when I was using single line field it would display links as a clickable URLs in reports. After upgrade those links are no longer clickable. I am also aware there is Url field type, but I don't want to migrate all my fields to new type,
Need guidance on migrating from Access into CRM
I welcome any guidance you have on migrating MS Access into CRM. I will need to manipulate / programmatically process the Access data to get it into the correct locations in CRM. My thought is to import Access into Creator and work from there. A key question
Set up email to not send when administrative fields are filled in or edited
I have a form set up to email users on submission, edit, and deletion. We have 2 administrative fields in the form that are hidden from the user. When the administrative fields are edited, I do not want an email to be sent. I can't find a way to say,
Successful Form Submission script only working on edited
This seems to be very odd, as I created a scratch pad application to test this, and I couldn't reproduce the scenario. However, in our main application, when a new booking is submitted the Successful Form Submission only fires if you recall and update
How to limit fields to those visible in report when editing a record
I created a report that only shows 10 fields. The form this report is based on has 100 fields. When a user clicks "Edit" for a record, I would like only the 10 fields in the report to be visible in the Edit view rather than all 100 fields in the form. Is there a way to do this?
Variable - Does not exist in SubForm
In an attempt to work around the bug that stops me from being able to pass a new form or subform row to a function, I'm trying to use formula fields instead. However, because I can't reference a formula field in another formula field I'm having to try
Hide/Show fields conditionally in SubForms
I have created a subform in a Zoho Creator form entitled "Household Members". I have a few questions within the subform row that need to be shown or hidden based on the answer to other questions in the row. For example, I have a question (radio button)
Display produits images and informations like cart
I'm New in Zoho creator Please i want to display products from other form like this. And when i click on it, it should be add to the list like in the image in the top. Help please.
URGENT - Zoho Creator - Data Decryption - How to decrypt.
Hi all, Zoho creator appears to have encrypted 14 records in a table on an app I have created. There are around 160 records in this table and the only ones that are encrpted are the last 14 entered. I have attempted to decrypt the data, but this has
Multi Line vs Notes Fields
What is the difference between the two?
Call Log Access to Mobile Device
Hi, Is there any way in Zoho to access the call log from the mobile device to generate a report in the mobile app?
Iterate over loop
Hi, I have the following script setup to create PDF voucher based on the input.Number_Of_E_Vouchers , e.g. if the value is 4, 4 vouchers will be generated, but seem the loop stopped after generating 1 voucher, is there any coding issue with the below
How to fetch data from Zoho Inventory into Zoho Creator
response = zoho.inventory.getRecords("Item","i inserted ID in here"); var = response.get("Product Name"); for each hey in var { insert into SKU #SKU is a form in Zoho Creator [ Added_User=zoho.loginuser Item_Name=hey #Item_Name
Hiding reports from admin
I need to create several reports with filtered data and give access to them only to specific users. However, as an administrator I have a ‘master’ view and don’t want to clutter my menus with all these variants of the same report. Is there a way to hide reports from an administrator but still have them visible to other users?
Subform Totals
Apologize in advance. I have seriously tried to find a solution through the many previous posts with no success. Basically I am trying to build what the invoice app does, for subtotals. My workflow is to enter a total invoice amount and then split that
On Submit - Add Data to New Table
Hi, I have a form with a main section and 1 subfrom, based on another form. When I submit, I want to create new records in another table, for each row in the subform, copying all the main data with it. For Example: Name: John Smith Title:
Importing more than 5MB and more than 100000 rows in Zoho creator
Hi All, Hope you're all doing well and staying safe during this crazy time, I'm reaching out because I'm trying to create a Database of contacts using Zoho creator but I have some limitations as my files are more heavier than the required one and I believe
error occured please contact application owner
when i upload my address proof to chegg india zoho creator it shows "error occured please contact application owner. what to do? help..
Next Page