How To Prevent User from Adding or Deleting a Row in a Subform?
Is there any way to prevent a user from adding or deleting rows in a subform? I preload the subform tables with just the rows I want the user to update and I don't want them to add or delete any of the rows. The number of rows in the subform will depend on data in the parent, so I cannot use the feature that limits the number of rows (and that feature doesn't help me in preventing the user from deleting rows). Jon
I can't push the uploaded image from the app zoho creator to crm
How can i push the uploaded image to crm? I already created the code for it but its not working. newEmployeeInfo = Map(); newEmployeeInfo.put("Name",input.Name); newEmployeeInfo.put("License_or_ID",input.ID1); response = zoho.crm.createRecord("Employees",newEmployeeInfo);
Parent Child Form
I want to calculate Job Count but I didnt Pls help me
Google Address Validation API (JSON issue)
Hello, I am trying to build address verification with Google API as per instructions here - Validate an address | Address Validation API | Google Developers I am required to pass JSON body as follows: curl -X POST -d '{ "address": { "regionCode":
Auto fetch records App B from App A
Hi I am to fetch records between apps from App A to App B and I tried some deluge code and functions but I got two Issues. Code from App A ---------------- string getApprover(int Admission_ID) { fillName = Admissions[ID == Admission_ID].Name.firsN;
Summary Report
Hi all, We send test reports to clients in PDF format. The client has requested to receive the data as CSV. Our system is set up with the main form called "Groups", and sitting inside that is a subform called "Samples". The samples subform contains a
Use approval workflow comments in record scripts
Greetings, i'm running an approval workflow for my records, during approval/rejection there is a step where comments are entered. i want to add there comments to the record and to use them in various deluge scripts like sending emails and so on. how
Passing Variables from Widget to Page
Hi is it possible to pass variables from a Widget embedded in a Page back to the page - and allow this variable to be used via HTML snippet, ZML or Deluge? alternatively, how can a widget redirect to a form (not published) with variables (#Form:Myform?field=variable)
Send record reference when redirecting to a form
Greetings, i need to add "rejection" button to records in my report. when this button is clicked it will redirect the user to a rejection form (unrelated to the original report's form) where they can fill rejection details, but i want to also refer to
how to make reports record button disabled?
Greetings i'm looking for a way to make buttons of records that has certain status disabled, something similar to what the creator's quotation management does, but i can't find the scripts that achieve this purpose there..how can i do this?
Data base
Hello, I would like to know if the Zoho Creator platform can be used to create a system only for the administrative part of my company and I need a database that can be interconnected between different areas, and I would like to know what benefits and
Create Product, Quantity
How we achieve this? Task 1: Create form to store the products Task 2: Whenever the product is purchased, the stock should be increased Task 3: Whenever the product is sold, the stock should reduce
Dispatch Track Integration?
Has anyone been able to integrate Dispatch track with zoho? I want the 2 programs to "talk " with each other.
Add query string parameters with record redirect action
Greetings I have a page that displays dynamic content based on record id sent in query string parameter in the url. i need to access this page via record actions from report..so i have a report that contains many records, i defined my redirect action
Zoho Creator - Customer Portal API Access
Is it possible to create new customers in the customer portal through and API? I've been looking through the documentation and don't see anything.
Export form and subform data into spreadsheet
Hi How do i export my data from a form with subform into spreadsheet where the subform with multiple rows are exported into individual rows and columns? If i do a normal export, it join all the subform data into a column seperated by space/comma. I need
How to autofill lookup field within subform?
Hello. I need help using deluge to autofill a subform lookup-field depending on selection made from dropdown field within the subform. Please see details below. Thank you for your help! Chris Main Form: "Add_Customer" Subform: "Programs" Lookup Field
Import data from reports to page
Greetings basically i have a form that users can fill and submit, upon submission new reports are created with the data that was entered by users. i want to create a page that shows such data dynamically.. so i have the reports list that contains: report
Create Multi Entities Portal over (or above) Portals
Hi all, Case: Solution is build in Creator to be used by clients of multiple offices. Each office is an independent company with its own unique customers. Is Creator able to create a 'Super' Portal te manage many offfices and give them the admin right
UPLOAD JOB FROM ZOHO CREATOR
HI GUYS I HAVE ONE FORM IN ZOHO CREATOR NAMED AS JOB UPLOADING. I WANT TO KNOW IF THERE IS ANY METHOD FROM ZOHO CREAOTR TO UPLOAD JOB DIRECTLY TO WEBSITE , WITHOUT USING RECRUIT ? AS I AM NEW TO ZOHO NEED SOME HELP
Zoho Creator: Using Forms in "Detail View"
I'm having an issue with the sizing of a form opened within detail view. Can someone take a look at this short clip and maybe point me in the right direction? Thanks! https://www.loom.com/share/513860387b084153a844ddc84d513ecc
rebranding more than one logo
Hi, I have developed two applications for use with two sections of my company, with two different logos. I have found that the logo currently is universal, i.e., appears on all apps under my user account. Could you work out a way so that we can rebrand app specific logos? Thanks!
Concat more than two values
I want to concat more than 2 elements. For example --------------------- variable = 5; Message = concat("you have", variable, "days left"); --------------------- The above code doesn't work. Any advice? Sorry for this noob question.
Zoho Creator | Upcoming Updates — Sep 2022
Hi all, Greetings from the Zoho Creator team! We've got some interesting updates for you today—and rest assured, there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month. A few of these will be available
[URGENT] Allow reorder (drag&drop) of subform record
Very simple user case: a wedding planning app where you want to send your client a form to fill with information about their wedding. Form includes some field for general purpose information and a subform for event pacing/schedule. Clients are invited to create a new row (When? - What? - Where? - Who?) for each thing happening during their wedding chronologically. Ex: When What 10h Something TBD Speech After speech Yet another thing happening
Upsert a record in the CRM
Hi Im building a customer portal. The user's details are already in the CRM. I want them to login to the customer portal and see a form that is autopopulated with their Contact record's details from the CRM. I have done this and its working. However,
Updating Sub-from with a Main-form value during insert into function
Hi All, I have an auto-num field Quote_ID in a main form and on successful submission I run a loop to update a numeric field Quote_ID in the subform of the main form. for each line in Line_Items { line.Quote_ID=input.Quote_ID; } I have a workflow where
Published Form not displaying correctly on Mobile
I have a published form that contains a single-line field which has been configured for Barcode/QR input for Mobile devices. When I access the form using the permalink, the form displays as the desktop version rather than mobile version and the QR input
Map Dependency Fields in Creator
Hello, has anyone been able to map field dependencies in creator like you can in CRM? i have an app i have built for inventory and i would like that when i click on a manufacturer in the model field it will only show the certain ones for that manufacturer.
Fetch data from form to form but different apps
Hello I have a question and I am beginner in Zoho Creator. My question is it possible to fetch data from form to form but the apps will be different for example I want to make two form and the first one will has as input 'Admission ID' and same for the
What happens to Zoho Creator if Zoho goes bust?
Hi, I am doing a risk assessment for my business at the moment and one of the most obvious risks is 'Zoho goes bankrupt and stops supporting Zoho Creator'. What is Zoho's policy here? A similar question was asked about Zoho Mail. The answer there was 'you can export your data'. That's fine for data but how about code? What use will Deluge script be if Zoho ever folds? Would Zoho release the code for the platform if they do go bust? I notice there used to be an option to run Zoho Creator apps on Google
how to change creator's GUI language?
Greetings It seems that zoho creator detects your region and sets the GUI language to that automatically..first of all this is just a bad idea, let users choose their preferred language or just import GUI language from user's account settings. my GUI
Multiple openurl statements "On Success"
How can I open multiple windows on success to print various record summaries? Right now if I have multiple openurl statements it just opens the last one. Any ideas?
Nested If Statements
Having a problem creating a nested if statement. This works: if((Imported_BPD > -1),Imported_BPD,((Feet * 12 + Inches + Quarter - Previous_Production_Inches) / ((Date_Time - Previous_Date_Time) / (1000 * 3600 * 24)) * Tank_Factor)) However, I am wanting to add another check to say if the formula is <0, then BPD = 0. Here is what I have tried but can't get it to work. Formula Field Both the argument should be same type for 'IF' task. Expecting 'IF' expression found 'BIGINT' expression
On Mobile, Closing a Popup/New/Same window via the "On Submit" of a form
I think I have found a Creator Bug. Or can someone help with a workaround? Scenario: I have an app that is used primarily through the Zoho Creator iPhone mobile app. As part of a custom workflow on report, when a user taps a button, it executes this deluge
Hierarchy of Menus
Right now the menu options are a limited to two levels (the parent and child), and can get crowded if you have a lot of forms and views in your database. Are you planning to add a feature with Menus and Sub-menus (e.g., grand children, great grand children) in a hierarchy, so that space can be better utilized?
How to include css/html on all pages in a Customer Portal?
Hi all, Im currently building a customer portal in Creator. What the best process of adding external css styles and html so all the pages in the customer portal have the same style? If this were a website I would create a header/footer php pages and include
There needs to be a single, universal way to TEST for EMPTY INPUTS
I am so sick of having to code multiple conditions just to see if a field is empty or not. EXAMPLE SITUATION I have a Validation workflow that runs when a user hits Submit on a form. The workflow looks to see if the user filled in a required field (Before
How to integrate zoho creator with google drive?
1. Create record in Zoho Creator 2. Deluge sends record data to Google Apps Script 3. Google Apps Script creates a folder with and returns the url to the folder 4. Zoho Creator receives the response and updated the Url field of the record 5. Users can use the Url to access the Google Drive Folder How can i do it?
Update status field of record in Zoho Creator when document signed in Zoho Sign
Hi, I have a Creator app that sends a document via Zoho Sign when a record is entered. I want to updated a status field in this record when the document is signed. I think i need to set up a web hook in Zoho Sign to point to the url of the report the
Next Page